if we give update table_name set column_name= default.
what will happen?
its given in pl sql block.what will hapen?
Answer Posted / ehtesham malik
if you set default value then it will update column with
null value.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Enlist the data types that can be used in pl/sql?
How to assign sql query results to pl sql variables?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
How do I run a sql trace?
Are pl sql variables case sensitive?
What is the purpose of cursors in pl/sql?
Does pl/sql support create command?
How do I order by ascending in sql?
What is the difference between delete, truncate and drop command?
how to run 'mysql' commands from a batch file? : Sql dba
Should I use mbr or gpt?
What are the two different parts of the pl/sql packages?
List different type of expressions with the example.
How many disk partitions should I have?
What are the types of index in sql?