How to find string or key value using pl/sql code?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kumarvijay
var=1; --var='a'
select to_number(var) from dual;
if variable holds string it will through exception else it
will execute.
| Is This Answer Correct ? | 0 Yes | 1 No |
Is it possible to include an insert statement on the same table to which the trigger is assigned?
Explain constraints in sql?
what are all the different types of indexes? : Sql dba
What is data modelling in sql?
Can we join more than 2 tables in sql?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
Talk about views
What is clustered and nonclustered index in sql?
i need department wise top 2 employees salary.which logic i will use
How do I count rows in sql query?
what is the difference between truncate and drop statements? : Sql dba
how to use 'mysql' to run sql statements? : Sql dba
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)