Interested to Buy Any Domain ? << Click Here >> for more details...
How are multiple column = value pairs delimited in the SET
clause of an UPDATE statement?
1. With commas (SET price = 0, status = 'I')
2. With parentheses (SET (price = 0) (status = 'I'))
3. With double-pipes (SET price = 0 || status = 'I')
4. With square-brackets (SET [price = 0] [status = 'I']
5. With single or multiple spaces (SET price = 0 status
= 'I')
- 2 Answers
- 8148 Views
- I also Faced
- E-Mail Answers
Answer Posted / tulsi
1)With commas (SET price = 0, status = 'I')
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
Explain the difference between rename and alias?
Which operator is used in query for pattern matching?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
Explain the uses of control file.
Is hadoop a nosql?
What version is sql?
Can instead of triggers be used to fire once for each statement on a view?
Why do we need a foreign key?
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
What is difference between left and right outer join?
How do you rank data in sql?
What is difference between stored function and application function?
How much does sql certification cost?
how is exception handling handled in mysql? : Sql dba
How do I add a primary key to a table?
