I have following column in the table.
and I want to display it as
numbers in one column and letters in another column.
Answer / sreenivasulu sangatipalli
SELECT REGEXP_SUBSTR(COL,'[A-B]+',COL) AS COL1,REGEXP_SUBSTR(COL,'[1-9]+',COL) AS COL2 FROM TEST10;
SELECT * FROM (SELECT CASE WHEN REGEXP_LIKE(COL,'[A-Z]+','i') THEN COL END ALPHS,
CASE WHEN REGEXP_LIKE(COL,'[0-9]+') THEN COL END NUMBS
FROM TEST10 ) where ALPHS is not null OR NUMBS is not null;
|Is This Answer Correct ?||0 Yes||0 No|
In what condition is it good to disable a trigger?
What is dense_rank in sql?
What is sqlexception in java?
What is sql rowcount?
What is the difference between functions, procedures, and packages in pl/sql?
What are the advantages of indexing?
What is the use of sql trace?
Mention what does the hierarchical profiler does?
What is the difference between the implicit and explicit cursors?
declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?
List and explain the different types of join clauses supported in ansi-standard sql?
Why do you partition data?