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 5393if i perform any operation on views such as insert, delete etc will my base table get affected?????
4 10806Can 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 12387How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
12 29258if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?
5 11641Differences between UNIQUE and DISTINCT in select statements
ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,
26 135679how 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 7904I 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 11999How 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 7736
What are the commands used in sql?
explain the advantages and disadvantages of stored procedure? : Sql dba
Show the two pl/sql cursor exceptions.
How do I run sql profiler?
how to create a new table by selecting rows from another table in mysql? : Sql dba
What is sql profiler in oracle?
Which table is left in left join?
Explain foreign key in sql?
What is delimiter sql?
Why use subqueries instead of joins?
How do you respond to dementia behavior?
Which language is used in sql?
What is set serveroutput on?
What does fetching a cursor do?
What are secondary keys?