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

Explain the use of tables option in exp command.

0 Answers  

---

What privilege is needed for a user to create tables in oracle?

0 Answers  

---

What is the max number of columns in an oracle table?

0 Answers  

---

Why do you create or replace procedures rather that drop and recreate.

0 Answers  

---

how to use sequence and what use of sequence cache

1 Answers  

---

What to do if dba lost the system password?

0 Answers  

---

I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.

6 Answers  

---

How to write numeric literals in oracle?

0 Answers  

---

1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records

1 Answers  

---

i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash

2 Answers  

---

if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.

1 Answers   MasterCard,

---

what is the output of select * from emp where null=null & select * from emp where 1=1

8 Answers   IMS Health, NIIT,

---