char_length

mrlindsey · July 28, 2011, 1:29pm

I’m trying to filter out some rows that do not have correct tracking numbers. The tracking numbers should be 15 characters long. I want to filter out the ones that are only 10 chars. Any ideas? Thanks!!!

Shirly · July 29, 2011, 1:32am

Hi Christopher,

We assume that what you asked for is having the filter in the data grid to provide you an option to filter the rows.
We don’t have that option yet in the current release of SQL Navigator.

I would like to check if it would work for you to use Oracle function "LENGTH() " to filter out the rows as per your requirement:

select * from table_name
where length(tracking_number)<>10;

Thanks and best regards,
Shirly

char_length

I would like to check if it would work for you to use Oracle function "LENGTH() " to filter out the rows as per your requirement:

select * from table_name where length(tracking_number)<>10;

select * from table_name
where length(tracking_number)<>10;