1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
SQL PLSQL Interview Questions
Questions Answers Views Company eMail

Explain uses of cursor.

 1 1026

Explain 3 basic parts of a trigger.

 815

Show code of a cursor for loop.

 568

What does closing a cursor do?

 752

How many triggers can be applied to a table?

 585

How would you reference column values before and after you have inserted and deleted triggers?

 614

Show the cursor attributes of pl/sql.

 594

Which data dictionary views have the information on the triggers that are available in the database?

 739

What are the events on which a database trigger can be based?

 576

What is out parameter used for eventhough return statement can also be used in pl/sql?

 571

What packages are available to pl/sql developers?

 582

What does the base_object_type column shows in the user.triggers data dictionary view?

 562

What are the rules to be applied to nulls whilst doing comparisons?

 733

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

 674

Explain two virtual tables available at the time of database trigger execution.

 1 846

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What are the parts of a sql statement?

540

What are the advantages of pl sql over sql?

533

How do you write a complex sql query?

570

What is difference between sql function and stored procedure?

496

how can we submit a form without a submit button? : Sql dba

524




in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

1634

What is difference between table and view?

507

How does postgresql compare to oracle/db2/ms sql server/informix?

547

What are the uses of sysdate and user keywords?

609

What is the benefit of foreign key?

516

What programs use sql?

515

Why is normalization important?

523

Why do we use %rowtype & %type in plsql?

587

What are the 3 types of behavioral triggers?

645

What are some emotional triggers?

560

For More Un-Answered { SQL PLSQL } Questions Click Here