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

Why we use cross join?

547

Explain the uses of control file.

625

What is procedure explain with example?

547

Is sql dba a good career? : SQL DBA

544

What are different types of sql commands?

520

How to use sql statements in pl/sql?

592

What is sql in java?

557

What is constant in pl sql?

523

What is trigger and types?

576

What do you mean by stored procedures? How do we use it?

537

what is timestamp in mysql? : Sql dba

575

Can we use ddl statements in stored procedure?

703

what are the different type of normalization? : Sql dba

558

How do I run a program in pl sql?

511

In pl/sql, what is bulk binding, and when/how would it help performance?

543