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

its given in pl sql block.what will hapen?

Answers were Sorted based on User's Feedback



if we give update table_name set column_name= default. what will happen? its given in pl sql blo..

Answer / manoj

It will fill the default value through out that column
by null

Is This Answer Correct ?    7 Yes 0 No

if we give update table_name set column_name= default. what will happen? its given in pl sql blo..

Answer / gopal

If default is speceified for the table then it will update
with default value. Else it will update null values

Is This Answer Correct ?    6 Yes 1 No

if we give update table_name set column_name= default. what will happen? its given in pl sql blo..

Answer / guest

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

Is This Answer Correct ?    3 Yes 0 No

if we give update table_name set column_name= default. what will happen? its given in pl sql blo..

Answer / ehtesham malik

if you set default value then it will update column with
null value.

Is This Answer Correct ?    1 Yes 1 No

if we give update table_name set column_name= default. what will happen? its given in pl sql blo..

Answer / selvan

It shouldn't occured any error.
It'll update but value is empty(i.e columns having empty
values)

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

What is dynamic SQl and how you will create and execute dynamic sql?

2 Answers   TCS,


I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

4 Answers   Cap Gemini, MTS,


In packages the source code is compiled into p code ? how do we describe the p code

3 Answers  


Can a foreign key be null?

0 Answers  


Can we use pl sql in mysql?

0 Answers  


Can we change the table name in sql?

0 Answers  


How many sql statements are used? Define them.

0 Answers  


write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

3 Answers   Zensar,


a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

1 Answers   CGI,


What is server name sql?

0 Answers  


What does partition by mean in sql?

0 Answers  


Can you load data into multiple tables at once? : aql loader

0 Answers  


Categories