Home » Developer & Programmer » Reports & Discoverer » DDL Commands in Reports
DDL Commands in Reports [message #150347] Wed, 07 December 2005 08:16 Go to next message
kitab
Messages: 3
Registered: June 2005
Junior Member
Hi All,

Can we create table using oracle report? If yes, please provide details.

Thanks in advance.

Kitab
Re: DDL Commands in Reports [message #150357 is a reply to message #150347] Wed, 07 December 2005 09:10 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
I strongly advise against it! Reports is a reporting tool, keep it that way. Don't create tables on the fly.

But, sigh, I guess you could use a report trigger and use FORMS_DDL or a server side procedure.

But again: just don't.

If you need temporary tables, use GLOBAL TEMPORARY tables or PL/SQL tables or User Defined types...

MHE
Previous Topic: Concating two different group values
Next Topic: What is the fastest way to print an Oracle Report?
Goto Forum:
  


Current Time: Fri Nov 29 20:23:13 CST 2024