Hello All,
Could any one provide me FAQs/interview questions on
oracle PL/SQL
Answer / krishna
Plese see thin link: http://www.orafaq.com/wiki/PL/SQL_FAQ
| Is This Answer Correct ? | 1 Yes | 0 No |
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
6. Display the client name and order date for all orders using the traditional method.
What are synonyms used for ?
what is the syntax of SELECT command?
hai, when to use char and varchar2....?
Can you tell me how to add new column in existing views?how?How is possible?
difference between procedures and function?
what happened to the global index when I truncate the data in one of the partition?
What are steps required to ENTER DATA INTO DWH?
What is snapshot is too old? Give and example for better understand.
I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.
5 Answers Microsoft, Oracle, TCS,
What do you mean by a deadlock?