Home » SQL & PL/SQL » SQL & PL/SQL » virtual column 11g new feature
virtual column 11g new feature [message #289413] Fri, 21 December 2007 07:49 Go to next message
prince973
Messages: 37
Registered: November 2006
Member
dear all,
any body knows what is the difference between the two following ways to create a virtual column on a table
1-create table vtable1(sal number,tax number generated always as
(sal*0.01) virtual);
2-create table vtable1(sal number,tax number as
(sal*0.01));
best regards,
Re: virtual column 11g new feature [message #289415 is a reply to message #289413] Fri, 21 December 2007 08:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As the documentation says it, "virtual" is an optional keyword as well as "generate always" clause.
You can put them or not it is the same.

Regards
Michel

[Updated on: Fri, 21 December 2007 08:10]

Report message to a moderator

Re: virtual column 11g new feature [message #289424 is a reply to message #289413] Fri, 21 December 2007 10:04 Go to previous message
prince973
Messages: 37
Registered: November 2006
Member
thx michel
u r becoming teacher of 11g too , great job.
Previous Topic: How to CAST a String
Next Topic: please give me solution for this program
Goto Forum:
  


Current Time: Sun Dec 04 04:20:02 CST 2016

Total time taken to generate the page: 0.11205 seconds