sanjeevreddy


{ City } hyderabad
< Country > india
* Profession * counsultency
User No # 38535
Total Questions Posted # 0
Total Answers Posted # 5

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 8
Users Marked my Answers as Wrong # 27
Questions / { sanjeevreddy }
Questions Answers Category Views Company eMail




Answers / { sanjeevreddy }

Question { Mind Tree, 24184 }

consider a table which contain 4 columns,ename,eno,sal and
deptno, from this table i want to know ename who having
maximum salary in deptno 10 and 20.


Answer

SELECT ENAME FROM TABLE NAME WHERE SAL>(SELECT MAX(SAL)
FROM TABLE NAME GROUP BY DEPTNO

Is This Answer Correct ?    0 Yes 0 No

Question { 11845 }

How to copy a table in another table with datas?


Answer

create table new table name as select * from new table name

Is This Answer Correct ?    0 Yes 2 No


Question { Synechron, 32260 }

From an Employee table, how will you display the record
which has a maximum salary?


Answer

select max(sal) from emp

Is This Answer Correct ?    5 Yes 14 No

Question { Satyam, 9236 }

i want count no of values in a column i.e
enam eempno phoneno
x 1 (98765,09887,096561,87964579,156678,678900876)
that means if i select phone no from table i want to get
total count of phone numbers i.e 6


Answer

select ename,empno,count(column name) from table name

Is This Answer Correct ?    0 Yes 11 No

Question { 5984 }

what is the cursor and use of cursor in pl/sql ?


Answer

cursor is private memori location, this is storing the data local mechin this will excut the program this cursor automatically deleted

Is This Answer Correct ?    3 Yes 0 No