How to create a new table in oracle?

0 Answers  

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---

Can you assign multiple query result rows to a variable?

0 Answers  

---

How do we switch from init.ora file to asp file?

2 Answers  

---

What is a subquery?

0 Answers  

---

---

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

0 Answers   Zensar,

---

how to retrieve data from different tables ,place this data in different excel worksheets.

1 Answers   Gap Inc,

---

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

0 Answers   Wipro,

---

write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.

11 Answers   Wipro,

---

What is the difference between SQL, DDL, and DML?

7 Answers   BeBo Technologies, Wipro,

---

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,

---

What is set verify off in oracle?

0 Answers  

---