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

what is the difference between granting and creating a view?

 2 5119

How to return multiple records from procedure?

 2 7972

How to come back in normal stage in Mutating Table if mutating table is locked or update data?

 2 5682

Can we relate two different tables from two different users in ORACLE,PL/SQL?

 4 8976

How to get the procedure's, function's name from a package if it is wrapped(both spec & body).

2 5672

If records are inserted into table without committing.How to refer to these values in a procedure?

2 6570

what is ref cursor in pl/sql?

 3 20948

How to fetch the rows by dynamicaly passing table name through cursor?

 3 9129

what is difference between "Primary key" and "Unique key"?

PreVator,

4 7752

can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?

Fujitsu,

2 12127

Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?

PreVator,

7 17324

How the execution will be done in exceptions?

 2 5994

What is the difference between sql/pl-sql/embeded sql?

 3 11307

what is the forward decleration in packages?

 1 5157

In packages the source code is compiled into p code ? how do we describe the p code

 3 5815

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Define sql delete statement.

550

Can a commit statement be executed as part of a trigger?

597

What is rename in sql?

542

how can we know the count/number of elements of an array? : Sql dba

564

What does the sign mean in sql?

497




What are inner outer left and right joins in sql?

503

What is t sql used for?

544

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

555

how can I make a script that can be bi-language (supports english, german)? : Sql dba

527

what is a constraint? Tell me about its various levels. : Sql dba

554

When is the update_statistics command used?

566

Can pl sql procedure have a return statement?

539

What is sql and db2?

525

What is minus?

537

Which join condition can be specified using on clause?

508

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