demo -  procedures -  GROUPO.ShowCustomers

Description

ShowCustomers shows the identifiers and company names of customers. It takes no arguments. 

Procedure properties

name	value
name	GROUPO.ShowCustomers
created
type	SQL stored procedure

Parameters

none

Usage

EXEC GROUPO.ShowCustomers

Dependency graph

Objects that GROUPO.ShowCustomers depends on

name	object type	level
Customers	table	1
company_name_t	type	2
phone_number_t	type	2
postal_code_t	type	2
country_t	type	2
state_t	type	2
city_t	type	2
street_t	type	2
person_name_t	type	2

Code

create procedure GROUPO.ShowCustomers()
result( ID integer,
  CompanyName company_name_t ) 
begin
  select ID,CompanyName
    from GROUPO.Customers
end