What is a database trigger?

0 Answers  

---

What is bulk collect in pl sql?

0 Answers  

---

What is pl sql code?

0 Answers  

---

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

9 Answers   Zensar,

---

How to select unique records from a table?

0 Answers  

---

---

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---

Why is stored procedure faster than query?

0 Answers  

---

Can we relate two different tables from two different users in ORACLE,PL/SQL?

4 Answers  

---

In testing where do we use sql language and how it helps in testing?

2 Answers  

---

Which are the different case manipulation functions in sql?

0 Answers  

---

What is the difference between a primary key and a clustered index?

0 Answers  

---

Why is sql better than hql?

0 Answers  

---