Home » SQL & PL/SQL » SQL & PL/SQL » Find out how long is the field or column
Find out how long is the field or column [message #681597] Thu, 06 August 2020 18:32 Go to next message
james94539
Messages: 2
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 messageGo to next message
Michel Cadot
Messages: 67374
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

From your previous topic:

pablolee wrote on Fri, 02 November 2018 07:21
Hi 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
Bill B
Messages: 1969
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.
Previous Topic: ORA-29279: SMTP permanent error (split from hijacked topic)
Next Topic: row_number with duplicity
Goto Forum:
  


Current Time: Tue Sep 29 22:16:34 CDT 2020