if we give update table_name set column_name= default.
what will happen?
Answer Posted / kolla radha sri seshu
In SQL you will get the message 'X' rows updated
In PL / SQL you will get the message pl / sql procedure
sucessfully completed
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is bulk collect in pl sql?
What is a sql schema used for?
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 the maximum database size for sql express?
How are sql commands classified?
what is the difference between where clause and having clause? : Sql dba
How does postgresql compare to mysql?
What are dml commands?
How many sql statements are used? Define them.
Why truncate is faster than delete?
how to escape special characters in sql statements? : Sql dba
What are pl sql procedures?
Are sql database names case sensitive?
What are the types of optimization?
How many tables can a sql database have?