Home » SQL & PL/SQL » SQL & PL/SQL » Create a table for fields and record type
Create a table for fields and record type [message #304756] Thu, 06 March 2008 08:56 Go to next message
aadebayo
Messages: 35
Registered: August 2005
Member
Hello

I need to create a table that will contain data drawn from some fields and a whole record type. For example

Create a table that has the following columns

Deptno
Deptnumber
manager
employee_rec

where employee_rec is a record type of employees

Please can some one tell me how to do this.
Re: Create a table for fields and record type [message #304762 is a reply to message #304756] Thu, 06 March 2008 09:16 Go to previous message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_7002.htm#i2139603
Above link gives you a starting point try to build it from there.

Regards

Raj
Previous Topic: Basic Sql statement need advice on
Next Topic: Really its a challenge for experts.....help please
Goto Forum:
  


Current Time: Fri Dec 02 16:21:54 CST 2016

Total time taken to generate the page: 0.17249 seconds