How to write stored procedure,which take the sequence name as input and dynamically generates a nextval from that sequence

Ashish

• Jul 30th, 2014

"sql Create or Replace Procedure P_Get_Value( seqnm IN Varchar2) Is L_Var Varchar2(100); TYPE cur_typ IS REF CURSOR; c cur_typ; Begin OPEN c FOR SELECT || seqnm || ...

Answer Question  Select Best Answer

What is external table in oracle?How oracle read flat file?

sheraz baig

• Nov 20th, 2013

External Tables let you query data in a flat file. In 9i, only read operations were permitted; in 10g, you can also write out data to an external table. While external tables can be queried, theyre no...

Answer Question  Select Best Answer

Source: col2 col1 a 1 b 1 c 1 d 1 p 2 q 2 r 2 x 3 how to do this... thanks krishna

Manjunath

• Apr 9th, 2015

Converting rows into columns is de-normalizing, you may have to use aggregate transformation to do so. Note: vice verse is normalizing the data, that can be done using normalizer transformation. U...

Shiva

• Jan 14th, 2015

Pivoting means converting rows to column and vise verse.

Please use normalization transformation to achieve this.

Answer Question  Select Best Answer

source: target: col1 col2 col1 col2 a 1 1 a,b,c,d b 1 2 p,q,r c 1 3 x d 1 p 2 q 2 r 2 x 3 how to do this... Thanks, krishna.

rashmi

• Aug 12th, 2017

We can use aggregator transformation.say col1=Nme,col2=ID
Make new_name and new_no as variable port.Specify condition as New_name=IIF(new_no=ID,new_name||,||name,name)
new_no=ID
Give one output port say Output_name =New_name

suresh

• Apr 30th, 2017

I have to pivot the source data from column to rows till "transform" value, "transform" value can occurs any one of the columns, please advice me suggestions, Can any one help me how to achieve the be...

Answer Question  Select Best Answer