Sign Up Login


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

Give the structure of the function ?

 2 5937

Explain how procedures and functions are called in a PL/SQL block ?

 3 9290

What is Overloading of procedures ?

 2 6698

What is a package ? What are the advantages of packages ?

Symphony,

2 8737

What are two parts of package ?

Infosys,

2 16651

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

JDA,

2 15751

How packaged procedures and functions are called from the following?

 2 5806

Name the tables where characteristics of Package, procedure and functions are stored ?

 3 10974

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

iFlex,

2 6579

what is sql and plsql

 6 10054

what is the difference between to_char and to_date functions?

Infosys,

10 65197

what is organisational index?

 1 4776

what are the advantages of cursors than procedures?

 2 11309

what is the difference between trigger and storedprocedures

Tech Mahindra,

16 29706

What is a 'instead of trigger'?

Eenadu, TCS,

3 12206

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what is single byte over head in oracle..?

2136

what is the bond code in materialized view?

2707

Can we write ddl statements in functions?

825

How many tables can you join in sql?

727

Are sql connections encrypted?

777

What is a primary key called that is made up of more than one field?

1062

How do I create a memory optimized filegroup?

728

Define tables and fields in a database

867

How do I view output in sql developer?

845

How can you get sql*loader to commit only at the end of the load file? : aql loader

778

Is sql a oracle?

719

What is trigger with example?

763

Does normalization improve performance?

803

Can we use commit inside a trigger?

795

Mention what does plv msg allows you to do?

874

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