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 5469

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

 3 8759

What is Overloading of procedures ?

 2 5905

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

Symphony,

2 8275

What are two parts of package ?

Infosys,

2 15651

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

JDA,

2 15144

How packaged procedures and functions are called from the following?

 2 5327

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

 3 10356

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 5777

what is sql and plsql

 6 9369

what is the difference between to_char and to_date functions?

Infosys,

10 62968

what is organisational index?

 1 4118

what are the advantages of cursors than procedures?

 2 10732

what is the difference between trigger and storedprocedures

Tech Mahindra,

16 27221

What is a 'instead of trigger'?

Eenadu, TCS,

3 11527

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What does := mean in pl sql?

548

Is it important to partition hard disk?

524

What is a sql*loader control file?

611

Is sql similar to python?

527

Can we commit in trigger?

539




Can you call pl/sql package functions from within a fast formula?

558

What is pl sql script?

554

What is pls integer?

576

Are null values same as that of zero or a blank space?

519

What does (*) mean in sql?

521

What pl/sql package consists of?

626

What is $$ in sql?

541

What is a string data type in sql?

508

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

638

What is blind sql injection?

563

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