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

Explain the rollback statement?

 671

What is exception? What are the types of exceptions?

 677

How to execute a stored procedure?

 657

What is mutating table error?

 761

Explain ddl statements in pl/sql?

 648

How to return multiple rows from the stored procedure?

 621

What is the life of an sql statement?

 615

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

 636

What steps server process has to take to execute an update statement?

 605

Can %notfound return null after a fetch?

 677

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

 758

Determine if oracle date is on a weekend?

 651

How to create a menu in sqlplus or pl/sql?

 694

How to use boolean type in select statement?

 661

How to check if a column is nullable before setting to nullable?

 666

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is synonyms?

675

What is full form of rtm?

616

What are the different parts of a package?

717

what is the difference between sql and t-sql? : Transact sql

698

What is the benefit of foreign key?

619




how can you see all indexes defined for a table? : Sql dba

626

Can we connect to postgresql using sql developer?

579

How many disk partitions should I have?

636

Define sql delete statement.

657

What is trigger in sql and its types?

642

Is natural join same as inner join?

589

How can the performance of a trigger be improved?

684

how to rename an existing column in a table? : Sql dba

591

What is sqlerrd?

616

What is the difference between cluster and non-cluster index?

715

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