if we give update table_name set column_name= default.
what will happen?
its given in pl sql block.what will hapen?
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
List different type of expressions with the example.
Is there a way to automate sql execution from the command-line, batch job or shell script?
how to delete an existing column in a table? : Sql dba
Is sql developer case sensitive?
Define the select into statement.
How do I run a sql trace?
What is an exception in pl/sql?
Why do you partition data?
What is a pdo connection?
What is cursor explain with example?
What is pl sql architecture?
What are the 3 types of behavioral triggers?
What are the subsets of sql?
who introduced sql?
What is embedded sql what are its advantages?