Interested to Buy Any Domain ? << Click Here >> for more details...
How can we Update a table with out using UPDATE command?
- 1 Answers
- 6036 Views
- I also Faced
- E-Mail Answers
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 to invoke the data pump import utility?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How to execute the package in oracle?
How to load data through external tables?
How to do a full database export?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How to turn on or off recycle bin for the instance?
How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example
What are the values that can be specified for OPTIMIZER MODE Parameter ?
How to transfer database(500 gb) of oracle enterprise edition to standard edition downtime is only 1 hour not using exp/imp option ?
What is a deadlock in SQL? How can you prevent it?
Oracle General 
