Interested to Buy Any Domain ? << Click Here >> for more details...
How to find string or key value using pl/sql code?
- 2 Answers
- 10336 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 |
What is the command used to fetch the first 5 characters of a string?
What are the events on which a database trigger can be based?
Why partition by is used in sql?
What is inner join in sql?
describe mysql connection using mysql binary. : Sql dba
Can we join same table in sql?
Does oracle use sql?
Difference between views and materialized views?
what are different types of keys in sql?
What is delimiter in pl sql?
what are the properties and different types of sub-queries? : Sql dba
What is difference between primary and secondary key?
-
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)
