How many categories of data types in oracle?
What are the different pseudo commands? Explain in general?
which is the best training centre for learning oracle?
What's dateware house and what's clustor with practicle example
What is partitioned table in Oracle?
2. Display the post code and the total number of purchase orders placed with creditors in that post code.
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.
what is primary key and foreign key when and where have to use
How to define a variable of a specific record type?
4. Using a set operator, display the creditor number of all creditors who have ever been paid.
26. Display the earliest shipping date in the format: DD/MON/YYYY
13. Display the second to fifth characters in each client name.
List the types of joins used in writing subqueries?