Variable size.

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Wed, 06 Jun 2007 10:30 am

Guys, something else ... How do I do a select to discover what is the biggest name in a table in the name column.

Thank you!

Paul
Mr.Paulo
Location: Barretos-SP

Poston Wed, 06 Jun 2007 12:24 pm

Brother, if it is to find the biggest name typed in a name field of your table, make the adaptation of this script below to your table.

Code: Select all
SELECT max(length(campo))
  FROM tabela;
Trevisolli
Location: Araraquara - SP

Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP



Return to SQL

Who is online

Users browsing this forum: No registered users and 2 guests