Home » SQL & PL/SQL » SQL & PL/SQL » substring
substring [message #37694] Thu, 21 February 2002 16:50 Go to next message
Sam
Messages: 255
Registered: April 2000
Senior Member
Hi,

Is it possible to do substring in oracle.
i want to select first 4 characters from a char attribute of a table?

appreciate any help
thanks
Re: substring [message #37696 is a reply to message #37694] Thu, 21 February 2002 17:35 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
select substr(col1,1,4) from table1;
Previous Topic: Open Cursors
Next Topic: Re: not equal- != or <>
Goto Forum:
  


Current Time: Sun Sep 19 11:15:51 CDT 2021