It is found in the TEXT of SQL for dummies book :
ROW types The ROW data type was introduced with SQL:1999. It’s not that easy to understand, and as a beginning to intermediate SQL programmer, you may never use it. After all, people got by without it just fine between 1986 and 1999. One notable thing about the ROW data type is that it violates the rules of normalization that E.F. Codd declared in the early days of relational database theory. I talk more about those rules in Chapter 5. One of the defining characteristics 33 Chapter 2: SQL Fundamentals of first normal form is that a field in a table row may not be multivalued. A field may contain one and only one value. However, the ROW data type allows you to declare an entire row of data to be contained within a single field in a single row of a table — in other words, a row nested within a row. Consider the following SQL statement, which defines a ROW type for a person’s address information: CREATE ROW TYPE addr_typ ( Street CHARACTER VARYING (25) City CHARACTER VARYING(20) State CHARACTER (2) PostalCode CHARACTER VARYING (9) ) ; After it’s defined, the new ROW type can be used in a table definition: CREATE TABLE CUSTOMER ( CustID INTEGER PRIMARY KEY, LastName CHARACTER VARYING (25), FirstName CHARACTER VARYING (20), Address addr_typ Phone CHARACTER VARYING (15) ) ; On Aug 20, 1:32 am, Michael Moore <michaeljmo...@gmail.com> wrote: > There is no such thing as CREATE ROW > > > > > > > > On Sun, Aug 19, 2012 at 2:41 PM, happytoday <ehabaziz2...@gmail.com> wrote: > > CREATE ROW TYPE addr_typ ( > > Street CHARACTER VARYING (25) > > City CHARACTER VARYING(20) > > State CHARACTER (2) > > PostalCode CHARACTER VARYING (9) > > ) ; > > > CREATE ROW TYPE addr_typ ( > > * > > > ERROR at line 1: > > ORA-00901: invalid CREATE command > > > -- > > You received this message because you are subscribed to the Google > > Groups "Oracle PL/SQL" group. > > To post to this group, send email to Oracle-PLSQL@googlegroups.com > > To unsubscribe from this group, send email to > > oracle-plsql-unsubscr...@googlegroups.com > > For more options, visit this group at > >http://groups.google.com/group/Oracle-PLSQL?hl=en -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
