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: 4502
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: 64108
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: Mon Dec 05 04:53:46 CST 2016

Total time taken to generate the page: 0.05393 seconds