OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » substring

Thu, 21 February 2002 16:50

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

Thu, 21 February 2002 17:35

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: Sat Apr 27 01:48:43 CDT 2024