Differentiate between function and procedure in oracle.
"primary key=unique+null" is equal,reson?not,reason?
How to establish administrator authentication to the server?
What is translate in oracle?
what is view?
Explain oracle insert into command?
How to retrieve 5th highest sal from emp table?
SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me
How to revoke create session privilege from a user in oracle?
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
How do I learn what codesets are available in oracle?
query to find the maximum no persons with same age(age colomn) from emp table
What is a read only transaction in oracle?