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 sqlite format?
what are the types of join and explain each? : Sql dba
What is error ora-01000: maximum open cursors exceeded
What is the difference between sql and mysql?
Define the select into statement.
What version is sql?
What is a join?
How we can update the view?
how can you create an empty table from an existing table? : Sql dba
How do I find duplicates in a single column in sql?
what are tables and fields? : Sql dba
Why is stored procedure faster than query?
how to create a table index in mysql? : Sql dba
Can we update views in sql?
What is denormalization in a database?