1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
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 4586

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

 4 9376

which will fire first ? Trigger or Constraint

i2, IBM,

24 44664

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 10960

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

IBM, TCS, UHD,

12 23982

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

iFlex,

4 8096

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

iFlex,

5 9766

how will u find statistics of a database objects?

iFlex,

2 7152

Differences between UNIQUE and DISTINCT in select statements

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

26 127710

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 6783

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 9616

What is pragma exception and how, when, where us

 5 13687

What is the usage of NVL?

Infosys, Micro Infotek,

7 18826

scope of exception handling in plsql

Wipro,

4 11283

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 6636

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What are character functions?

628

Is sql microsoft?

544

How can we debug in PL/SQL?

655

What is delimiter sql?

541

What are triggers and its types?

551




What is sql trigger example?

535

Write a query to display the current date in sql?

511

Why do we use function in pl sql?

553

Is ms sql traffic encrypted?

503

Why triggers are used?

554

What is the maximum database size for sql express?

533

What is the difference between a database and a relational database?

558

What is clustered index in sql?

582

How do you use collections in procedure to return the resultset?

1786

what is a trigger in mysql? : Sql dba

599

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