I have a variable defined as define dbs \'&1\' Suppose I pass database1 as an argument. Then the statement is int开发者_如何学运维erpreted as
I am trying to run this code below using Execute Immediate but its not working andvalues are correct.
i really need a basic hibernate implementation calls oracle plsql function. it must include configurations, dao and test class.
I have 2 procedures (A,B) in Oracle 9i. In individual, they all work fine. But I cannot make a procedure C that calls A, which in turn calls B. I put a dbms_output.put_line before C calls A, before A
Is there a PL/SQL function or general technique to quote unqualified identifiers (e.g., mytable) for use in a dynamically constructed SQL query?How about partially or fully qualified identifiers (a.b@
I\'m debugging a procedure which ... returns certain values. The procedure seems to use DBMS_SQL.DESCRIBE_COLUMNS2 which was, till now unknown to me.
开发者_如何学GoHow can I update an Apex Tabular Form with pl/sql instead of using a multi-row update(MRU), is it even possible?
Ok, I have a complex recursion problem. I want to get a dependecy installation sequence of all of my objcts (all_objects table) in my Oracle 11g database.
I would like to w开发者_Go百科rite a PLSQL function that returns true if the domain name I pass is valid.
As the title suggests, I would like to know if it is possible to join the string in a select statement within a PL/SQL procedure.
加载中,请稍侯......