I have a SQl code that goes like this -
DECLARE
V_AIDY_CODE FAISMGR.RORPOST.rorpost_aidy_code%TYPE := '&aidy_code'; -- Aid Year Code
V_CATEGORY FAISMGR.RORPOST.rorpost_category_code%TYPE...
I have a database where a query on one table results on many records being returned. How do I get the output into CSV format - e.g. "select foo,bar from sometable where foo = '123456789';" sho...
I create a block called "media_request_info". I create a view "xx_media_request_master_info_v" for its base table. When click on the button to open media_request_info form and try to edit data...
Hi Experts,
I have a series of sql scripts to be executed.
The question is Can we call a sql script from a PL/SQL procedure?
for e.g. here is the sample
CREATE OR REPLACE PROCEDURE callscr...
Hello,
I need to pass a string of numbers like "1,2,3" as a parameter to Oracle stored proc and be able to use it with a query like
CREATE OR REPLACE PROCEDURE(P_EMP in VARCHAR2) IS
se...
I've opened several connections to various dbs in toad. i was trying to write a pl/sql in an editor session opened on one oracle db connection and would like to incorporate data from an oracle...
Hi,
I am using Oracle SQL Developer 1.1.3 and I want to debug a Oracle package. I am unable to do this as I get the following error message...
Connecting to the database BAA.
Executing ...
select text from dba_views where view_name in ('....','...');
does not give me all the text.
How can I find the whole text and definition?
Thanks
Lets say I have two packages, each with one procedure (as a simplified example):
PACKAGE_1.PROCEDURE_A is a very long procedure with a bunch of steps. Mid-way through it calls PACKAGE_2.PR...
CREATE OR REPLACE PROCEDURE BILL_CUSTOM_LOAD(p_file_name VARCHAR)
AS
v_auditlog_string VARCHAR2(4000);
v_sysdate VARCHAR2(40);
v_session_user VARCHAR2(...
Hi,
I'm trying to create a database link to an Oracle 11g database. I execute tyhe CREATE DATABASE LINK command without error pointing the a database that is present in TNSNAMES.ORA.
On ...
I have a table in my oracle database and I want to spool the data into text files splitting it by a column eg
ORACLE SQL TABLE: my_orders
3 columns of data in table
USER MY_DATE QTY
...
We would develop sending mail function when our customer do the transaction .
Our pseud code is :
1) When customer do transaction , our trigger will insert one row into transaction table
2...
I am having a procedure (which was bascially copied from the pl/sql query generated from OEM(maintenance->Export to export files) when you want to export a schema)..
If i run the pl/sql as ...
hai !
the code segment is as follows:
DECLARE
x VARCHAR2 (20) := 'bull dog';
y VARCHAR2 (20);
BEGIN
y := CASE x
WHEN x 'cat%'
THEN 'good'
...
Hi,
I my requirement is to convert PL/SQL to MySQL and I never have touched MySQL.. where do I start and how hard is it.
To me Syntax is Syntax..
Any info to start is appreciated.
Bill
I'm trying to make my CTL file insert an "N/A" if it incounters a NULL or blank value. I need help.
If I have a procedure like the one below that has an exception on statement2, like table does not exist, how do I resume so the next line, statement3, is executed? I realize I could probably ...
Hello!
I need to dynamically load an image from local hard disk during the runtime of a report. I want to do it in a way to check first if exists the image and then load it! How could I do it...
I have databases in two locations.
in db 'A' I have a table called PEOPLE
in db 'B' I have a materialized view called PEOPLE which is selecting rows from PEOPLE@'A'
I added a column to t...
If I were have to measure the execution time for a query in PL/SQL
Do I need to set in
PL/SQL Beautifier Options -->SQL Window --> set <<Records Per Page>>= All ? or set Fixed = 100 will d...
i My report I want to display two different logos (GIF files), depending on the company.
My psuedo code is this:
If Company_1 then
display logo1.gif
else display logo2.gif
How do...
Just got oracle 9i installed after formatting my XP machine.
when I run below mentioned script in isqlplus it removes the + operator automatically and then gives error.
In another script in...
Hi,
I have created an Trigger which fires whenever a record is inserted into my table.
This trigger in turn calls a stored procedure in a package called 'GENMAINTENANCE.pkg_mch_queue'.
...
Hi Experts,
I am using Oracle PL/SQL Version 9I. I am trying to join 2 tables and select one other field. The problem is that the table values I am joining on aren't unique and the other ...
