I have an optional parameter in my sql query. How do i code the "where" statement in the query to (1) when the optional parameter is filled in to use it, and when its blank or null pull "ev...
I have two tables -
Emp (id NN, ename NN, b-date, d#, salary, super-id)
p-key (id),
f-key (d#) references Dept,
f-key (super-id) references Emp.
Dept (d-num NN, dname NN)
p-key (...
using oracle 10G
in a package I have two procedures that over load each other, they are declared as
Procedure FX (var1 in varchar2, var2 in varchar2)
Procedure FX (var1 in clob,var2 in var...
Hello I have the following code and it keeps on throwing an error on the line where I declare the customer exception(line 6).
Any ideas what I'm doing wrong?
Hi,
There is an existing oracle 6i report and it fetches data from a long column where some of the rows have more than 4000 characters. I have created a plsql formula column based on this l...
I need help, I need a procedure that you pass in the first name, last name address and phone number and then rerutn the member id or if it doesn't exist create a new member ID
I hve two tables, tbl_Call and tbl_CllAudio, the call table has a field called CallID, if the call has a recording file then a row in the CallAudio table will exist with the same CallID.
I ...
I'm trying to update a column in one table to a constant, where certain criteria are met in another table.
UPDATE TABLE2
SET TABLE2.FIELD2= 'HOT'
WHERE TABLE1.FIELD1 = TABLE2.FIELD1 A...
Hi I have a trigger that someone else created and I am wondering if it includes inserts made on that table. the beginning of the text in the trigger is in the code section:
I just want to k...
I have created the following test stored procedure
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER procedure dbo.customer2
as
select
company,
contact
from customer for xml...
In my program there is an update statement that updates my_vw.
my_vw is a complex view, is this updatable?
My program appears to hang when it tries to update my_vw
*******************...
I have a number coming into my procedure. There are two pieces of logic that need to be run depending on whether the number coming is in an integer or whether it has decimal.
How can I dete...
I have the following procedure that inserts a parameter p_paramA of type sys_refcursor into a table.
The procedure is as under and works fine:
*********************************************...
sql 2000 query results needs to be exported to xml file from query anlayser.
what is the best way to do this.
Hey;
I have a table to hold user account information:
resource_ID,owner_id
A, u01
B, u01
A, u02
C, u02
D,u03
Technically, everyone should have A resource, however someone got mis...
Hey;
I have the following tables:
username, responsibility
u1, business analyst
u2, DIV
u2, Accountant
u2, Maintenance
u3, DIV
u3, business analyst
I want to get th following re...
Hi I am trying to create a query which count how many students have a avg score value of 0.
Student ID Month Score
21 Jan-09 45
23 Feb-09 88
21 ...
Hi
can someone help with this error?
SQL> Alter procedure P_REVISION_TITLE compile;
Warning: Procedure altered with compilation errors.
SQL> Show errors procedure P_REVISION_TITLE;...
Hi There,
I am trying to find the date of a monday prior to a given date in oracle eg. given date is 13-Nov-09 it should then return 09-Nov-09?
Any ideas please?
Okay, I have two tables -
Shpmnt (Snum, Order_num, sdate, emp_id)
ShContnt (Snum, inum, qshipped)
I'm trying to display all the employees (emp_id) who have shipped a certain item (inu...
Hi All,
This is building on my previous post http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_24894965.html
where I have now have a procedure with something similar to:
execu...
My company automatically records times that employees work on various jobs for billing purposes. I have been asked to compile this information to assist with payroll. However, I need to firs...
I want to load test a program that contains merge statements and a loop containing update statements.
Oracle has managed to merge 1504853 or 1.5 million rows in Elapsed: 00:00:46.15, which ...
H All,
I'm doing a merge update/insert but want to verify that a condition doesn't exist before doing so i.e. the number of rows does not exceed a number e.g. 1000
so -
If the number of...
HI ,
I am getting an error when running a cold fusion app. The error is "The value "" cannot be converted to a number". I have put the select statement below. Can someone help me alter ...
