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 |
What are the tools for Oracle ?
What is a schema in oracle?
What are the set operators union, union all, minus & intersect meant to do?
Is rowid unique in oracle?
What are the different types of databases?
What is the difference between truncate & delete command?
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
Explain the characteristics of oracle dba?
what diffrence between function and procedure?
How to convert numbers to characters in oracle?
what is the syntax of UPDATE command?
How to turn on or off recycle bin for the instance?