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

Answer / kumarvijay

var=1; --var='a'

select to_number(var) from dual;

if variable holds string it will through exception else it
will execute.

What does trigger mean in psychology?

0 Answers  

---

how can you see all indexes defined for a table? : Sql dba

0 Answers  

---

Which command is used to delete a trigger?

0 Answers  

---

what is sql profiler? : Sql dba

0 Answers  

---

What is blind sql injection?

0 Answers  

---

what is the difference between cluster and non cluster index? : Sql dba

0 Answers  

---

How to retrieve a second highest salary from a table? Note:Suppose salaries are in duplicate values eg: Name Sal Malli 60000 Pandi 60000 Rudra 45000 Ravi 45000

10 Answers   Mind Tree, Polaris, Sonata,

---

Write a query to display the current date in sql?

0 Answers  

---

how to rename an existing table in mysql? : Sql dba

0 Answers  

---

How to get each name only once from an employee table?

0 Answers  

---

what is an alias command? : Sql dba

0 Answers  

---

How do you use a while loop in pl sql?

0 Answers  

---