<div>
Seeems that it' Informix, not Oracle.<br />
<br />
An explanation is here:<br />
<br />
<a href="http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sqls.doc/sqls254.htm" rel="ugc nofollow">http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sqls.doc/sqls254.htm</a><br />
<br />
wmp<br />

</div>


Seeems that it' Informix, not Oracle.

An explanation is here:

http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sqls.doc/sqls254.htm [http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sqls.doc/sqls254.htm]

wmp


<div>
In Oracle you can create a TYPE as ROWTYPE in PL/SQL. You can't use create rowtype.<br />
<br />
%ROWTYPE is used to declare a record with the same types as found in the specified database table, view or a cursor.<br />
<br />
<a href="http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/rowtype_attribute.htm" rel="ugc">http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/rowtype_attribute.htm</a>
</div>


In Oracle you can create a TYPE as ROWTYPE in PL/SQL. You can't use create rowtype.

%ROWTYPE is used to declare a record with the same types as found in the specified database table, view or a cursor.

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/rowtype_attribute.htm [http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/rowtype_attribute.htm]

<div>
Right.. I think your question is answered....<br />
<br />
Cheers...
</div>


Right.. I think your question is answered....

Cheers...

<div>
<div class="content wysiwyg-content">
Guys, <br />
<br />
I'm trying to understand the following statements do in Oracle.<br />
<br />
CREATE ROW TYPE employee_type &nbsp;(<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ename &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;VARCHAR(25),<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ssn &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CHAR(9),<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;salary &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;INT) ;<br />
<br />
CREATE ROW TYPE engineer_type (<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;degree &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;VARCHAR(10),<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;license &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;VARCHAR(20))<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;UNDER employee_type ;<br />
<br />
CREATE ROW TYPE engr_mgr_type (<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;manager_start_date &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DATE<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dept_managed &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;VARCHAR(20))<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;UNDER engineer_type ;<br />
<br />
What I'm just trying to understand is what does the CREATE ROW TYPE bit do?
</div>
</div>


Guys, 

I'm trying to understand the following statements do in Oracle.

CREATE ROW TYPE employee_type  (
	ename 	VARCHAR(25),
	ssn	CHAR(9),
	salary	INT) ;

CREATE ROW TYPE engineer_type (
	degree 	VARCHAR(10),
	license	VARCHAR(20))
	UNDER employee_type ;

CREATE ROW TYPE engr_mgr_type (
	manager_start_date	DATE
	dept_managed	VARCHAR(20))
	UNDER engineer_type ;

What I'm just trying to understand is what does the CREATE ROW TYPE bit do?

SQL statements - What do they do?

C is a general-purpose, imperative computer programming language, supporting structured programming, lexical variable scope and recursion, while a static type system prevents many unintended operations. By design, C provides constructs that map efficiently to typical machine instructions, so it has found lasting use in applications that had formerly been coded in assembly language, including operating systems as well as various application software for computers ranging from supercomputers to embedded systems. It is distinct from C++ (which has its roots in C) and C#, and many later languages have borrowed directly or indirectly from C.

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.