It is standard O/S File.
Type: Posts; User: chandra.pc; Keyword(s):
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');