OraFAQ Forum: Server Administration » Re: who to search patterns ([0-9] or [a-z]) in sql

Home » RDBMS Server » Server Administration » Re: who to search patterns ([0-9] or [a-z]) in sql

Tue, 01 May 2001 15:54

jacob
Messages: 6
Registered: October 2000

Junior Member

SELECT ENAME FROM T11 WHERE SUBSTR(ENAME,5) BETWEEN 'A' AND 'Z' ORDER BY SUBSTR(ENAME,5)

Previous Topic:	what is the diff between -select table_name from all_tables;and select * from tab?
Next Topic:	simple sql statement - performance issue

Goto Forum:

]

Current Time: Sat Jun 29 00:01:43 CDT 2024