How to create a server parameter file?
Can you create a synonym without having a table?
How to retrieve 5th highest sal from emp table?
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
What are the logical operations?
How to add a new column to an existing table in oracle?
what is shell?
How is it different from a normal table?
How to turn on or off recycle bin for the session?
How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?
When do we use group by clause in a sql query?
How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.
How to call a stored function in oracle?