Search:

It is standard O/S File.

Use Right Outer Join.U get the result

SELECT *
FROM <table-name>
ORDER BY TO_CHAR(datecolumn,'D');

Hi friends, i have one problam,please give me the solution. I have column in a with name.now i want to select that names as first name,second name,third name. I/p---- names chandra sekhar balaji....

It comes under Implicit Cursor.

Yes,It is possible by using AUTONOMOUS_TRANSACTION.

SELECT ename
FROM emp
WHERE SUBSTR(ename,1,1) IN('A','B','C',-----------'K');