Interested to Buy Any Domain ? << Click Here >> for more details...
How to find string or key value using pl/sql code?
- 2 Answers
- 10338 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 |
How many types of functions are there in sql?
what is a primary key? : Sql dba
Is sql a programming?
what are integrity rules?
What is data abstraction in sql?
What is window clause?
How do you explain an index number?
What operators deal with null?
Can you load data into multiple tables at once? : aql loader
how many tables will create when we create table, what are they? : Sql dba
What is multiple partition?
Tell me what a package consists of.
-
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)
