4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>

1 Answers   Wipro,

---

Can we convert a date to char in oracle and if so, what would be the syntax?

0 Answers  

---

How to create a new oracle data file?

0 Answers  

---

i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?

7 Answers   HCL, IBM,

---

what is insert all statement in sql

2 Answers   CGI, TCS,

---

Can we create more than one index on particular column?

1 Answers  

---

how to we delete a row using varray

3 Answers   CTC,

---

What is object data modeling?

0 Answers  

---

i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID

7 Answers   IBM,

---

does the query needs a hint to access a materialized view?

0 Answers  

---

List out the difference between commit, rollback, and savepoint?

0 Answers  

---

What is the scope of a local variable?

0 Answers  

---