Hello All,

Could any one provide me FAQs/interview questions on
oracle PL/SQL

Answer Posted / krishna

Plese see thin link: http://www.orafaq.com/wiki/PL/SQL_FAQ

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

1704


List out the components of logical database structure of oracle database.

585


What happens to the current transaction if a ddl statement is executed?

580


In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1366


master table and child table performances and comparisons in Oracle ?

1668






What is the difference between post-database commit and post-form commit?

517


What is recycle bin in Oracle?

722


What is where clause in oracle?

534


Why we use bulk collect in oracle?

541


What is a select query statement in oracle?

545


How to unlock the sample user account in oracle?

558


What is the difference between truncate & delete command?

619


How to load excel data sheet to oracle database

592


Explain oracle instance.

686


Explain cascading triggers.

574