Interested to Buy Any Domain ? << Click Here >> for more details...
How can we delete duplicate rows in a table?
- 0 Answers
- 1039 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
What happens to the current transaction if the session is ended?
What is an Index ? How it is implemented in Oracle Database ?
i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?
Draw E-R diagram for many to many relationship ?
What is a deadlock ? Explain .
How to invoke the data pump import utility?
What is oracle latest version?
What is a nested table and how is it different from a normal table?
Display the number value in Words?
Oracle General 
