Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

0 Answers  

---

Can we perform dml on view?

0 Answers  

---

Can we use out parameter in function?

4 Answers   Infosys,

---

what are the types of join and explain each? : Sql dba

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 is magic table?

6 Answers  

---

how to retrive only second row from table?

31 Answers   IBM,

---

Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.

5 Answers   Thomson,

---

What is schema in sql?

0 Answers  

---

Can we commit in trigger?

0 Answers  

---

what is cursor. write example of it. What are the attributes of cursor.

0 Answers  

---

What is difference between ms sql and mysql?

0 Answers  

---