ALL_NEWPRODUCT | |
|
<DEFAULT SERVER> > <DEFAULT DATABASE> > <DEFAULT SCHEMA> > ALL_NEWPRODUCT |
Name |
---|
DESCRIPTION |
NAME |
PROD_SIZE |
QUANTITY |
TOTAL_HT |
UNIT_PRICE |
CREATE VIEW ALL_NewProduct (Name, Description, prod_size, Quantity,Total_HT,unit_price)
AS SELECT
P.Name,
P.Description,
P.prod_size,
P.Quantity,
P.Total_HT,
P.unit_price
FROM
NewProduct P
Name | Types | Description |
---|---|---|
<DEFAULT SCHEMA>.NEWPRODUCT | Table | Table |
DESCRIPTION | Column | Virtual column |
<DEFAULT SCHEMA>.NEWPRODUCT.NAME | Column | Column |
PROD_SIZE | Column | Virtual column |
QUANTITY | Column | Virtual column |
TOTAL_HT | Column | Virtual column |
<DEFAULT SCHEMA>.NEWPRODUCT.UNIT_PRICE | Column | Column |
Name | Types | Description |
---|---|---|
<DEFAULT SCHEMA>.PRODUCTS.InitProduct.c1 | Cursor | PLSQL Cursor defined in PRODUCTS.InitProduct |
<DEFAULT SCHEMA>.PRODUCTS.InitProduct.c1.Select | Select Statement | SELECT name,description, prod_size, quantity,unit_price FROM ALL_NewProduct |