?
Solved

how do i query to get the maximum characters in a field

Posted on 2011-09-30
2
Medium Priority
?
322 Views
Last Modified: 2012-05-12
I  need to know what is the largest number of characters in a field
I know how the field is defined. But I don't know the largest value that is used from all the records in that table

does anyone know how I can query for this info. I know it is easy to find max with number. Is ther a way somehow to do the same for characters
0
Comment
Question by:sikyala
2 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 2000 total points
ID: 36893638
select max(length(your_field)) from your_table
0
 

Author Closing Comment

by:sikyala
ID: 36893647
great thanks
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc. This document explains the different types of consol…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

568 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question