Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / pradeep

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

Is This Answer Correct ?    15 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the use of system.effective.date variable in oracle?

1161


22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

2077


What is max rowid in oracle?

1079


Is there a function to split a string in plsql?

1105


Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

3015


How do we display rows from the table without duplicates?

1014


What are the different oracle database objects?

1145


How to Truncate Table in Oracle

1210


What privilege is needed for a user to delete rows from tables in another schema?

1133


What are the predefined tablespaces in a database?

1140


why dont we assign not null constraint as table level constraint.

2796


How to define an oracle cursor variable?

1090


How do I manually uninstall oracle client?

1145


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1981


What are ddl statements in oracle?

1125