Is pl sql useful?

0 Answers  

---

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

0 Answers  

---

What is implicit cursor in pl sql?

0 Answers  

---

how to create a test table in your mysql server? : Sql dba

0 Answers  

---

Are dml statements autocommit?

0 Answers  

---

How to run sql*plus commands in sql developer?

0 Answers  

---

write a procedure to find top second no from a list of numbers

1 Answers   ABC,

---

Can you have multiple SPs with the same name on a database?

6 Answers   CGI,

---

What is difference between nchar and nvarchar?

0 Answers  

---

What is pragma exception and how, when, where us

5 Answers  

---

i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject

8 Answers  

---

How do I run a sql query in pgadmin 4?

0 Answers  

---