Why plvtab is considered as the easiest way to access the pl/sql table?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

what is the functionality of the function htmlentities? : Sql dba

0 Answers  


how to check the 3rd max salary from an employee table? One of the queries used is as follows: select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal). Here in the sub query "select count(distinct(sal)) from emp b where a.sal<=b.sal" or "select count(distinct(sal)) from emp b where a.sal=b.sal" should reveal the same number of rows is in't it? Can any one here please explain me how is this query working perfectly. However, there is another query to get the 3rd highest of salaries of employees that logic I can understand. Pls find the query below. "select min(salary) from emp where salary in(select distinct top 3 salary from emp order by salary desc)" Please explain me how "select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal)" works source:http://www.allinterview.com/showanswers/33264.html. Thanks in advance Regards, Karthik.

4 Answers  


Can I create table without primary key?

0 Answers  


Two Methods of retrieving SQL?

7 Answers   Atiric Software, Microsoft, Oracle, TCS, Wipro,


what does the t-sql command ident_current does? : Transact sql

0 Answers  






How to display the records between two range in Oracle SQL Plus?

0 Answers   MCN Solutions,


what is a constraint? : Sql dba

0 Answers  


What is a recursive stored procedure?

0 Answers  


Which is better varchar or nvarchar?

0 Answers  


What are the types of variables use in pl sql?

0 Answers  


i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.

4 Answers   TCS,


Is pl sql still used?

0 Answers  


Categories