Home » SQL & PL/SQL » SQL & PL/SQL » Get DDL for advanced queus
Get DDL for advanced queus [message #260632] Mon, 20 August 2007 09:25 Go to next message
fernholm
Messages: 1
Registered: August 2007
Location: Sweden
Junior Member
Hi!

I hope someone can help me with this question. I want to get DDL for advanced ques on already existing ques. Thought I could used the package dbms_metatdata.get_ddl, but I can not found anyway to used this package to be used on queues.

Regards ///Ulf Fernholm
Re: Get DDL for advanced queus [message #262524 is a reply to message #260632] Mon, 27 August 2007 06:30 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
I don't know whether you can do it directly, but there are dictionary views that can offer the basic information about queues:
- USER_QUEUES
- USER_QUEUE_TABLES

Perhaps you can start from there.

MHE
Previous Topic: Getting consecutive records satisfying a specific conditions
Next Topic: Query To retrieve latest record
Goto Forum:
  


Current Time: Fri Dec 02 23:14:41 CST 2016

Total time taken to generate the page: 0.06285 seconds