Answer Posted / 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

Why do we use triggers?

719

---

Does db2 use sql?

673

---

What is compiled query?

744

---

Is like operator in sql case sensitive?

734

---

What is difference between sql and mysql?

750

---

---

what are the differences among rownum, rank and dense_rank? : Sql dba

742

---

Is join same as left join?

753

---

What is left join example?

677

---

What is scope and visibility in PL/SQL?

769

---

is mysql query is case sensitive? : Sql dba

775

---

What are the types of operators available in sql?

770

---

Is oracel sql developer written in java?

837

---

How to select all records from the table?

804

---

Name the operator which is used in the query for pattern matching?

684

---

What is normalization sql?

719

---