Differentiate between translate and replace?
can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?
How can we view last record added to a table?
does Oracle has only one table space?
How to define an oracle cursor variable?
List the parts of a database trigger.
Define the terms primary key foreign key and also the difference between primary and the unique key
How to run create database statement?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What are cursor?where are they used?
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?
what is the syntax of ALTER command?
How can you merge two tables in oracle?