if you want to find a string value you can use the following command sel

How to find string or key value using pl/sql code?

Question Posted / gourvendra singh

2 Answers
10337 Views
Ramco, I also Faced
E-Mail Answers

Answer Posted / gourvendra singh

if you want to find a string value you can use the
following command
select length(TRIM(TRANSLATE(string,'+-.123456789',' ')))
from dual;
string=value that u entered
if the result is null then the string is numeric else its a
character

Is This Answer Correct ?

5 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a procedure in pl sql?

1211

Does sql profiler affect performance?

992

what is rdbms? : Sql dba

1012

Is oracle and sql same?

1010

What is clause?

1151

Is it possible to create startup or shutdown trigger for on-schema?

1029

What does seeding a database mean?

965

How are sql commands classified?

1085

How many columns should be in an index?

963

What is normalization sql?

1056

what is the command used to fetch first 5 characters of the string? : Sql dba

1638

Explain locks? : Transact sql

1005

What is self-join and what is the requirement of self-join?

1151

how to fetch alternate records from a table? : Sql dba

1112

What are database links used for?

1047