Posted on by admin

ORACLE – Criar tipo de Dados

Criando o Objeto

1
2
3
4
5
6

create or replace TYPE "TIPO_DE_DADOS_NUM_4P"                                                                                                                                                                                                                                    as object (
GRUPO number,
SEQUENCIAL number,
CODCOLIGADA number,
IDMOV number
)

Criar a tabela generica caso usado em tabelas dinamicas ex(select * from table(TAB_GENERICA_NUM_4P))

create or replace TYPE “TAB_GENERICA_NUM_4P”