Home » SQL & PL/SQL » SQL & PL/SQL » virtual table
virtual table [message #401554] Tue, 05 May 2009 09:16 Go to next message
tejas.patel
Messages: 22
Registered: December 2008
Location: NJ
Junior Member

I have two tables such as
PRITIKA@gold13>desc company_aclgrid;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 CLIENT_CODE                                        VARCHAR2(20)
 PRIORITY                                           NUMBER

PRITIKA@gold13>desc aclgrid;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 USERNAME                                  NOT NULL VARCHAR2(64)
 CLIENT_CODE                               NOT NULL VARCHAR2(50)
 GRADE                                     NOT NULL NUMBER
 PRIORITY                                           NUMBER
 PREF                                               NUMBER(1)
 FREEZE_VALUE                                       NUMBER
 COMPANY_FREEZE                                     NUMBER
 



I want a virtual table from the data of the above tables so that the username and client_code would be unique and the priority in company_aclgrid should not get repeated.

The data could be available from virtual table and any DML can be possible at any time.
Re: virtual table [message #401555 is a reply to message #401554] Tue, 05 May 2009 09:17 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>I want a virtual table
What exactly is a "virtual table"; one that exists only in your imagination?
Re: virtual table [message #401556 is a reply to message #401555] Tue, 05 May 2009 09:21 Go to previous messageGo to next message
tejas.patel
Messages: 22
Registered: December 2008
Location: NJ
Junior Member

in memory object like table type or temporary table.
Re: virtual table [message #401557 is a reply to message #401556] Tue, 05 May 2009 09:23 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
tejas.patel wrote on Tue, 05 May 2009 07:21
in memory object like table type or temporary table.


Provide URL to where this object is documented.

[Updated on: Tue, 05 May 2009 09:23]

Report message to a moderator

Re: virtual table [message #401567 is a reply to message #401557] Tue, 05 May 2009 10:09 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
BlackSwan wrote on Tue, 05 May 2009 16:23
tejas.patel wrote on Tue, 05 May 2009 07:21
in memory object like table type or temporary table.


Provide URL to where this object is documented.

... or define it completly.

Regards
Michel
Previous Topic: condition based on datetime
Next Topic: Rank Signal
Goto Forum:
  


Current Time: Sat Dec 10 13:09:31 CST 2016

Total time taken to generate the page: 0.10452 seconds