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

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

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

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

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

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

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

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

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

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

sanjay mehra

• Aug 3rd, 2011

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

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

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

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

venki

• Jul 23rd, 2011

Try this its working insert into tablename (vname)values(chr(39)||'name'||chr(39))

output:- 'name'

Ajit

• Jul 13th, 2011

Here all have given the answer which is for hard coded value for some predefined word. He is asking and I am too looking for the this Question "ANY DATA".If user don't know whether the coming strin...

Answer Question  Select Best Answer

Write a SQL query to select 10 random records from a table?

Rajasekhar

• Jul 22nd, 2011

SELECT Top 10 * from Emp order by NEWID()

Answer Question  Select Best Answer

Ekta Raina

• Jul 14th, 2011

Transparent Network Substrate

mselva84

 Profile Answers by mselva84 Questions by mselva84

• Jun 28th, 2010

Oak Ridge Automatic Computer and Logical EngineRegards,Manikandan SelvarajandB Professionals India Pvt LimitedChennai (TN)India.

Answer Question  Select Best Answer

Table StructureID Name Salary1 Pratap 15002 Gayathri 25003 Anita 3000 4 Ram.C 4500Write a query to retrieve names which have the letter R in it irrespective of the case(small or caps).Output:ID Name Salary1 Pratap 15002 Gayathri 25004 Ram.C 4500

Sanjay Bajracharya

• Jul 13th, 2011

Code
span style="color: #ff0000;">'%R%';

Aviral Chhabra

 Profile Answers by Aviral Chhabra Questions by Aviral Chhabra

• Jul 12th, 2011

Select * from emp where ename like '%r%' or ename like '%R%';

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: Praveena

• Dec 14th, 2005

---

Yes we can alter Column name in a table using the following query:

alter table <tablename> rename column <old Column Name> to <New Column Name>

Regards,

Praveena

 

 

dude_8550

 Profile Answers by dude_8550 Questions by dude_8550

• Jun 15th, 2011

U can change the column name and also column definition that is whether the data type and its size by the ALTER command.ALTER TABLE RENAME COLUMN <old column name> TO <new coumn name>;

Santhoshkandula

 Profile Answers by Santhoshkandula Questions by Santhoshkandula

• May 11th, 2011

   yes, it's possible to change the column name by using the following query in SQL server       SP_RENAME ' <TABLE_NAME.OLD_COLUMN_NAME> ' , ' NEW_COLUMN_NAME '   Thanks & Regards    K.Santhosh

Improve Answer

How and in what way REPLACE is different from TRANSLATE?

zahar

 Profile Answers by zahar Questions by zahar

• Jun 10th, 2011

REPLACE : replace function is: replace( string1, string_to_replace, [ replacement_string ] )string1 is the string to replace a sequence of characters with another set of characters.string_to_repl...

sandip88

 Profile Answers by sandip88 Questions by sandip88

• Feb 9th, 2010

Translate does character by character substitution,where replace can substitute a singele character with a word

Answer Question  Select Best Answer