Santhoshkandula

 Profile Answers by Santhoshkandula Questions by Santhoshkandula

• May 11th, 2011

   No, It's not possible because select statement only selects the values.   Thanks & Regards    K.Santhosh

RK

• Apr 24th, 2006

FOR EXAMPLE TO RETRIEVE 2ND COLUMN(ENAME)  IN EMP TABLE:SELECT COLUMN_NAME FROM USER_TAB_COLUMNSWHERE TABLE_NAME ='EMP'AND COLUMN_ID = 2

Answer Question  Select Best Answer

jaya

• May 29th, 2007

Hi,It seems your application is using a cursor with for update clause , where the other transaction (DML) will wait until the current one gets end.check the code , if this is not the case then there m...

Answer Question  Select Best Answer

dev

• Sep 13th, 2006

Good Deephi. It's working.Thanks.

Deepthi

• Jul 18th, 2006

Spool is used to write the output into a file.Spool (write the file name) ex: spool d:sampl.txtif u want stop spooling use the command spool off

Answer Question  Select Best Answer

Dhaval

• Nov 14th, 2006

Select Count(*) , DATEPART ( hh , sellgoodsdate) From goodssellGroup By DATEPART ( hh , sellgoodsdate)

Answer Question  Select Best Answer

shakthi

 Profile Answers by shakthi Questions by shakthi

• Jan 25th, 2007

Clear screen.... cl scr.... clear scr..... cl screen

Answer Question  Select Best Answer

Ramprasad

• Dec 14th, 2006

Hi,Through Copy command in SQL will copy a table with Data like a normal COPY command in MS-DOS.In SQL, CREATE statement will provide flexibility to copy complete structure or...

Answer Question  Select Best Answer

jamesravid

 Profile Answers by jamesravid Questions by jamesravid

• Dec 10th, 2006

Try this query select trunc(sysdate) today, hiredate, to_char(trunc(months_between(sysdate,hiredate)/12)) || ' years ' || to_char(mod(trunc(months_between(sysdate,hiredate)),12)) || ' months ' || to_c...

Answer Question  Select Best Answer

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 12th, 2006

what is cursor ?how many type?what is the diffrence ?what is exception?diffrence between function & procedurelike wise you can prepare your own questions.

Answer Question  Select Best Answer

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

Gurwinder Singh Saini

• Feb 15th, 2007

SQL> select * from pn;COL1 COL2 COL3 COL4----- ----- ----- -----a b c dSQL> update pn set col4=col1, col1=col2, col2=col3, col3=col4 ;1 row upda...

Answer Question  Select Best Answer

Punitha

• Jun 29th, 2007

you can use sum functionselect sum(sal) from emp;

Answer Question  Select Best Answer

amarnathtnl

 Profile Answers by amarnathtnl Questions by amarnathtnl

• Jun 29th, 2007

Hi,The answer for ur first Ques isselect * from emp where empno IN(select mgr,count(*) from emp group by mgr having count(*)>=1)TO SEE THE EXISTING CONSTRAINTS ON the TABLE  empselect * from user_constraints where table_name='EMP';note : table name must be given in capitals

Answer Question  Select Best Answer

ismail mohd

• Jul 5th, 2007

A long time ago, the only optimizer in the Oracle database was the Rule-Based Optimizer (RBO). Basically, the RBO used a set of rules to determine how to execute a query. If an index was available on ...

Answer Question  Select Best Answer

jamesravid

 Profile Answers by jamesravid Questions by jamesravid

• Jul 18th, 2007

Select stud_name, greatest(s1,s2,s3,s4,s5) from stud_table;

Answer Question  Select Best Answer

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 13th, 2008

The Oracle9i database offers join syntax that is SQL: 1999 Compliant. Prior to release 9i, the join syntax was different from the ANSI standards. The new SQL: 1999 Compliant join syntax does not offer any performance benefits over the Oracle proprietary join syntax that existed in prior releases.

Answer Question  Select Best Answer

Shanthi

• Aug 15th, 2007

Yes.. Using execute immediate which executes dynamic sql and pl/sql

Answer Question  Select Best Answer

AiM

• Aug 23rd, 2014

Trigger code to create a trigger in disable mode starting 11g "oracle create or replace trigger prac_trig_emp1 before insert or update OR DELETE ON emp1 REFERENCING NEW AS NEW OLD...

Answer Question  Select Best Answer

For example In my table one datetime field example modified_date_time.its displaying 2006-08-18 23:28:23 (here its rounding seconds)But I want the format like 2006-08-18 23:28:22.123456 (I want the absolute value for seconds like yyyy-mm-dd HH24:mi:ss.milliseconds.

Siva

• Aug 23rd, 2007

You can use like the followingSELECT TO_CHAR(systimestamp,'yyyy-mm-dd HH24:mi:ss.FF') FROM DUAL;which gives you like 2007-08-23 14:12:36.769726

Answer Question  Select Best Answer

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Dont user select */in/write minimal cond

Answer Question  Select Best Answer

For example::In a table Table1, I want 2 make the column "Column1" as primary key and I want the first letter must start with 'S'

vemurisasidhar

 Profile Answers by vemurisasidhar Questions by vemurisasidhar

• Sep 23rd, 2007

I guess it would work if u  add a check constraint as follows:constraint check (column1 like 's%');

Answer Question  Select Best Answer