Home » SQL & PL/SQL » SQL & PL/SQL » Query
Query [message #190746] Fri, 01 September 2006 02:03 Go to next message
Messages: 29
Registered: August 2006
Location: Bangalore
Junior Member

I has table with data like Sachin tendulkar,Rahul dravid,saurav ganguly all are varchar2.i want query to display
s tendulkar,r dravid or sachin t,rahul d .
Plz help me
oracle 9i is using
Re: Query [message #190790 is a reply to message #190746] Fri, 01 September 2006 04:43 Go to previous message
Messages: 12
Registered: July 2006
Junior Member
try soemthing ike this

SQL> create table MM_test ( a varchar2(20));

Table created

SQL> insert into MM_TEST values ( 'Rahul Dravid' );

1 row inserted

SQL> insert into MM_TEST values ('Sachin Tendulkar');

1 row inserted
select lower(substr(a,1,1)) || ' ' || lower(substr(a,instr (a , ' ' ))) from MM_TEST;

r dravid
s tendulkar
Previous Topic: SQL script: loop through a dynamic list of sql scripts?
Next Topic: size of database
Goto Forum:

Current Time: Thu Oct 27 04:02:44 CDT 2016

Total time taken to generate the page: 0.14990 seconds