Skip to content

Instantly share code, notes, and snippets.

@programaker

programaker/oracle-get-bigger-strings-in-a-field.sql

Created December 14, 2009 13:24
Show Gist options
  • Save programaker/256042 to your computer and use it in GitHub Desktop.
Save programaker/256042 to your computer and use it in GitHub Desktop.
Download ZIP
get the bigger strings in a field in oracle
Raw
oracle-get-bigger-strings-in-a-field.sql
select
varchar_field, length(varchar_field)
from
table_name
where
length(varchar_field) in (
select max(length(varchar_field)) from table_name
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment