Interested to Buy Any Domain ? << Click Here >> for more details...
How to find string or key value using pl/sql code?
- 2 Answers
- 10296 Views
- Ramco, I also Faced
- E-Mail Answers
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)
