ALL_PRODUCTS

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   ALL_PRODUCTS

Name
COLOR
DESCRIPTION
ID
MANAGER_ID
PICTURE_NAME
PROD_SIZE
QUANTITY
TOTAL_HT
UNIT_PRICE

CREATE VIEW ALL_Products (Id, Description, Color, Picture_name, prod_size,quantity,Total_HT,unit_price,Manager_Id)
	AS SELECT 
			P.Id,
			P.Description,
			P.Color,
			P.Picture_name,
			P.prod_size,
			P.quantity,
			P.Total_HT,
			P.unit_price,
      p.Manager_Id
		FROM
			product P

Name	Types	Description
<DEFAULT SCHEMA>.PRODUCT	Table	Table
COLOR	Column	Virtual column
DESCRIPTION	Column	Virtual column
PICTURE_NAME	Column	Virtual column
PROD_SIZE	Column	Virtual column
QUANTITY	Column	Virtual column
TOTAL_HT	Column	Virtual column
<DEFAULT SCHEMA>.PRODUCT.UNIT_PRICE	Column	Column
<DEFAULT SCHEMA>.PRODUCT.ID	Primary Key	Column
<DEFAULT SCHEMA>.PRODUCT.MANAGER_ID	Foreign Key	Column

Name	Types	Description
<DEFAULT SCHEMA>.PRODUCTS.GetAllProducts.c1	Cursor	PLSQL Cursor defined in PRODUCTS.GetAllProducts
<DEFAULT SCHEMA>.PRODUCTS.GetProductById.c1	Cursor	PLSQL Cursor defined in PRODUCTS.GetProductById
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer.Select	Select Statement	select fname, lname, all_products.name, all_products.prod_size, all_products.id,
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer.Select	Select Statement	select fname, lname, name, prod_size into cust_fname, cust_lname, prod_name, prod_size fro
<DEFAULT SCHEMA>.TRG_ORDER.Select	Select Statement	select fname, lname, name, prod_size into cust_fname, cust_lname, prod_name, prod_size
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer.Select	Select Statement	select fname,lname, all_products.name, all_products.prod_size, all_products.id, product.n
<DEFAULT SCHEMA>.EMPLOYEES.OrdersByEmployee2.Select	Select Statement	SELECT sales_order.id Oid, sales_order.order_date Odate, DECODE(sales_order.fi
<DEFAULT SCHEMA>.PRODUCTS.GetProductById.c1.Select	Select Statement	SELECT Id, Description, Color, Picture_name, prod_size,quantity,Total_HT,unit_price FROM ALL_Prod
<DEFAULT SCHEMA>.EMPLOYEE_DELETING.C1.Select	Select Statement	SELECT manager_fname FROM ALL_PRODUCTS where Manager_Id = :old.EMP_ID
<DEFAULT SCHEMA>.PRODUCTS.GetAllProducts.c1.Select	Select Statement	SELECT Id, Description, Color, Picture_name, prod_size,quantity,Total_HT,unit_price FROM ALL_Prod
<DEFAULT SCHEMA>.EMPLOYEE_DELETING.C1	Variable	ALL_PRODUCTS