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 4572if i perform any operation on views such as insert, delete etc will my base table get affected?????
4 9343Can 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 10930How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
11 23658if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?
5 9740Differences between UNIQUE and DISTINCT in select statements
ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,
26 127508how 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 6758I 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 9574How 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
What does plv msg allows you to do?
differentiate between float and double. : Sql dba
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
Write a sql query to get the third highest salary of an employee from employee_table?
What are properties of the transaction?
What are the types of queries in sql?
What is sql rowcount?
Do prepared statements prevent sql injection?
Is big data nosql?
How is pl sql different from sql?
What is rownum in sql?
Why do we use %rowtype & %type in plsql?
what is a database? : Sql dba
Which is better varchar or nvarchar?
Will truncate release space?