Answer Posted / pavan_1981

PL/SQL is Oracle's Procedural Language extension to SQL.
PL/SQL's language syntax, structure and data types are
similar to that of ADA. The PL/SQL language includes object
oriented programming techniques such as encapsulation,
function overloading, information hiding (all but
inheritance). PL/SQL is commonly used to write data-centric
programs to manipulate data in an Oracle database

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1059

---

What programs use sql?

980

---

What is audit logout in sql profiler?

1005

---

Are null values same as that of zero or a blank space?

1005

---

How do I filter in sql profiler?

985

---

What is auto increment feature in sql?

1104

---

How many tables can you join in sql?

942

---

what is log shipping? : Sql dba

1092

---

What is the use of pl/sql table?

1043

---

What is dense_rank in sql?

954

---

What is the use of double ampersand (&&) in sql queries? Give an example

1122

---

Is primary key clustered index?

935

---

How do I start sql profiler?

976

---

what are different types of collation sensitivity? : Sql dba

1055

---

Can two tables have same primary key?

947

---