Read Best Answer

Editorial / Best Answer

Srinivas4u  

 Profile Answers by Srinivas4u Questions by Srinivas4u

• Member Since Jul-2008 | Jul 16th, 2008

---

I am sure that a group by clause can have all columns which are there in that table,not sure if you are looking for anotehr answer

akshya dash

• Jul 25th, 2011

there can be n no of columns in a group by clause other than group functions for ex select ename, deptno max(sal) from emp group by ename,deptno; here max(sal) is a group function and ename and ...

sasanka

• Jul 21st, 2011

In GroupBy clause contains the no of columns in the select Statement to retrieve the data.

Improve Answer

How to display data in the table between mth column to nth column in a table in Oracle?

AnithaLetchumi

 Profile Answers by AnithaLetchumi Questions by AnithaLetchumi

• Jul 27th, 2011

Hi, I don't think there exists predefined pseudo column for column number in oracle. I have done a procedure, which creates a view for displaying data from Mth to Nth column in a table. Hope it helps....

Answer Question  Select Best Answer

If you have a three columns table with one index on 2nd Column. In the SELECT statement you retrived column 1, can index be used or not?

amitsrivastava115

 Profile Answers by amitsrivastava115 Questions by amitsrivastava115

• Aug 2nd, 2011

Use index in the where clause , this way you can use it other wise not ...

geetha

• Jul 30th, 2011

Index will be used if the retrieval is based on an indexed column .if the where clause uses a column with index then the query will be executed based on that index.

Answer Question  Select Best Answer

sanjay mehra

• Aug 3rd, 2011

Code
span style="color: #F00;">'  '

Answer Question  Select Best Answer

There is a table with pluks and zinks. Each pluk only resides on a single zink and each zink may contain multiple pluks. How do you find how many pluks are on each and every zink?

royalcrown

 Profile Answers by royalcrown Questions by royalcrown

• Aug 15th, 2011

Select zink_id,count(*) total from table_name group by zink_id;

goel_vibhore

 Profile Answers by goel_vibhore Questions by goel_vibhore

• Apr 12th, 2010

Select Zink, count(plunk) as Count from PZgroup by zink

Answer Question  Select Best Answer

Functions are named PL/SQL blocks that return a value and can be called with arguments procedure a named block that can be called with parameter. A procedure all is a PL/SQL statement by itself, while a Function call is called as part of an expression.

usha`

• Aug 19th, 2011

Functions can be used in a select statement where as procedures cannot.

functions cannot return values where as procedures can.

functions can be used as user defines data types in create table but procedures cannot.

Prakash Jayabalan

 Profile Answers by Prakash Jayabalan Questions by Prakash Jayabalan

• Oct 29th, 2009

Procedure:Parameters IN, OUT and IN OUT and can return n number of values via sys cursor.Function:Only IN parameter and must return a value by using RETURN.Can be used in where clause of the Query?but performance issue will raise.

Answer Question  Select Best Answer

YASODHA

• Aug 29th, 2011

Insert is faster than delete because insert just add values to the table. but delete want to store the deleted data in the memory for future references

Rakesh

• Jul 22nd, 2011

Both insert and delete are used for different purposes. Also inserts are not always faster than delete. If the table has got indexes then insert will be slow and delete will be fast (if the WHERE cla...

Answer Question  Select Best Answer

Dhiraj

• Aug 29th, 2011

Select distinct * from table_name

shiiva

 Profile Answers by shiiva Questions by shiiva

• Feb 4th, 2011

Delete the Records selected from the below query:select a.* from emp1 a, emp1 bwhere a.empno = b.empnoand a.rowid < b.rowid  shiv

Answer Question  Select Best Answer

A) I have 100 columns in emp table , which of the below queries will give good performance and WHY?1) Select * from emp;2)select col1,col2,col3,..............col100 from emp;B) we have 2 tables T1(100 records) and T2(1000) recordsWhen we use the below queries , it will generate Cartesian product , which query will give better performance and WHY?1)Selct * from t1,t2 ;2)select * from t2,t1;

DSADSF

• Sep 24th, 2011

SELECT * FROM T1,T2
WHERE T1.COLUM_NAME=T2.COLUM_NAME;

NOTE THAT COLUMN NAME AND DATA SHOULD BE SAME

nandha_spartan

 Profile Answers by nandha_spartan Questions by nandha_spartan

• Aug 18th, 2011

Set time on

then

write the query then execute display output and timing..

then write set time off
write same query then execute display output ,compare both timing it is called query performance

Answer Question  Select Best Answer

How to open an excel sheet directly from the SQL prompt?

smonroy

 Profile Answers by smonroy Questions by smonroy

• Sep 26th, 2011

You need to use a DTS (Data Tranformation System) to SQL Server 2000 or a SSIS to SQL Server 2008 (SQL Server Integration Services), both provide programmable objects to help you

Answer Question  Select Best Answer

AVADHESH

• Sep 30th, 2011

Code
span style="color: #ff0000;">'1' THEN 'Active'
          WHEN '0' THEN 'Deactive'

sirisha.hari

 Profile Answers by sirisha.hari Questions by sirisha.hari

• Jan 6th, 2008

  hi,select sno,sname,(case  when total>50then 'good'when total>35 and total<50then 'average'else   'fail'end)resultfrom student_result

Answer Question  Select Best Answer

A cursor variable is associated with different statements at run time, which can hold different values at run time. Static cursors can only be associated with one run time query. A cursor variable is reference type (like a pointer in C).Declaring a cursor variable:TYPE type_name IS REF CURSOR RETURN return_type type_name is the name of the reference type,return_type is a record type indicating the...

NIKHIL

• Oct 12th, 2011

A cursor is just like an pointer variable which processes in the memories. Cursors can be used to process multirecord set. There are two types of cursors implicit and explicit cursors. DECLARE var_r...

Answer Question  Select Best Answer

Odd number of records:select * from emp where (rowid,1) in (select rowid, mod(rownum,2) from emp);Output:-135Even number of records:select * from emp where (rowid,0) in (select rowid, mod(rownum,2) from emp)Output:-246

RAMESH

• Oct 12th, 2011

FOR ODD:- "sql SELECT * FROM (SELECT E.*, ROWNUM rn FROM departments E) WHERE MOD (rn, 2) = 1; FOR EVEN:- "sql SELECT * ...

patilpravin_1981

 Profile Answers by patilpravin_1981 Questions by patilpravin_1981

• Jan 30th, 2008

select rownum from dual where rownum=(select rownum/2 0 from dual)

Answer Question  Select Best Answer

can anyone help with a simple example of converting one from other like CASE to DECODE or DECODE to CASE.

Mark Haynes

 Profile Answers by Mark Haynes Questions by Mark Haynes

• Oct 12th, 2011

Sorry about that seems some of the info got stripped out of my examples, so once again: CASE "expression" WHEN "search condition 1" THEN "return value 1" ELSE "return else ...

Mark Haynes

 Profile Answers by Mark Haynes Questions by Mark Haynes

• Oct 12th, 2011

Both CASE and DECODE function as IF-THEN-ELSE statements: (limit your conversions to SQL statements in Oracle only) CASE WHEN THEN ELSE END converts to: DECODE(, , ,...

Answer Question  Select Best Answer

kranthi swaroop

• Dec 3rd, 2011

In simple way View is a mirror to a master table.. View are two types 1) SIMPLE View 2) COMPLEX View We will not Define anywhere SIMPLE or COMPLEX while creating a view. Depending Upon the query ...

subhransu mohapatra

• Nov 2nd, 2011

It will not accept DML statement..because complex view contain multiple table...therefore oracle can't understand which data will insert or update in which table...

Answer Question  Select Best Answer

Niranjan Dubey

• Jan 6th, 2012

Dual is a Dummy table when we execute query.. "sql Select * from dual it will show .. DUMMY X It ha...

Rabindra_Kumar

 Profile Answers by Rabindra_Kumar Questions by Rabindra_Kumar

• Oct 28th, 2009

You can perform any DML operations in dual table provided that you have been given the privilege to do so.However never try to perform any DML operations (delete/insert/update) in dual table because d...

Answer Question  Select Best Answer

How to rename a column in a SQL table?

Read Best Answer

Editorial / Best Answer

sravee123  

 Profile Answers by sravee123 Questions by sravee123

• Member Since May-2008 | Jun 10th, 2008

---

ALTER TABLE table_name RENAME COLUMN old_name to new_name;

Ex: ALTER TABLE employee RENAME COLUMN eno to empno;

srikanth.cherukupalli

 Profile Answers by srikanth.cherukupalli Questions by srikanth.cherukupalli

• Jan 12th, 2012

Code
 

karthickrfwin

 Profile Answers by karthickrfwin Questions by karthickrfwin

• Sep 22nd, 2011

Use this Script for nename particular ColumnName in SqlTable

sp_rename 'TableName.[ColumnNameOld]','[ColumnNameNew]','Column'

Improve Answer

for example i have 50 columns i filter the nulls in FBE.in filter by exp a parameter select_exp .what function is used .how to write the condition .i take a example on emp file(empno,ename,sal......).how to write the condition in filter by expression?

G

• Jan 13th, 2012

U can use : " " to filter null values using code.
Eg:
with worksheet.range("A1:B10")
.autofilter 2, criteria1: ""
end with

shiv

• Jan 2nd, 2012

IS NOTNULL(salary)

Answer Question  Select Best Answer

How to write a query in SQL 2005 in order to Select 10 random records from table?

ASHOK PANGULURI

• Feb 11th, 2012

Code
 

srikanth.cherukupalli

 Profile Answers by srikanth.cherukupalli Questions by srikanth.cherukupalli

• Jan 12th, 2012

Code
 

Answer Question  Select Best Answer

How many Primary keys and Primary Indexes can we create on a table.How many Foreign keys and Secondary indexes can we create on a table.How many maximum columns can we create in a table

ASHOK PANGULURI

• Feb 11th, 2012

Every table can contain only one primary key, automatically ONE primary index also created.

Multiple foreign keys are containable in a table depending upon the relations of other table. No foreign key indexes are automatically created.

srikanth.cherukupalli

 Profile Answers by srikanth.cherukupalli Questions by srikanth.cherukupalli

• Jan 12th, 2012

Maximum one primary key and one primary index
foreign key depends on the primary key. You cannot create many to one relationship between pk and fk.
There are maximum 1000 columns we can create in a table.

Answer Question  Select Best Answer