Submitted Questions

  • Oracle sequence generator

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


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

  • External table in oracle

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

  • Rows pivoting

    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


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


    • Jan 14th, 2015

    Pivoting means converting rows to column and vise verse.

    Please use normalization transformation to achieve this.

  • pivoting of the records

    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.


    • 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)
    Give one output port say Output_name =New_name


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