saibabu

 Profile Answers by saibabu Questions by saibabu

• Jan 12th, 2007

hi select  ..........col3,col2,col1    from   tablename;just specify the columns   in the reverse order  i n the select statement.

Answer Question  Select Best Answer

How to export data from a SQL table to MS Excel?

ravi.allam9

 Profile Answers by ravi.allam9 Questions by ravi.allam9

• Jun 4th, 2008

using UTL_FILE

sameers007

 Profile Answers by sameers007 Questions by sameers007

• Apr 6th, 2008

Spooling means just copying what ever we type in SQL prompt rit, I want to know whether any query exists for that

Answer Question  Select Best Answer

monika1985

 Profile Answers by monika1985 Questions by monika1985

• May 28th, 2008

Select sal from emp ewhere 4=(select count(distinct(sal) from emp where sal>e.sal)

Imran_Javed

 Profile Answers by Imran_Javed Questions by Imran_Javed

• May 9th, 2008

SELECT * FROM  (SELECT  ename ,sal,                   dense_rank() over (ORDER BY sal DESC) max_sal        FROM emp)WHERE max_sal= 5;

Answer Question  Select Best Answer

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• May 16th, 2008

Hi,what nachs has written is correct.Show error is use to find the compilation error not run time error.For runtime error of procedure we need to take help of exception Handling and that error may be ...

nachs

• Aug 22nd, 2006

Use the exception handlers in run timeuse sqlerrm, sqlcode functionsshow erroris used to find errors during compile time

Answer Question  Select Best Answer

There is a table with Pluks('plk') and Zinks ('zin'). Each Pluk onlyresides on a single Zink and each Zink may contain multiple Pluks. Howdo you find how many Pluks are on each and every Zink? Please provide SQL.What is a deadlock?

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• May 16th, 2008

Dead lock is a unique situation in multiuser system that causes two or more users to wait indefinately for a locked resource. First user needs a resource locked by the second user and second user ...

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 6th, 2008

A deadlock occurs when two or more users are waiting for data locked by each other. When this happens, these users are stuck (deadly embraced) and cannot continue processing. Oracle automatically dete...

Answer Question  Select Best Answer

How will you establish many to many relationship in SQL?Ramco Systems dt. 02 Feb' 2008

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• May 16th, 2008

Cartesian product is an example for many to many reolationship in SQL.For exampleselect a.ename, a.job, a.sal, b.dname from emp a, dept bresults in many to many relationship.

rakeshn

 Profile Answers by rakeshn Questions by rakeshn

• Feb 20th, 2008

EmployeeDepartmentlets say one employee can work in multiple department.It needs many to many relationshipCreate another table EmpDeptMap.it will have foreign key with employee and Deptartment too.In this table (empid+deptid) is the primary key

Answer Question  Select Best Answer

The return type for a cursor must be a record type.It can be declared explicitly as a user-defined or %ROWTYPE can be used. eg TYPE t_studentsref IS REF CURSOR RETURN students%ROWTYPE

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• May 16th, 2008

No we can not use a scalar data type as return type.The return value of a strongly typed REF CURSOR must be a record which can be defined using the %ROWTYPE and %TYPE attributes or as a record structure.  

Answer Question  Select Best Answer

Imran_Javed

 Profile Answers by Imran_Javed Questions by Imran_Javed

• May 9th, 2008

SELECT   e.ename || ' '|| e.sal || ' ' || e1.ename || ' '|| e1.salFROM   EMP E ,  emp e1WHERE   e.sal < e1.sal

venkat2182

 Profile Answers by venkat2182 Questions by venkat2182

• Aug 9th, 2007

Hi....I hope u know about "self-join". The following query will give the above result.SELECT e1.name,e1.salary,e2.name,e2.salary FROM emp_test e1,emp_test e2WHERE e1.name='Jones' FRO...

Answer Question  Select Best Answer

Imran_Javed

 Profile Answers by Imran_Javed Questions by Imran_Javed

• May 9th, 2008

SELECT   e.EMPNO,  e.ENAME,  e.deptno,  e. SAL,  e1.avg_salFROM   emp e,  (SELECT AVG(sal) avg_sal,  deptno FROM emp  GROUP BY deptno ) e1WHERE   e.deptno =e1.deptno AND  e.sal >e1.avg_sal;

Yoga

• Sep 26th, 2007

Select ename, deptno, sal
from emp where sal > (select avg (sal) from emp) group by ename, deptno, sal

Answer Question  Select Best Answer

How to get field names from empty table by using SELECT statement;

Imran_Javed

 Profile Answers by Imran_Javed Questions by Imran_Javed

• May 8th, 2008

SELECT   cnameFROM   COLWHERE   Tname ='EMP'/*Any table can be used here*/;

hemant.agarwal03

 Profile Answers by hemant.agarwal03 Questions by hemant.agarwal03

• Mar 18th, 2008

Select column_name from user_tab_columns where table_name = ''/

Answer Question  Select Best Answer

Imran_Javed

 Profile Answers by Imran_Javed Questions by Imran_Javed

• May 12th, 2008

SELECT   SUM(col_name)FROM   ( SELECT ROWNUM rn,  col_name FROM tab_name)WHERE   MOD(rn,2)!=0;

Rohan Deshpande

• Jan 30th, 2007

Select sum(max(sal)) from table_name;

Answer Question  Select Best Answer

Imran_Javed

 Profile Answers by Imran_Javed Questions by Imran_Javed

• May 9th, 2008

SELECT MIN(b.CUSTID) "cust id", MIN(b.TRADE) "Btrade", SUM(b.AMOUNT) "Bamount", MIN(s.trade) "Strade", MIN(s.amount) "Samount"FROM cust_t b, (SELECT MIN(CUSTID),MIN(TRADE) trade,SUM(AMOUNT) amount FROM cust_t WHERE trade ='s') s WHERE b.trade = 'b';

jamesravid

 Profile Answers by jamesravid Questions by jamesravid

• Dec 10th, 2006

Hi Try this query,Select custid, 'B' as BTrade, sum(decode(tradeid,'B',amount,0) Bamount 'S' as Strade, sum(decode(tradeid,'S',amount,0) Samountfrom customergroup by custidRegards,James.

Answer Question  Select Best Answer

I need the following output in SQLc_id c_name c_country_lives qty o_deliver_country 1 john US 10 US 2 john US 20 UK

Imran_Javed

 Profile Answers by Imran_Javed Questions by Imran_Javed

• May 9th, 2008

SELECT   c.c_id,  c.c_name ,  ord.name AS "c_country_lives",  ord.qty,  ord.name AS "o_deliver_country"FROM   customer_c c,  (SELECT *  &nbs...

vishalb

 Profile Answers by vishalb Questions by vishalb

• Apr 25th, 2008

SELECT X.o_id, X.c_name,  X.[Name], X.qty , MT.[name] FROM(SELECT OT.o_id, CT.c_name,  CUT.[Name], OT.qty , OT.o_deliver_country_id --CUT.o_deliver_countryFROM Orders OT Join Customer CT on ...

Answer Question  Select Best Answer

vishalb

 Profile Answers by vishalb Questions by vishalb

• Apr 27th, 2008

Tested!SELECT E.EmpName, Max(C.Reviewdate) from EmpCust E Join CustReview C on e.Empid=c.empid group by c.empid, E.EmpName

ratna_ponnapalli

 Profile Answers by ratna_ponnapalli Questions by ratna_ponnapalli

• Apr 11th, 2006

Select a.empname,max(b.reviewdate) from empcust a,custreview b where a.custid=b.custid group by a.empname;

Answer Question  Select Best Answer

Drop Procedure procedure_nameDrop Function function_name

kumars77

 Profile Answers by kumars77 Questions by kumars77

• Apr 24th, 2008

Absolutely it will work

Answer Question  Select Best Answer

minak

 Profile Answers by minak Questions by minak

• Apr 22nd, 2008

declare @a varchar(1000),@tblname varchar(100),@b nvarchar(1000)declare @startcol int,@i int, @endcol intselect @startcol = 11, @endcol =13, @a='', @tblname = '<tablename...

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Feb 18th, 2007

Select * from(select rownum r ,a.* from employees a)where r between 11 and 40

Answer Question  Select Best Answer

ritesh_ksingh

 Profile Answers by ritesh_ksingh Questions by ritesh_ksingh

• Apr 21st, 2008

To process an SQL statement, a DBMS performs the following five steps: The DBMS first parses the SQL statement. It breaks the statement up into individual words, called tokens, makes sure that the sta...

Answer Question  Select Best Answer

How to execute DOS Commands from SQL prompt?

vinodsahani

 Profile Answers by vinodsahani Questions by vinodsahani

• Apr 12th, 2008

Either you can type HOST to go into DOS prompt, use DOS commands and then type EXIT to return back.OR, if you want to run only one DOS command you can type HOST  Hope this will work for u.

aravindpurohit

 Profile Answers by aravindpurohit Questions by aravindpurohit

• Apr 8th, 2008

Sql> host (enter)This takes u t dos mode .regardsAravind purohit.

Answer Question  Select Best Answer

LOOPSELECT num_credits INTO v_numcredits FROM classesWHERE dept=123 and course=101;UPDATE studentsSET current_credits=current_credits+v_numcreditsWHERE CURRENT OF X;END LOOPCOMMIT;END;

aravindpurohit

 Profile Answers by aravindpurohit Questions by aravindpurohit

• Apr 4th, 2008

When referencing the current row from an explicit cursor, we use                           'WHERE CURRENT OF'.  it allows ...

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 6th, 2008

The WHERE CURRENT OF clause is used to reference the current row from an explicit cursor.

Answer Question  Select Best Answer

saradajasti

 Profile Answers by saradajasti Questions by saradajasti

• Mar 27th, 2008

Here CNT is a column name SELECT CNT FROM table_nameWHERE MOD(CNT,CNT) = 0AND MOD(CNT,2) != 0AND MOD(CNT,3) != 0AND MOD(CNT,5) != 0AND MOD(CNT,7) != 0AND MOD(SQRT(CNT),ROUND(SQRT(CNT))) != 0ORDER BY CNT

saradajasti

 Profile Answers by saradajasti Questions by saradajasti

• Mar 26th, 2008

SELECT CNT FROM table_nameWHERE MOD(CNT,CNT) = 0AND MOD(CNT,2) != 0AND MOD(CNT,3) != 0AND MOD(CNT,5) != 0AND MOD(CNT,7) != 0ORDER BY CNT

Answer Question  Select Best Answer