how to i write the query 'NISHI' TO
N
I
S
H
I
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 run queries on external tables?
How to connect to the server with user account: sys?
What is sharded cluster?
What are the general rules on data consistency?
Define the terms primary key foreign key and also the difference between primary and the unique key
What are the tools for Oracle ?
What are the components of Physical database structure of Oracle Database?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is Public Database Link ?
What is Parallel Server ?
How to update values in a table in oracle?
25. Display the client number and the value of the highest value order placed by that client.