I have quite a few lines of PL/SQL code in Oracle 10g, and we are going to move to 11g. I expect my code to work there too, but:
Why can\'t we us开发者_JS百科e :new and :old columns in a statement level trigger?Because it might be the case that the statement is inserting/deleting/updating more than one row. So there is no new o
I\'m getting some strange behaviour from an Oracle instance I\'m working on. This is 11gR1 on Itanium, no RAC, nothing fancy. Ultimately I\'m moving data from one Oracle instance to another in a data
I want to be able to insert a variable number of rows into a table based on user inp开发者_运维知识库ut? eg.
We are having some major performance issues with SELECT queries out one of our databases.Please see the simple procedure and associated code below.
I\'ve defined VARRAY of a user-defined type such as this : CREATE OR REPLACE TYPE TEST_TAS OBJECT (C1 VARCHAR2(20 BYTE), C2 VARCHAR2 (11 Byte));
I need to create a table with the following structure: calendar week; week start date; week end date which contains all weeks beginning in 2007 until the current week.
As part of a release we run a load of PL/SQL scripts against a database. Recently someone left the ; off the end of a line in one script that was called another script so this meant that script did no
On my website I have a .php script to which our customers can post orders. $destname = CreateUniqueOrderFileName();
I am trying to put together an XML document from several pieces. To get the data, I had several queries whose results were XMLTypes.
加载中,请稍侯......