adspace


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

Is primary key always clustered index?

1101


what is sql server agent? : Sql dba

1189


Can delete statement be rollbacked?

1065


If a cursor is open, how can we find in a pl/sql block?

1252


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2102


what is schema? : Sql dba

1163


what are the advantages of sql ? : Sql dba

1154


What is your daily office routine?

2353


What is the best sql course?

1064


how to start mysql server? : Sql dba

1279


what are all the common sql function? : Sql dba

1141


what are aggregate and scalar functions? : Sql dba

1142


Is primary key clustered index?

1028


how to use regular expression in pattern match conditions? : Sql dba

1125


Can we use distinct and group by together?

1147