SQL PLSQL Interview Questions
Questions Answers Views Company eMail

I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?

1 4572

if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 9343

which will fire first ? Trigger or Constraint

i2, IBM,

24 44535

Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?

eBay,

3 10930

How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?

IBM, TCS, UHD,

11 23658

if we give update table_name set column_name= default. what will happen?

iFlex,

4 8058

if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

iFlex,

5 9740

how will u find statistics of a database objects?

iFlex,

2 7115

Differences between UNIQUE and DISTINCT in select statements

ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,

26 127508

how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above insert values to get the result as 40:35:00

3 6758

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible

9 9574

What is pragma exception and how, when, where us

5 13662

What is the usage of NVL?

Infosys, Micro Infotek,

7 18768

scope of exception handling in plsql

Wipro,

4 11249

How to create a table using constraints... IF i change the PARENT KEY value ,then CHILD KEY table will also to change in the another table... plz reply ur answers @ mak2786@gmail.com Arunkumar

3 6612


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What does plv msg allows you to do?

658


differentiate between float and double. : Sql dba

549


what is the difference between ereg_replace() and eregi_replace()? : Sql dba

538


Write a sql query to get the third highest salary of an employee from employee_table?

616


What are properties of the transaction?

545






What are the types of queries in sql?

508


What is sql rowcount?

546


Do prepared statements prevent sql injection?

515


Is big data nosql?

503


How is pl sql different from sql?

525


What is rownum in sql?

547


Why do we use %rowtype & %type in plsql?

585


what is a database? : Sql dba

595


Which is better varchar or nvarchar?

534


Will truncate release space?

508