Answer / Priyanka Pethe

Yes, SQL*Plus has an embedded PL/SQL engine that allows users to create and execute PL/SQL blocks, procedures, functions, packages, triggers, etc. It provides interactive commands and editing features for PL/SQL programming.

Name some usages of database trigger?

1 Answers  

---

Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?

2 Answers   CTS,

---

write a query to delete similar records in particular fields(columns) in different tables

6 Answers   TCS,

---

What is a CTE (Common Table Expression), and how is it different from a subquery?

3 Answers  

---

Give the structure of the procedure ?

1 Answers  

---

What are analytical functions in sql?

1 Answers  

---

What is dynamic SQl and how you will create and execute dynamic sql?

2 Answers   TCS,

---

what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...

1 Answers   HCL, Satyam,

---

What are types of joins?

1 Answers  

---

how mysql optimizes distinct? : Sql dba

1 Answers  

---

How do you write an inner join query?

1 Answers  

---

What is sql clause?

1 Answers  

---