| create table [message #456017] |
Fri, 14 May 2010 01:45  |
lokeshsurana
Messages: 212
Registered: April 2010
Location: India
|
Senior Member |
|
|
I want to create report on two dummy table which are creating run time of report
from two base tables...i want to create new table having some specific columns of master table in running process of report
Is that possible to create table in running process of report by using trigger,function or procedure...........
|
|
|
|
| Re: create table [message #456020 is a reply to message #456017] |
Fri, 14 May 2010 02:06  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Yes, it is possible to create a table from a report. You'd use SRW.DO_SQL built-in (check Report Online Help system for more information).
However, this might not be the best idea (creating tables around). Why do you think you should do that? You said that you'd create a new table, which would contain certain columns from two existing tables. If that's the case, perhaps you could use a view instead.
If you need to do inserts or updates, then consider using a global temporary table or even an "ordinary" table that'd be deleted - inserted - updated.
Just try to avoid creating tables in runtime. Oracle *usually* doesn't need that.
[Updated on: Fri, 14 May 2010 02:07] Report message to a moderator |
|
|
|
| Re: create table [message #456023 is a reply to message #456020] |
Fri, 14 May 2010 02:10 |
lokeshsurana
Messages: 212
Registered: April 2010
Location: India
|
Senior Member |
|
|
i want create table run time because by two master table are too large and from that i need just two field information from two diffrenet master tables
so i think create dump table run time then create report and delete those dump table in end form trigger
Is my think....in performance grade view also
|
|
|
|
| Re: create table [message #456024 is a reply to message #456023] |
Fri, 14 May 2010 02:13 |
|
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Wrong approach, I'd say.
Two large tables that are supposed to be "shrunk" into a smaller one is useless because you'd still have to process "large amount of data" (i.e. select from those tables and insert into a new one). Report would have to
1) fill a new table
2) fetch data from a new table
Why? Why wouldn't you rather use INSERT INTO NEW_TABLE code in report's query and directly create report output?
In my opinion, you shouldn't do that.
[Updated on: Fri, 14 May 2010 02:14] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
