Find out how long is the field or column [message #681597] |
Thu, 06 August 2020 18:32 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/3ed6d2ab3ba05fa435a2497623ff0b3e?s=64&d=mm&r=g) |
james94539
Messages: 4 Registered: November 2018
|
Junior Member |
|
|
Hi,
I want to ask a simple question, if I have people table, and name is one of the column,
what is the query to get the name field which is at least 10 characters.
Thanks,
James
|
|
|
Re: Find out how long is the field or column [message #681598 is a reply to message #681597] |
Fri, 07 August 2020 00:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
From your previous topic:
pablolee wrote on Fri, 02 November 2018 07:21Hi James. This looks a LOT like a homework assignment, which implies that you are studying SQL as part of a course.
Have you had a crack at writing the query? If you have, post what you tried and folk here will happily help to guide you. If you haven't, read your notes and give it a try, then post what you tried and folk here will happily help to guide you.
GL
And if you want to continue to get help you should envisage to feedback in your topics.
[Updated on: Fri, 07 August 2020 00:11] Report message to a moderator
|
|
|
Re: Find out how long is the field or column [message #681741 is a reply to message #681598] |
Mon, 24 August 2020 08:51 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Bill B
Messages: 1971 Registered: December 2004
|
Senior Member |
|
|
are you looking for data in the name column that is a minimum of 10 characters in length? If that is true, show us what you have tried and we will help. We don't spoon feed answers to students because they will never learn the skill. If you read my first paragraph I have given you everything you need to do it on your own.
|
|
|