if ( (LENGTH(TRIM(TRANSLATE(contentcode, ‘+0123456789′,’ ‘))) is not null) or (LENGTH(TRIM(TRANSLATE(otherfield, ‘+0123456789′,’ ‘))) is not null)) then dbms_output.put_line(‘contentcode or otherfield is invalid’);
1. in browser type url ip-Of-Server:1158/em/console/ in browser type url ip-Of-Server:1158/em/console/ login there go to Schema-> Directory Objects click the “create” Button fill in the form * Name DIR_WLIST * Path /tmp/test_v_dir where Name= name of virtual directory and Path= path to the directory now thru ftp client (or putty ) create… read more →
Solution 1 SQL> CREATE TABLE dates (date1 DATE, date2 DATE); Table created. SQL> SQL> INSERT INTO dates VALUES (SYSDATE, SYSDATE-1); 1 row created. SQL> INSERT INTO dates VALUES (SYSDATE, SYSDATE-1/24); 1 row created. SQL> INSERT INTO dates VALUES (SYSDATE, SYSDATE-1/60/24); 1 row created. SQL> SELECT (date1 – date2) FROM dates;… read more →
SQL is a functional language. Try to think of a SELECT statement as a function. That is, a mathematical function, or mapping, which — this is important — maps an input to an output. When you select data from a table, think of the table as a source. Data streams… read more →