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


Please Help Members By Posting Answers For Below Questions

what is the difference between $message and $$message? : Sql dba

555


what are the differences between require and include, include_once and require_once? : Sql dba

534


Can you skip header records while loading? : aql loader

544


How do I count rows in sql query?

493


Differentiate pl/sql and sql?

565






How do I remove all records from a table?

572


What are pl/sql packages?

575


what is a trigger in mysql? Define different types of trigger. : Sql dba

562


Explain correlated query work?

601


how to increment dates by 1 in mysql? : Sql dba

545


What is inner join in sql?

590


What does fetching a cursor do?

621


How do you select unique values in sql?

511


What is trigger in sql? Explain

538


Define concurrency control. : Transact sql

589