3. Display all the client numbers in the ORDER table. Remove
duplicates.
Answer / aswini
select distinct client_number from <table_name>;
Is This Answer Correct ? | 4 Yes | 0 No |
1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.
Please explain compound trigger in oracle?
I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.
why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?
Explain the difference between a procedure and a function?
What is a Redo Log ?
How to install oracle database 10g xe?
How to find out what privileges a user currently has in oracle?
What is the difference between count (*), count (expression), count (distinct expression)?
Will you be able to store pictures in the database?
When do you get a .pll extension in oracle?
What is OCI. What are its uses?