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 |
what are the authentication modes in sql server? : Sql dba
i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....
How can you create Cursor with parametres ?
Show the cursor attributes of pl/sql.
What is difference between stored procedure and trigger?
Which one is the Best approach to put code, among Triggers and Procedures? Explain?
What is query execution plan in sql?
What is the sql*loader? : aql loader
What is sql*plus?
What is the difference between delete and truncate commands?
How to display the current date in sql?
How many types of index are there?