3. Display all the client numbers in the ORDER table. Remove
duplicates.
- 1 Answers
- 3502 Views
- Wipro, I also Faced
- E-Mail Answers
Answer / aswini
select distinct client_number from <table_name>;
| Is This Answer Correct ? | 4 Yes | 0 No |
A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
When do I need to use a semicolon vs a slash in oracle sql?
What is ADDM Advisor in Oracle?
What is a Segment ?
What is a table index in oracle?
What are the attributes of the cursor?
I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?
How to export data to a csv file?
What is the implicit cursor in oracle?
How to call a sub procedure?
When does a Transaction end ?
Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks
Oracle General 
