if we give update table_name set column_name= default.
what will happen?
- 4 Answers
- 8798 Views
- iFlex, I also Faced
- E-Mail Answers
Answer Posted / akki julak
if you gave a default value for that column
then it takes that default value
otherwise it takes NULL
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What is an implicit commit?
how many groups of data types? : Sql dba
How to write html code in pl sql?
Which command is used to delete a trigger?
Is sql better than access?
how many ways to get the current time? : Sql dba
Can triggers stop a dml statement from executing on a table?
What do you mean by “trigger” in sql?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
Why do we need pl sql?
What does count (*) mean in sql?
Why we use join in sql?
what are the nonstandard string types? : Sql dba
What is sharding in sql?
How do I remove sql developer from windows 10?
