How to find string or key value using pl/sql code?
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
what is the difference between $message and $$message? : Sql dba
what are the differences between require and include, include_once and require_once? : Sql dba
Can you skip header records while loading? : aql loader
How do I count rows in sql query?
Differentiate pl/sql and sql?
How do I remove all records from a table?
What are pl/sql packages?
what is a trigger in mysql? Define different types of trigger. : Sql dba
Explain correlated query work?
how to increment dates by 1 in mysql? : Sql dba
What is inner join in sql?
What does fetching a cursor do?
How do you select unique values in sql?
What is trigger in sql? Explain
Define concurrency control. : Transact sql