8. Display the client name and order date for all orders
using the natural join keywords.
Answer / devraj
Select ca.name, ord.orderdate From customer ca Natural Join
ord;
Natural join is a cartisn product.
Is This Answer Correct ? | 0 Yes | 0 No |
How to get a list of all tables in the database?
difference between truncate and delete ,drop?
Explain overloading. Can functions be overloaded?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
How to use in conditions in oracle?
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL
how to find count rows in table without count function?
Compare and contrast between sql and sql server and explain its various functions?