Hi,
In a single procedure I am getting results from a cursor and using this information to schedule jobs but not enable them. Later in the same procedure, if all goes well, I want to enable...
How do I create Tablespec in Oracle 9i
Hi,
I have tried to use the following code snippet
select nvl(length(TRIM(TRANSLATE('111', 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', ' '))),0) from dual
but for...
I've written an Oracle (9.2) stored procedure that runs a query on 2 different databases and returns records that are present in A, but missing from B. I'm currently returning this result set ...
I am new to oracle, and I wanted to know how to initialize a bind variable. I tried doing the example below but I keep getting an error at line exec :basic_percent := 45; Once I remove the ...
see below for code
if i define a table type, and then use bulk collect to fill it with records, i can then use the table() function to use that collection in a sql statement. the code below...
I currently use Oracle web application server. A DAD is Oracle web server's Data Access Descriptor
that is set up in the above web application server. I am using pl/sql web toolkit in the rem...
This select works:
select status from dba_objects
where owner='BLADELOGIC' and object_name='COMPLIANCE_RULE_ID_GEN';
STATUS
-------
VALID
This function:
CREATE OR REPLACE function...
hi, I have a question about pipe Row function.
I define an obejct type:
CREATE OR REPLACE TYPE myformat AS OBJECT
(
A CHAR(1),
B CHAR(3),
C CHAR(3),
D CHAR(3)
...
Hi,
How can we handle column alias names 2 words in dynamic sql. For example:
Regular sql:
SELECT ORG_ID AS "ORGANIZATION ID" FROM x;
Dynamic sql in the following block giving error.
...
I am working on a database migration project from SQL Server 2000 to Oracle 10g. I use a tool to convert the SQL Server tables to Oracle 10g tables. However, I also have to convert T-SQL scrip...
The current solution I have:
sqlplus -s /nolog <<EOF 1> sdwh_sc.results
connect UIDr/PWORD@db1
set serveroutput on
@sdwh_sc.sql
EOF
sqlplus -s /nolog <<EOF 1> dm_sc.results
connect UID/...
I used ADO in python to open a very large table in Oracle (about 1600000 records, observed using TOAD). However, the ADO record set only return 419926 records in my experiments. Following is a...
I need to copy a table structure using SQL Tools and create a procedure to do it.
and add a column to it as well.
Thanks
Hi,
Today I am asked to load data from an XML document into a data base table using a PL/SQL program. I don't know even the basics of XML to start with but the requirement is urgent.
I reque...
Hi,
Today I am tring to Write a procedure that will take Department ID as a parameter and calculate the number of employees who make less than 1000 and the number of employees who make more t...
I have 2 queries. There are total 2 regions, region1,region2. But now I have a new region3
and I would like to exclude region3 from the select.
These are the original queries:
FOR r IN...
Dear all
I have one detail table in oracle for Purchase order ie( hdr_id,id, item, description, unit,qty,amount). hdr_id is the foreign key. i need a trigger to update id column serially star...
Hi,
I tried to use this java external procedure for ziping the files by passing the commands.
The input I have passed to the code is 'zip D:\testing\zip\test.zip D:\testing\zip\*.txt.T...
I have a query listed below:
1.
select priority_level, ID from product order by priority_level, ID DESC
The result will be:
priority_level ID
9 20086750
93 ...
I would like help writing some PL/SQL code to populate a combo box. Here is the combo box code, how might I integrate the query results into it?
<form id="form1" name="form1" method="post"...
I have a table called performance which has columns: d_date, id, time.
I need write a query where i can get all the dates for a particular month, say 04 and also for a particular id. The I...
Hello, what do I need to use if I want to close window and cancel changes I mabe to a data base block in Oracle Forms 6i? I use this block for accept values and this block is in the same form,...
CREATE OR REPLACE PROCEDURE Backup_All_Tables
AS
BEGIN
DECLARE
--c INTEGER :=0;
--d INTEGER :=0;
status_msg_out VARCHAR2(100);
proc_name VARCHAR2(32):='BACKUP_ALL_TABLES';
mesg ...
Hi Experts,
I have a procedure that runs weekly, when it runs it gathers some information or statistics into another table by date (month) and department, so say the first time it runs in Aug...
