Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Strange View in the database

Strange View in the database

From: anish <anish_recd_at_yahoo.co.in>
Date: 2 Aug 2005 02:27:44 -0700
Message-ID: <1122974863.977858.91370@g43g2000cwa.googlegroups.com>


There is this strange view in the database i am working on: "create or replace view inv_dtls as
select to_char(null) supplier_name,to_date(null) invoice_date, to_number(null) invoice_number from dual where 1=2"  Can any body please tell why exactly such views are needed .Front end of the application is designed using forms 6i.

Regards,
Anish Received on Tue Aug 02 2005 - 04:27:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US