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
- 7533 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 |
List the parts of a database trigger.
How do you store pictures in a database?
What are the four Oracle system processes that must always be up and running for the database to be useable?
find out the second highest salary?
55 Answers Cognizant, Nucsoft, Oracle, TCS, Wondersoft,
How many memory layers are in the oracle shared pool?
how to clone 9i Database on to 10g Database.
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.
what is exact difference between drop and truncate table.
State all possible different index configurations a table can possibly have?
How to insert a new row into a table in oracle?
What is oracle and what are its different editions?
What happens to the current transaction if a ddl statement is executed?
Oracle General 
