How to create a new table in oracle?

0 Answers  

---

5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.

3 Answers   Wipro,

---

What is blob data type in oracle?

0 Answers  

---

what is grid in Oracle 10g...

1 Answers  

---

what is the syntax of DROP command?

10 Answers  

---

---

How to create a stored function in oracle?

0 Answers  

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

0 Answers   CTS,

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

0 Answers   Wipro,

---

why can't we assign not null constraint as table level constraint

3 Answers   CTS, Wipro,

---

What is oracle join syntax?

0 Answers  

---

What happens to the indexes if a table is recovered?

0 Answers  

---

Please explain joins in oracle?

0 Answers  

---