What are the different sql commands?

0 Answers  

---

What is pl sql block in dbms?

0 Answers  

---

Is pl sql a programming language?

0 Answers  

---

what is self join and how it works??

2 Answers   Infosys,

---

what is the difference between a local and a global temporary table? : Sql dba

0 Answers  

---

---

can i use dbms_output.put_line in a function u are telling as return statement

7 Answers  

---

write sub query for eliminating duplicate rows using analytical function?

3 Answers   Metric Stream,

---

What is scope of pl sql developer in future?

0 Answers  

---

how to achieve this problem?i am having table with two colums like empno,gender. in gender column, i am having records male,female like that .my final output will be male female 5 6

4 Answers   Hexaware,

---

Can we create table in function?

0 Answers  

---

Can you join a table to itself?

0 Answers  

---

In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;

2 Answers   Mastek,

---