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


Please Help Members By Posting Answers For Below Questions

Enlist the data types that can be used in pl/sql?

747


How to assign sql query results to pl sql variables?

674


what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

728


How do I run a sql trace?

692


Are pl sql variables case sensitive?

770






What is the purpose of cursors in pl/sql?

798


Does pl/sql support create command?

743


How do I order by ascending in sql?

741


What is the difference between delete, truncate and drop command?

751


how to run 'mysql' commands from a batch file? : Sql dba

777


Should I use mbr or gpt?

727


What are the two different parts of the pl/sql packages?

791


List different type of expressions with the example.

698


How many disk partitions should I have?

719


What are the types of index in sql?

775