Sign Up Login


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

how a reference cursor works?what all adnvantages are gained with it..specify the situation?

TCS,

4 12128

what is Hash join?how it is different from inner join?what is the sign used for inner join?(eg: like the (+) sign used for outer join)?

TCS,

3 16659

how instead of triger is helpful for mutating tables errors handlling ?

Oracle,

2 9998

How to execute OS(operating system) command from pl/sql?

 3 9723

What is the best strategy to use COMMIT in a pl/sql loop?

 3 9276

Which one is the Best approach to put code, among Triggers and Procedures? Explain?

Sierra Atlantica,

1 4936

Does SQL*Plus contains pl/sql Engine?

TCS,

1 9761

How to find string or key value using pl/sql code?

Ramco,

2 9631

what is the purpose of update command in oracle?

MBT,

7 12471

What are the advantages of the packages

Oracle,

6 10952

what are the advantages of primary key over unique+notnull

Consultancy, LGS, Oracle,

7 20910

how to retrieve the top 3 salaries of the table using rownum

Oracle,

31 36992

what are the forced views

Hexaware, TCS,

6 24420

what is the difference between union and union all

IBM, Luxoft, Oracle,

14 43827

what is hash join

NCR,

1 13206

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How to avoid duplicate records in a query?

749

Can you rollback after commit?

717

What is a table in a database?

786

What are the types of keys?

671

What is the use of %rowtype?

747




What is user defined functions?

746

what are the type of locks ? : Sql dba

720

how to use in conditions? : Sql dba

693

How can check sql version from command line?

722

How many scalar data types are supported in pl/sql?

716

What is identity column in sql server?

718

what is the use of friend function? : Sql dba

727

What is sql key?

691

Can there be more than one function with a similar name in a pl/sql block?

748

What is primary key sql?

713

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