After many Google and SO searches, I cannot find a definitive answer to this simple question: How can I define a procedure inside of another procedure to use?
I need help with clearing geometry cache. In my web application there is a need to clear cache after changing the geometry data in database. I\'m using maps with tile layers and for them i want cache
I have discovered recently that\'s possible to call anoymous blocks from jdbc like this: String plsql = \"BEGIN\" +
I\'m using the pl/sql htp package to create开发者_JS百科 simple web pages. Now I need to use different templates based on the device accessing the pages (Desktop Browser or Mobile Blackberry Client ).
I want to declare a cursor on a table that does not exist. Of course, my procedure doesnt compile. This table is a temporary table, and is created by a pre process. It will exist on runtime, but at c
Hi Required immediate response, I want to take dump of some selected tables from schema, can any body tell me is it possible?
i want to develop a procedure for following scenario. I have one source, one target and one error table.Target and Error tables have all fields that are present in source tables.But the data type of
what are the queries to do the following in Oracle? get names of all views which are present ? (Similar to select * from
I\'m curious to find out how people manage their packages in their applications. For example, in our development instance, an application developer may want a change to a stored procedure.However, ch
I\'d like to do the following in Oracle 10g (this is a contrived example to show the concepts, not real code)
加载中,请稍侯......