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
Answer / manoj
It will fill the default value through out that column
by null
Is This Answer Correct ? | 7 Yes | 0 No |
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 |
Answer / guest
IT WILL UPDATE NULL IN THE COLUMN IF YOU NOT PROVIDE ANY
VALUE.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ehtesham malik
if you set default value then it will update column with
null value.
Is This Answer Correct ? | 1 Yes | 1 No |
What is dynamic SQl and how you will create and execute dynamic sql?
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.
In packages the source code is compiled into p code ? how do we describe the p code
Can a foreign key be null?
Can we use pl sql in mysql?
Can we change the table name in sql?
How many sql statements are used? Define them.
write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.
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.
What is server name sql?
What does partition by mean in sql?
Can you load data into multiple tables at once? : aql loader