StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
1681631
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2009-11-05T16:10:55.603
FavoriteCount
0
LastActivityDate
2009-11-05T16:10:55.603
LastEditDate
LastEditorUserId
0
OwnerUserId
6568
ParentId
1671466
PostTypeId
2
Score
7
ViewCount
0
LastEditorDisplayName
text
Body
In addition to the previous answer, there are significant differences in the scope of the declaration. When you declare a type in PL/SQL, such as the record type in your example, it is only usable from PL/SQL. If it is declared locally to a procedure or function, then it can only be used within that subprogram; if it is declared in a package body it can only be used within that package; if it is declared in a package header it can be used by any PL/SQL code that has execute access to the package. In no way can it be referenced in SQL statements, even ones embedded in the PL/SQL code. When you create an object type, or other schema-level type definitions such as nested tables, it is usable within both SQL and PL/SQL. As a very simple example, you can base a table definition on the object definition: <pre><code>SQL> CREATE OR REPLACE TYPE "TYPE_NAME1" AS OBJECT 2 ( 3 temp_trans_id number(10), 4 trans_id number(10), 5 resion_id number(10) 6 ) 7 / Type created. SQL> create table type_name1_tab of type_name1; Table created. SQL> desc type_name1_tab Name Null? Type ----------------------------------------- -------- ---------------------------- TEMP_TRANS_ID NUMBER(10) TRANS_ID NUMBER(10) RESION_ID NUMBER(10) </code></pre> <a href="http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_8001.htm#sthref5819" rel="noreferrer">See here</a> for documentation on the CREATE TYPE statement and references to further documentation on the various uses of object types.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POwhat is the difference between oracle "create or replace type" and "type type_name is..." syntax
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USDave Costa
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POwhat is the difference between oracle "create or replace type" and "type type_name is..." syntax
 singulars
 PostTypePostTypeId
 PTQuestion
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
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
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.