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 5969

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

 3 9335

What is Overloading of procedures ?

 2 6755

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

Symphony,

2 8793

What are two parts of package ?

Infosys,

2 16689

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

JDA,

2 15783

How packaged procedures and functions are called from the following?

 2 5833

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

 3 11013

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 6629

what is sql and plsql

 6 10116

what is the difference between to_char and to_date functions?

Infosys,

10 65323

what is organisational index?

 1 4828

what are the advantages of cursors than procedures?

 2 11348

what is the difference between trigger and storedprocedures

Tech Mahindra,

16 29933

What is a 'instead of trigger'?

Eenadu, TCS,

3 12252

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

how to create a new view in mysql? : Sql dba

730

What are tables and fields in the database?

798

Can we insert in sql function?

810

what is the difference between char and varchar data types? : Sql dba

797

What is a field in a database?

802

How does an execution block start and end in pl sql?

720

Explain the select statement in sql?

868

How can triggers be used for the table auditing?

805

What are the different ways to optimize a sql query?

722

What is cursor status?

961

how to extract a unit value from a date and time? : Sql dba

776

Describe different types of general function used in sql?

773

Can two tables have same primary key?

772

What is time based sql injection?

739

What is sqlerrd?

756

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