Answer Posted / rahul k.

Excellent Keshav...Very nice...

Table within a table called nested table same as nested
loop in any procedural languages...

Thnanks

Why do we use procedures in sql?

1068

---

How to create an array in pl/sql?

1059

---

How to download oracle sql developer?

1093

---

What is crud sql?

972

---

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

1575

---

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1034

---

when MSQL8.0 is in market

2070

---

Why stored procedure is better than query?

937

---

How do I run a pl sql procedure in sql developer?

963

---

Give the order of sql select?

1131

---

What is the command used to fetch first 5 characters of the string?

1385

---

What is a column in a table?

1115

---

Which join condition can be specified using on clause?

944

---

Is oracel sql developer written in java?

1096

---

how to drop an existing index in mysql? : Sql dba

1060

---