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
- 7393 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 |
How to synchronize 2 schema's objects?
Can I create users through internet explorer in oracle 10g?
What is Oracle table?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
when do u go for hash partitioning?
What happens to the current transaction if a ddl statement is executed?
What is the meaning of recursive hints in oracle?
Why we choose emp number as primarykey?
Explain rename?
What is a database schema in oracle?
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?
What is hot backup and logical backup?
Oracle General 
