SQL PLSQL Interview Questions
Questions Answers Views Company eMail

what is the difference between granting and creating a view?

2 5072

How to return multiple records from procedure?

2 7953

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

2 5654

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

4 8917

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

2 5638

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

2 6546

what is ref cursor in pl/sql?

3 20907

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

3 9078

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

PreVator,

4 7707

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

Fujitsu,

2 12098

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

PreVator,

7 17244

How the execution will be done in exceptions?

2 5963

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

3 11284

what is the forward decleration in packages?

1 5134

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

3 5775


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Can a view be mutating? If yes, then how?

553


Can we perform dml in function?

567


What is the purpose of normalization?

515


What are commit, rollback, and savepoint?

546


Can we join two tables without common column?

487






Is it possible to sort a column using a column alias?

588


how to get help information from the server? : Sql dba

507


Can triggers stop a dml statement from executing on a table?

589


What is the default isolation level in sql server? : Transact sql

542


What is index example?

531


How to change the order of columns in Oracle SQL Plus ?

591


What is nosql vs sql?

541


what are string data types? : Sql dba

486


What is the importance of sqlcode and sqlerrm?

822


What is procedure and function in sql?

513