Interested to Buy Any Domain ? << Click Here >> for more details...
how to i write the query 'NISHI' TO
N
I
S
H
I
- 4 Answers
- 7401 Views
- Attra, Metric Stream, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pradeep
Select SUBSTR('NISHI',LEVEL,1) from dual
CONNECT BY LEVEL<=length('NISHI')
| Is This Answer Correct ? | 15 Yes | 1 No |
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;
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / karthik
SELECT 'NISHI' NAME FROM DUAL;
COLUMN NAME FORMAT A1
/
| Is This Answer Correct ? | 1 Yes | 3 No |
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........
How to get execution statistics reports on query statements?
Explain the use of constraints option in exp command.
How do I use unicode codesets with the weblogic jdriver for oracle driver?
What is oracle datasource?
What happens if recursive calls get out of control?
primary key is foreign key for the same table?
How to load data through external tables?
how to find out second largest value in the table
how to do daily transactions with out sql* loader control file regesterd in apps?
What happens to the current transaction if the session is ended?
Oracle General 
