If you have two schemas in oracle "Schema1" and "Schema2"
Schema 1 has several tables A and B etc and some procedures/packages
Schema 2 has several tables E anf F etc and some procedures/packages...
http://www.experts-exchange.com/Database/Oracle/9.x/Q_22931062.html
In Oracle pl/sql how can i get a delete from statement to tell me how many rows deleted without using a cursor ?
thanks for help
http://www.experts-exchange.com/Database/Oracle/Q_23018242.html
I'm seeking an Oracle/PLSQL function that will return the value between parenthesis in a string.
Input Example: "nine (9)"
Desired Output Example: "9"
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23053284.html
I am using Oracle PL/SQL 10. I would like to join several tables together, but the field that I join on is dependent on the values in one of the tables. I was trying to insert a case statement in...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23064095.html
I have an Oracle 10 database and am using PL/SQL. I am trying to write a package that contains the following if statement:
If not fFinished and argLocation in ('PP', 'IL') then
if ar...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23067120.html
I created a trigger on an Oracle 8 table that displays an error message (raise_application_error) when a certain criteria is matched.
The trigger is working ok if the data is updated from within S...
http://www.experts-exchange.com/Database/Oracle/8.x/Q_23083438.html
I currently use a stored procedure with 4 input parameters and 1 output cursor to provide data to crystal reports. I can't summarise the data the way I need to in Crystal and would like to perform ...
http://www.experts-exchange.com/Database/Oracle/Q_23100486.html
Zones:
OracleDate Answered: 02/20/2008 Grade: A Views: 0
I want to retrieve data for 4 fields along with column name from Oracle table and create XML file. I use oracle 9i. How do I do that in PL/SQL procedure? A sample code would be appriciated.
Tabl...
http://www.experts-exchange.com/Database/Oracle/9.x/Q_23107960.html
I have the following problem. I need to join to two tables but the datatype in one table is Varchar(17) and number in the other. When I attempt the following query and error is returned saying inva...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23171899.html
I have an Oracle9i Release 9.2.0.8.0 built package (see code snippet for sample code)
I can easily build the string of the package and function/procedure I want to call. I just want to be able ...
http://www.experts-exchange.com/Database/Oracle/9.x/Q_23204782.html
