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...

my name is amar i want display 1st line A 2nd line M 3rd line
A 4th line R in database & informatica

Answer Posted / lajpat kurdiya

SELECT SUBSTR('AMAR',LEVEL,1) AS Name
FROM DUAL
CONNECT BY LEVEL<= LENGTH('AMAR');

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is grain of fact?

955


List few etl bugs?

930


what is different between sequential batch and concurrent batch and which is recommended and why?

4921


what is the difference between cubes and package in cognos

4941


Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

944


Can we create Hierarchies in generic datasources?

2372


what is session partitioning?

2103


what are the concerns of OLTP and DSS systems?

2442


what are the concerns of OLTP and DSS systems?

1954


Explain about etl data integration software?

879


can cubes contain measures ?

2021


list and discuss two approaches for updation of target table in Informatica and how they are different.

2102


What is tracing level?

1055


What is tracing level? How many types of transformations supported by sorted input?

958


How many types of transformations supported by sorted input?

1212