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

What are the different operators available in sql?

570

How can a function retun more than one value in oracle with proper example?

584

What is localdb mssqllocaldb?

617

What is database migration?

517

Can we use view in stored procedure?

506

What is sql lookup?

511

what are different types of keys in sql?

604

What is sql mysql pl sql oracle?

567

What do you mean by field in sql?

536

What is primary key and foreign key?

531

Which software is used for pl sql programming?

519

How do you write an index?

524

Why is %isopen always false for an implicit cursor?

568

Can we insert in sql function?

541

what is collation? : Sql dba

612