Kindly, I have get and post ORDS web service, is there is a SQL script to extract all web service source code (DML) so I can extract and execute in another database?
I found this simple SQL but it's showing only the trigger procedure not the full code which I used when I create the web service (ex: enable_schema, define_module, define_template, define_handler and define_parameter)
SELECT NAME ,Uri_Prefix ,Uri_Template ,Method ,Source_Type ,SOURCE FROM User_Ords_Modules a ,User_Ords_Templates b ,User_Ords_Handlers c WHERE a.Id = b.Module_Id AND b.Id = c.Template_Id
SET long 5000
SET pagesize 1000