eventual partnership tables

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Tue, 28 Aug 2007 11:02 am

I am beginner in oracle so I'vê been reading some stuff on the internet about eventual partnership tables, but I couldn't find a place to explain clearly and simple as I do to create this type of table.
because I have a progam that runs perfectly with eventual partnership tables in informix, and needed to migrate the progam for oracle.
can someone help me?
afffernando
Location: hortolandia - SP

Poston Tue, 28 Aug 2007 1:03 pm

Brother, here is an example:
Code: Select all

CREATE GLOBAL TEMPORARY TABLE tb_teste_1 (col1 NUMBER,
                                        col2 VARCHAR2(100))
ON COMMIT DELETE ROWS;
there are two options: ON COMMIT DELETE ROWS or ON COMMIT PRESERVE ROWS (does not eliminate the rows).

Then just use any way you see fit.
Trevisolli
Location: Araraquara - SP

Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP



Return to SQL

Who is online

Users browsing this forum: No registered users and 2 guests