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
What is sql exception?
Why having clause is used in sql?
How exception is different from error?
What is cursor in pl sql with examples?
Can two tables have same primary key?
What are the different parts of a package?
How to select all records from the table?
Are subqueries better than joins?
What is primary key and foreign key?
Can we call stored procedure in function?
What are some emotional triggers?
How do I access sql anywhere database?
What do you understand by pl/sql packages?
what is the difference between group by and order by in sql? : Sql dba
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?