Skip to content

Instantly share code, notes, and snippets.

  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save vitorpiovezam/a0e0b21bc8f43aa4293410a7842f8dbf to your computer and use it in GitHub Desktop.
create table ldesk.opor_oportunidade(
id_oportunidade INTEGER,
titulo VARCHAR(100),
valor number(38,2),
situacao VARCHAR2(2),
DATA_INCLUSAO TIMESTAMP WITH TIME ZONE,
USUARIO_INCLUSAO VARCHAR2(50),
DATA_ALTERACAO TIMESTAMP WITH TIME ZONE,
USUARIO_ALTERACAO VARCHAR2(50)
)tablespace ldesk_data
create table ldesk.opor_oportunidade_detalhe(
id_oportunidade INTEGER,
id_oportunidade_detalhe INTEGER,
titulo VARCHAR(100),
valor number(38,2),
versao INTEGER,
situacao VARCHAR2(2),
DATA_INCLUSAO TIMESTAMP WITH TIME ZONE,
USUARIO_INCLUSAO VARCHAR2(50),
DATA_ALTERACAO TIMESTAMP WITH TIME ZONE,
USUARIO_ALTERACAO VARCHAR2(50)
)tablespace ldesk_data
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment