Home > Default > Dynamic iterating over table columns

Dynamic iterating over table columns

November 30Hits:0
Advertisement
hello there,
i have to create a string depending on the values in my table columns. this string creation is used on different tables with different number of columns and different column types.
so i want to write a procedure which does simplified the following:
1. create dynamic rowtype with a select statement
2. iterate over rowtype columns and append column value to a string
3. insert the created string in another table.
by trying this dynamically for any table i run in the following two issues:
1. creation of a rowtype needs the tabletype
2. no iterating over rowtype possible
are their any ideas to solve this issue. or do i have to write a procedure for every table i use.
regards,
rené

Answers

You can do it with a single, generic procedure using DBMS_SQL.
Joe Fuda
SQL Snippets

Read other 6 answers

Tags:

Related Articles

  • Dynamic iterating over table columnsNovember 30

    hello there, i have to create a string depending on the values in my table columns. this string creation is used on different tables with different number of columns and different column types. so i want to write a procedure which does simplified the

  • Dynamic Component in Table ColumnNovember 30

    JDev 11.1.1.6 Can anyone give me guidance on how to change the component that a table column uses at runtime? Basically, I want to have an Input Text on Column B when the value on the Output Text on Column A is within a list of strings. Otherwise, I

  • Dynamic binding for table columnOctober 11

    Hi, I am using standard application and in a table (not ALV) i want to chnage the name of a column. Already a OTR is placed in it so am planning to do a dynamic bind for the text in the header. Kindly suggest ways. Thanks, KoushikDATA:         l_capt

  • Open a Dynamic URL from a Table column linkOctober 11

    Hi, Jdev Version (11.1.1.6.0) I have requirement to open a dynamic URL from table column. Any time I click on link, it should generate dynamic URL based on column attribute and open in popup or browser. Can someone pls suggest how to achieve this. Th

  • Dynamically changing the Advance table column Header.November 30

    Dear All, I want to change dynamically the Advance table column header. I tried the below code and its working process request,not in process form request when button pressing. Please suggest me.          OAAdvancedTableBean tableBean =              

  • Dynamic table columns...October 11

    hi there, i have a table on my webdynpro with several columns displaying values in EUR with 2 decimals. now my customer wants to be able to switch between EUR and Thousand-EUR. When Thousand-EUR is displayed ther should be no decimals visible anymore

  • SQL from Table Column with Dynamic URL ProblemNovember 30

    This is the SQL I'm attempting to save to a table column via the Object Browser; select "a"."PBR_BRIEF_ID" "Brief ID", "a"."PROJECT_NUMBER" "Project", "b"."DESCRIPTION" "

  • Dynamic table column creationNovember 30

    Hi All, I am trying to create a table where the number of columns is equal to the number of entries in an output table in my context. How do I go about creating columns dynamically dependant on the number of entries in a table? Kind regards SebIf you

  • Dynamic table column editingNovember 30

    Hi, I made a VO with quite complex query (nested subqueries linked with inner join) and when I dragged it from Data Control to the page I didn't get the familiar context menu with implementation options I used to get it earlier. Instead of, I got an

  • Dynamic entry list used in a table columnNovember 30

    On a form, we noticed a dynamic entry list will limit which values a user may enter by validating against the entry list values.  We need to have the same validation occur when a dynamic entry list is used in a table column. Has anyone had success in

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 1.109 s.