I have table .. like EMPNO Ename DOB ------------------------------------ 1 you 1-jan-2011 2 Me 28-jan-2011 tel me the query for no.of days different from.. two dates of column DOB.? Thanks in advance. Sateesh

skcwebworld

 Profile Answers by skcwebworld Questions by skcwebworld

• Aug 2nd, 2015

Code
SELECT DATEDIFF (dd,1-jan-2011,28-jan-2011)

kirathakudu

 Profile Answers by kirathakudu Questions by kirathakudu

• Dec 13th, 2011

Select date1-date2 from tablename;

If the above value is negative it means date 1 is older than date 2

Answer Question  Select Best Answer

I have table with one column. type varchar.. PHONE --------------- 99samn44423m44 8034skdf3453a2 909090abc4567d i want to get numeric values.. i mean my output will be PHONE --------------- 994442344 80343453a2 9090904567 thanks in advance.. Sateesh

Ganezh

• Apr 20th, 2016

Code
SELECT REGEXP_REPLACE(AB12CD34EF,A|B|C|D|E|F, ) FROM DUAL;

Krishna

• Mar 30th, 2016

Code
SELECT REGEXP_REPLACE(<Column Name>,[A-Za-z]) FROM <Table Name>;

Answer Question  Select Best Answer

VIJAY SHARMA

• Sep 24th, 2012

Code
 
SELECT SEQNO "PRIME NUMBERS"
FROM(
     SELECT SEQNO
     FROM( 
          SELECT ROWNUM SEQNO
          FROM ALL_OBJECTS
          GROUP BY ROWNUM
          HAVING ROWNUM <= &GIVENNUM
         ),
         (
          SELECT ROWNUM SEQNO2
          FROM ALL_OBJECTS
          WHERE ROWNUM <= &GIVENNUM
         ) A2
    GROUP BY CUBE(SEQNO,SEQNO2)
    HAVING GROUPING_ID(SEQNO,SEQNO2) = 0 AND SEQNO >= SEQNO2 AND
    MOD(SEQNO,SEQNO2) = 0
    )
GROUP BY SEQNO
HAVING COUNT(*) IN(1,2)
ORDER BY SEQNO;

KARRTHIK

• Dec 3rd, 2011

"plsql n number; i number; counter number; begin n:=&n; i:=1; counter:=0; if n=1 then dbms_output.put_line('1 is a prime No.'); else if n=2 ...

Answer Question  Select Best Answer