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?

how to get help information from the server? : Sql dba

0 Answers  

---

diff b/w function and procedure?

9 Answers   iFlex,

---

type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...

1 Answers   Satyam,

---

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

2 Answers  

---

What is bulk collect in pl sql?

0 Answers  

---

---

What is nvarchar max in sql?

0 Answers  

---

What is faster join or subquery?

0 Answers  

---

what is try_catch block in procedure

0 Answers  

---

What is the use of prepared statement?

0 Answers  

---

What is a data manipulation language?

0 Answers  

---

which operator is used in query for pattern matching? : Sql dba

0 Answers  

---

how can create data base link for tow servers (scott schema) give examples plz

2 Answers  

---