How can we Update a table with out using UPDATE command?
Answer / myway
Use merge command. If the rows already exist then it will
update it with new data if not it would insert the new data.
Is This Answer Correct ? | 8 Yes | 0 No |
How would you begin to troubleshoot an ORA-3113 error?
What are the numeric comparison operations?
What are the attributes of cursor?
What are the differences between char and nchar in oracle?
What is different bet native dynamic sql and Dbms_Sql?
What is open database communication (odbc) in oracle?
Can we create database in oracle using command line ?
How to define a procedure inside another procedure?
select statement does not retrieve any records. what exception is raised?
waht is referencial integrity?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE