مرحبــا ...

ممكن تعلوني طريقة اعداد بروسيجر يحتوي على temp table و يدخل بيانات من select statment from many table ??

ابيها ضوروري

دمتم سالمين

يعني محد يعرف كيف يعملها ؟؟ طيب اي مثال لاني دورت كثير و مالقيت اي شي (!_!)

Hi there
You can create the temp tables as follows
CREATE GLOBAL TEMPORARY TABLE MIG2.MY_TEMP
(
id NUMBER,
DESC VARCHAR2(150)
)
ON COMMIT DELETE ROWS
NOCACHE;


and after you create it, it becom an object on the database, that one of its property on commit will delete all data in it, or when the session ends it will also delete the data, and its session dependant, means that defferent sessions cant share that data wich is stored in the temp table,
how to use it?
it can be used as any other table select from it, insert to it, delete from it, and also create index on columns on it
such as

insert into my_temp
select eno,ename from scott.emp;

delete from my_temp where eno = 10
update my_temp
set sal= 1000
where eno = 10;

i hope this will answer youre question