How consistent is the view of the data between and within multiple sessions, transactions or statements ?

0 Answers  

---

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

---

Can we create view in stored procedure?

0 Answers  

---

Explian rowid, rownum? What are the psoducolumns we have?

0 Answers  

---

Which join is like inner join?

0 Answers  

---

My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

2 Answers   CG,

---

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  

---

Give the structure of the function ?

2 Answers  

---

Can we create clustered index without primary key?

0 Answers  

---

What is a pdo connection?

0 Answers  

---

Is it possible to access the current value in a session before accessing next value?

1 Answers  

---

What is meant by cursor in sql?

0 Answers  

---