Month: January 2008

using trunc and round I cannot get lower than -4800 nor higher than 10001 😈 SQL> select trunc(date ‘-4712-1-1′,’CC’) from dual; TRUNC(DATE’-4712-1-1′,’CC’) ———————————- Thursday 1st January 4800 B.C. SQL> select round(date ‘9999-01-01′,’CC’) from dual; ROUND(DATE’9999-01-01′,’CC’) ———————————- Monday 1st January 10001 A.D.

Is there any rule where you can use scalar subquery? You can use a scalar subquery expression in most syntax that calls for an expression (expr). Well, you cannot use it as the second argument of sys_connect_by_path select sys_connect_by_path(ename, (select ‘/’ from dual)) from emp connect by prior empno=mgr; * ERROR at line 1: ORA-30003: […]

I made a funny typo today 🙂 SQL> select * from t1; X 0 SQL> select 1.x from t1; X 1 Should not I get ORA-904 invalid identifier 😕 ?

The 11g OCP certification should be available this year. You can register for the production exam 1Z0-050 New Features on Prometrics and pass the exam on Mon Feb 18th or later, the OCA exams 1Z1-051 SQL Fundamentals and 1Z1-052 Admin I are in beta and the OCP exam 1Z1-053 Admin II is planned for early […]