StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
3584813
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-08-27T13:51:40.717
FavoriteCount
0
LastActivityDate
2010-09-08T09:45:41.137
LastEditDate
2010-09-08T09:45:41.137
LastEditorUserId
362880
OwnerUserId
362880
ParentId
3584028
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
This solution at first glance it looks complicated, but generally resolves any range. Solve problem with VALUEs which may be interfered with any other range. Firstly create sample table and insert data: <pre><code>create table test_table (col_START NUMBER, col_END NUMBER, col_MAP CHAR(1)); insert into test_table(col_START, col_END, col_MAP) values(1,10,'A'); insert into test_table(col_START, col_END, col_MAP) values(11,15,'B'); insert into test_table(col_START, col_END, col_MAP) values(5,12,'C'); </code></pre> Now data look like this: <pre><code>START | END | MAP 1 | 10 | A 11 | 15 | B 5 | 12 | C </code></pre> Now create object type: <pre><code>CREATE TYPE SampleType AS OBJECT ( id number, map_string varchar2(2000) ) / CREATE TYPE SampleTypeSet AS TABLE OF SampleType / </code></pre> And also create PIPELINED FUNCTION: <pre><code>CREATE OR REPLACE FUNCTION GET_DATA RETURN SampleTypeSet PIPELINED IS l_one_row SampleType := SampleType(NULL, NULL); BEGIN FOR cur_data IN (select col_START, col_END, col_MAP from test_table) LOOP FOR i IN cur_data.col_START..cur_data.col_END LOOP l_one_row.id := i; l_one_row.map_string := cur_data.col_MAP; PIPE ROW(l_one_row); END LOOP; END LOOP; RETURN; END GET_DATA; / </code></pre> Finally you can use simple query: <pre><code>SELECT * FROM TABLE(GET_DATA()); </code></pre> Or create and select it from view (if you want hide OBJECT implementation): <pre><code>CREATE VIEW VIEW_ALL_DATA AS SELECT * FROM TABLE(GET_DATA()); SELECT * FROM VIEW_ALL_DATA; </code></pre> Based on this my article: <a href="http://martin-mares.cz/2010/08/oracle-db-pipelined-function/" rel="nofollow noreferrer">http://martin-mares.cz/2010/08/oracle-db-pipelined-function/</a>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POhow to calc ranges in oracle
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USMartin Mares
UserOwnerUserId
1. USMartin Mares
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. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

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.