Answer / vijayakumar

Using FORCE Command we can create a view without base table.

Answer / amedela chandra sekhar

By using 'force view'
we can create a view without base table

Answer / ajmal

Using force command we can create view without table
Exa
create or replace force view aa_vu as select *from emp;

Note:emp table is not exit

Answer / senthil

sorry, i am not understand..... emp table is not exit meaning?

I have a CURSOR then why we need BULK COLLECT again?

1 Answers  

---

what is the difference between group by and order by in sql? : Sql dba

0 Answers  

---

What is a constraint? Tell me about its various levels.

0 Answers  

---

Which is the correct statement about truncate and delete?

0 Answers  

---

What are the differences between Database Trigger and Integrity constraints ?

4 Answers  

---

---

How can you load microsoft excel data into oracle? : aql loader

0 Answers  

---

suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary

7 Answers  

---

what is sql server agent? : Sql dba

0 Answers  

---

how can i read files from a pl/sq l program

3 Answers  

---

Difference between views and materialized views?

5 Answers   BirlaSoft,

---

What is the Diff b/w Constraints and Trigeer

4 Answers   HCL,

---

is it necessary to write group by and order by clause together

3 Answers   HCL, Wipro,

---