how to i write the query 'NISHI' TO
N
I
S
H
I

Answers were Sorted based on User's Feedback



how to i write the query 'NISHI' TO N I S H I..

Answer / pradeep

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

Is This Answer Correct ?    15 Yes 1 No

how to i write the query 'NISHI' TO N I S H I..

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

how to i write the query 'NISHI' TO N I S H I..

Answer / karthik

SELECT 'NISHI' NAME FROM DUAL;

COLUMN NAME FORMAT A1
/

Is This Answer Correct ?    1 Yes 3 No

how to i write the query 'NISHI' TO N I S H I..

Answer / madhu

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

Is This Answer Correct ?    2 Yes 6 No

Post New Answer

More Oracle General Interview Questions

How to use group functions in the select clause using oracle?

0 Answers  


What is use of oracle?

2 Answers   Satyam,


Explain user account with reference to oracle.

0 Answers  


What is a Database instance ? Explain?

3 Answers  


What is Data Dictionary Cache in Oracle?

0 Answers   MCN Solutions,






What are the ansi data types supported in oracle?

0 Answers  


What is dictionary cache ?

2 Answers  


What is a partition in oracle?

0 Answers  


What are the differences between interval year to month and interval day to second?

0 Answers  


How to store pictures on to the database?

0 Answers  


How to insert a record into a table?

0 Answers  


how to produce numbers from 1 to 10 using dual table

4 Answers   Genpact,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)