how can we submit a form without a submit button? : Sql dba

0 Answers  

---

What is the difference between anonymous block and named blocks?

3 Answers  

---

What do you understand by pl/sql packages?

0 Answers  

---

What is use of package in pl sql?

0 Answers  

---

What is rownum?

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  

---

How do you write an inner join query?

0 Answers  

---

What is a natural join?

0 Answers  

---

how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column's value of a resulted set of executed query

3 Answers  

---

What is the difference between anonymous block and named block or stored procedure?

8 Answers  

---

1> how are u debugging in plsql ? 2> how to connect oracle database from unix. is there ne way other than using sqlplus ?

2 Answers  

---

Is primary key clustered or nonclustered?

0 Answers  

---