Home » RDBMS Server » Server Administration » anchored declaration in type definition
anchored declaration in type definition [message #371616] Tue, 14 November 2000 23:01 Go to next message
Manju
Messages: 10
Registered: November 2000
Junior Member
hi,
i am creating an object based on a particular table,but instead of giving the data types explicitly like varchar2(100),number(10),date etc,i want to use an anchored definition like <base HREF="http://www.orafaq.com.way_back_stub/msgboard/sql/messages/2718.htm"tablename>.<columnname>%type
so that any changes in the base table can be automatically reflected in the object
is this possible?
i am getting an error on using such a declaration
any help in this regard will be appreciated
Manju
Re: anchored declaration in type definition [message #371617 is a reply to message #371616] Wed, 15 November 2000 02:46 Go to previous message
Indira Morishetty
Messages: 9
Registered: November 2000
Junior Member
Certainly it is possible.
The format is

.<field_name>%type
For eg.
emp.empno%type

Indira
Previous Topic: Re: Thankyou very much Salman Khan
Next Topic: Very..Very...Urgent
Goto Forum:
  


Current Time: Thu May 02 20:11:40 CDT 2024