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