Answer Posted / 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

How to assign sql query results to pl sql variables?

990

---

Is sql a oracle?

913

---

Does mysql_real_escape_string prevent sql injection?

906

---

How many databases can sql express handle?

941

---

Show the two pl/sql cursor exceptions.

1103

---

What is sql query limit?

909

---

What is information schema in sql?

1012

---

What is sql*loader and what is it used for? : aql loader

1092

---

What are the two types of exceptions.

1105

---

what is a primary key? : Sql dba

981

---

What is a data definition language?

1026

---

What are the types of keys?

930

---

Is sql the best database?

912

---

Can we use ddl statements in stored procedure sql server?

964

---

How to find 3rd highest salary of an employee from the employee table in sql?

1034

---