StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to concatenate table name with variable within for loop in sql
primarykey
Id
18745950
data
AcceptedAnswerId
18746420
AnswerCount
1
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2013-09-11T15:55:48.510
FavoriteCount
0
LastActivityDate
2013-09-11T16:39:23.207
LastEditDate
LastEditorUserId
0
OwnerUserId
131764
ParentId
0
PostTypeId
1
Score
0
ViewCount
834
LastEditorDisplayName
text
Body
<p>I am trying to write a one time (as in never to be run again) script to collect information about usage of certain features of our product. Here is a simplified script that I have right now:</p> <pre class="lang-sql prettyprint-override"><code>begin for db in (select owner from dba_tables where table_name='feature_table') loop begin for info in (select * from db.owner.feature_table where something='important') loop begin dbms_output.put_line(db.owner||' , '||info.type||' , '||info.source); end; end loop; end; end loop; end; </code></pre> <p>I get an error in the inner loop at "db.owner.feature_table". I also tried passing it as concatenated string, but to no avail. What do I need to do to get this to work?</p>
Tags
<sql><oracle11g>
Title
How to concatenate table name with variable within for loop in sql
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USEmilis Panovas
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COWhy not just query the applicable tables and output the results?
  singulars
  PostPostId
  POHow to concatenate table name with variable within for loop in sql
  UserUserId
  USDan Bracuk
2. COI presume you mean skipping the first loop. The reason I need it because it will end up with few thousand records. So it needs to loop over few thousand times on average 10 records. It would be a lot of manual labor.
  singulars
  PostPostId
  POHow to concatenate table name with variable within for loop in sql
  UserUserId
  USEmilis Panovas

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.