I can use all_arguments and all_procedures to list the procedures and functions inside any given package and with DBMS_METADATA I can extract the DDL for that package. Is there an easy way (other than
I would be grateful for a quick sanity check! When calling Oracle 开发者_开发百科Reports 10g from Oracle Forms 10g, is it possible to run an Oracle Report and save it on the users PC to a specified
We have recently migrated O开发者_C百科racle 6i forms with a native runtime to 10g to work with web and java. It works but with huge performance problems. For example, in the server which is running r
I am designing a new report using oracle reports builder that comes with 10g. I have many columns to be inserted horizontally. But I couldn\'t increase the page width of the body section beyond 8.5 in
I\'m using the Oracle.DataAccess.Client data provider client. I am having trouble constructing a new instance of an OracleException object, but it keeps telling me that there are no public constructor
I have an Oracle 10.2.0.3 database, and a query like this: select count(a.id) from LARGE_PARTITIONED_TABLE a
All, I have the following Package Description: CREATE OR REPLACE PACKAGE ashish.PKG_Customer AUTHID CURRENT_USER AS
I am trying to update a table, but I can\'t get my syntax to work. I added new elements from a temp table to my element table and I want to update column_name in metadata_attribute and table_name in m
I have a very simple XML document that is sto开发者_运维技巧red as a VARCHAR2 in an Oracle 10g table.Below is an example of the XML.I want to take the XML and insert it into a global temp table as a s
I have firstName, lastName and fullName columns in oracle. I want to be able to create a trigger that updates the fullName column with the firstName and lastName values when they are either updated or
加载中,请稍侯......