if we give update table_name set column_name= default.
what will happen?
its given in pl sql block.what will hapen?
- 5 Answers
- 12010 Views
- iFlex, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Do we need to rebuild index after truncate?
Can delete statement be rollbacked?
Is primary key clustered index?
how many tables will create when we create table, what are they? : Sql dba
what is collation? : Sql dba
what is schema? : Sql dba
Does group by remove duplicates?
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
what are aggregate and scalar functions? : Sql dba
what is dbms? : Sql dba
what is bcp? When does it used? : Sql dba
Can we use distinct and group by together?
What is the current version of sql?
how to start mysql server? : Sql dba
what are all the common sql function? : Sql dba
