What is pl sql variable?

0 Answers  

---

What are pl sql procedures?

0 Answers  

---

List the ways to get the count of records in a table?

0 Answers  

---

How to select unique records from a table?

0 Answers  

---

Can we use rowid as primary key?

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  

---

what are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning tables?

1 Answers   Metric Stream,

---

why we use nocopy?

2 Answers   Polaris,

---

Do foreign keys improve performance?

0 Answers  

---

Is json a nosql?

0 Answers  

---

Explain the uses of control file.

0 Answers  

---

What are the attributes of SQL*PLUS ?

2 Answers   Dream Careers, Oracle,

---