Interested to Buy Any Domain ? << Click Here >> for more details...
if we give update table_name set column_name= default.
what will happen?
its given in pl sql block.what will hapen?
- 5 Answers
- 11813 Views
- iFlex, I also Faced
- E-Mail Answers
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
Which tcp/ip port does sql server run?
How do you explain an index?
what is transaction? : Sql dba
what is the command used to fetch first 5 characters of the string? : Sql dba
What is a sql driver?
Is microsoft sql free?
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
What is a temporal table?
What is the difference between drop and truncate commands?
What is the use of prepared statement?
What are the operators in sql?
What is union?
when MSQL8.0 is in market
what is query cache in mysql? : Sql dba
Why stored procedures are faster than query?
