Home » SQL & PL/SQL » SQL & PL/SQL » sql query
sql query [message #305239] Mon, 10 March 2008 04:05 Go to next message
jeer
Messages: 37
Registered: February 2008
Location: pakistan
Member
I have a table
STUDENT (St_id NUMBER, St_Name VARCHAR2(60))

Table STUDENT contains many student records. St_Name can store 60 characters. I want to check the St_Names which have a length more than 50. Please guide me for it.

Thanks
Re: sql query [message #305240 is a reply to message #305239] Mon, 10 March 2008 04:09 Go to previous messageGo to next message
Frank Naude
Messages: 4509
Registered: April 1998
Senior Member
select * from student where length(st_name) > 50;
Re: sql query [message #305244 is a reply to message #305239] Mon, 10 March 2008 04:11 Go to previous message
Michel Cadot
Messages: 65084
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
LENGTH

Please read SQL Reference we will not give you the link for each available function.

Regards
Michel
Previous Topic: Oracle
Next Topic: What query do I use to list the primary key
Goto Forum:
  


Current Time: Sat Jul 22 20:12:40 CDT 2017

Total time taken to generate the page: 0.06588 seconds