Home » Page 95

How to Solve ORA-29280: invalid directory path

ORA-29280: invalid directory path  is a common error when doing file handling operations in the Oracle database Reason and Resolution for the error (1) This occurs if the directory specified does not exists in utl_file_dir init.ora parameter sqlplus / as sysdba show parameter utl_file_dir /tmp, /usr/tmp/ SQL> declare F_LOG utl_file.file_type; begin F_LOG := utl_file.fopen(‘/u500′,’j’, ‘w’); …

How to Solve ORA-29280: invalid directory path Read More »

Cross Join in Oracle

This SQL tutorial focuses on cross join in Oracle, and provides explanations, examples A CROSS JOIN  in Oracle is a JOIN operation that produces the Cartesian product of two tables. i,e if one of the table is having 100 rows and another one 8 rows, then cross join will produce 800 rows Here table emp …

Cross Join in Oracle Read More »

oracle join syntax examples

There are various joins in Oracle like inner join,left outer join,right outer join,full outer join,cross join. This SQL tutorial provides oracle join syntax on each of them with examples Inner Join syntax and ExampleTwo tables examples and syntax SELECT EMP.EMPNO,EMP.ENAME, DEPT.DEPTNO,DEPT.DNAMEFROM EMP , DEPTwhere EMP. DEPTNO= DEPT. DEPTNO; or ANSI syntax SELECT EMP.EMPNO,EMP.ENAME, DEPT.DEPTNO,DEPT.DNAMEFROM EMP INNER …

oracle join syntax examples Read More »

Scroll to Top