Answer / pradeep

Select SUBSTR('NISHI',LEVEL,1) from dual
CONNECT BY LEVEL<=length('NISHI')

Answer / ajit nayak

DECLARE
V_NAME VARCHAR2(9);
V_LEN NUMBER;
V_POS VARCHAR2(10) := NULL;
BEGIN
V_NAME := '&ENTERNAME';
FOR I IN 1..LENGTH(V_NAME)
LOOP
V_POS := SUBSTR(V_NAME,I,1);
DBMS_OUTPUT.PUT_LINE(V_POS||CHR(10));
END LOOP;
END;

Answer / karthik

SELECT 'NISHI' NAME FROM DUAL;

COLUMN NAME FORMAT A1
/

Answer / madhu

Select To_char('N I S H I') from dual

what are stored procedures?

7 Answers   TCS, Wells Fargo,

---

Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL

1 Answers  

---

There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep

4 Answers   Microsoft,

---

What is the quickest way to export a table to a flat file?

0 Answers  

---

Can u make a synonym for deptno=10 only from emp table.

1 Answers   TCS,

---

Give the different types of rollback segments.

0 Answers  

---

How to find out what privileges a user currently has in oracle?

1 Answers  

---

Design database draw er diagram for a certain scenario ?

0 Answers   Keane India Ltd, TATA,

---

how to store only time in a data base table

2 Answers  

---

How to use subqueries with the exists operator in oracle?

0 Answers  

---

What is Private Database Link ?

1 Answers  

---

What is recycle bin in Oracle?

0 Answers   MCN Solutions,

---