select c.name,o.ordid,o.orddate from customer c join oreder o using(custid

9. Display the client name and order date for all orders
using the JOIN . . . USING method.

Question Posted / anjum

2 Answers
4466 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / anjum

select c.name,o.ordid,o.orddate from customer c join oreder o
using(custid);

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can group functions be used in the order by clause in oracle?

999

When do you get a .pll extension in oracle?

1146

What are the attributes of cursor?

1054

Is postgres faster than oracle?

1041

What privilege is needed for a user to connect to oracle server?

994

What is the fastest query method to fetch data from the table?

1362

What is the difference between a hot backup and a cold backup in oracle?

1017

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1787

How to assign values to variables?

1104

What are internal user account in oracle?

1009

Point out the difference between user tables and data dictionary?

983

Can we store pictures in the database and if so, how it can be done?

1045

What is bind variable in oracle 11g?

1039

Which environment variables are absolutely critical in order to run the OUI?

2120

How to drop a stored procedure in oracle?

1051