if we give update table_name set column_name= default.
what will happen?
its given in pl sql block.what will hapen?
Answer Posted / gopal
If default is speceified for the table then it will update
with default value. Else it will update null values
Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How does one load ebcdic data? : aql loader
What is clustered index sql?
What is execution plan in sql?
what is timestamp in mysql? : Sql dba
Is trigger a stored procedure?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
Explain about various levels of constraint.
What are the ways on commenting in a pl/sql code?
What are the two types of exceptions.
what's the difference between a primary key and a unique key? : Sql dba
How many aggregate functions are available there in sql?
How do I save the results of sql query in a file?
How do you update a sql procedure?
What is number function in sql?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10