OraFAQ Forum: SQL & PL/SQL » Oracle 9i Help

Home » SQL & PL/SQL » SQL & PL/SQL » Oracle 9i Help

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle 9i Help [message #6906]

Sat, 10 May 2003 21:06

Nazma Bepat
Messages: 34
Registered: May 2003

Member

I have tried to do the following:
write a query to display the course number and description of courses that have a description that ends with a �L�.

My answer:

Select Course_number, Description
From course
Where course ends with a �L�

Can someone please help me out. It is not working for me.
Thanks
nazma

Report message to a moderator

Re: Oracle 9i Help [message #6911 is a reply to message #6906]

Sun, 11 May 2003 03:45

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Report message to a moderator

Re: Oracle 9i Help [message #6914 is a reply to message #6906]

Sun, 11 May 2003 05:05

Alistair
Messages: 3
Registered: April 2003

Junior Member

Select Course_number, Description
From course
Where course_number LIKE "*L"

Report message to a moderator

Re: Oracle 9i Help [message #7008 is a reply to message #6906]

Thu, 15 May 2003 01:23

Giri
Messages: 12
Registered: March 2002

Junior Member

Select Course_number, Description
From course
Where course like '%L'

Report message to a moderator

Re: Oracle 9i Help [message #7076 is a reply to message #6914]

Tue, 20 May 2003 05:33

swetha
Messages: 10
Registered: November 2000

Junior Member

This is not working
Select Course_number, Description
From course
Where course_number LIKE "*L"

I think like operator will use only 2 symbols % and -.We cannot use * in the particular select statement.

Report message to a moderator

Previous Topic:	Convert utime to date
Next Topic:	ORA-666666 Please look at this

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 00:59:37 CDT 2024