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

what is offset-fetch filter in tsql? : Transact sql

939

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2069

---

How do you pronounce sql?

1001

---

How does an execution block start and end in pl sql?

942

---

How to select random rows from a table?

1069

---

How many databases can sql express handle?

976

---

What are the two types of periodical indexes?

934

---

What is time based sql injection?

953

---

What is delimiter in pl sql?

1050

---

Why commit is not used in triggers?

1033

---

Explain the components of sql?

1053

---

What is the difference between view and stored procedure?

957

---

what is an extent ? : Sql dba

1082

---

How do you sort in sql?

1003

---

What type of database is sql?

1018

---