IT WILL UPDATE NULL IN THE COLUMN IF YOU NOT PROVIDE ANY VALUE.

if we give update table_name set column_name= default.
what will happen?

its given in pl sql block.what will hapen?

Question Posted / guest

Answer Posted / guest

IT WILL UPDATE NULL IN THE COLUMN IF YOU NOT PROVIDE ANY
VALUE.

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3311

What is the difference between sql and t sql?

717

Can a procedure in a package be overloaded?

754

Do we need to rebuild index after truncate?

703

How do you optimize a stored procedure query?

738

what is the difference between undefined value and null value? : Sql dba

783

How many subqueries can be nested in a statement?

693

Is merge a dml statement?

731

Can we change the table name in sql?

706

What is embedded sql what are its advantages?

691

What is %rowtype in pl sql?

694

Can we call procedure in select statement?

732

what's the difference between a primary key and a unique key? : Sql dba

702

what is the difference between $message and $$message? : Sql dba

741

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

798