I,
I have written this simple SP to pass one value to the SP and return three values.
The procedure is as below:
create or replace procedure get_count_of_dnis1
(
dnis_in_out in out varc...
Does anybody know a way of setting up a batch job to compile Oracle Forms.
My idea is to write a scrpot that allows to 1) compile the latest release version from PVCS VM and 2) copy to produc...
Hello Experts, I am creating a SQL query in Crystal Reports to run against a Sybase db. My select statement is
SELECT
ad.line1
case
when en.firm is not NULL then en.firm
else e...
We basically need to create HS connectivity from Oracle 11G database to SQLServer, For this I have installed Data Direct ODBC 64 bit connectivity:
But when I try to run the following query ...
Hello!
I am having a problem creating an MS ACCESS query that will look through a field in my data table and find all records containing a certain map page.
Can you help me create a sele...
How to change the increment value of an identity column. Current values for seed and increment is 1,1. Need to change this value to 1000,10.
How can I insert PDF file into DB2 BLOB field using PHP and SQL?
I have two tables "Contracts" and "BinNumbers" . Table "BinNumbers" contains one field "BinNumbers" There are 20 records with numbers 1-20. Table "Contracts" contains 2 fields "Status...
Does someone know some good alternative of MS Access database? For personal use, relatively small records quantity, up to 10.000 For example, music collections catalog, etc
Free, compact siz...
Hi,
What is the equivalent of 'COLLATE' in Oracle 91 ? Does oracle need it ?
I am trying to migrate some sqlserver scripts into oracle.
create table [Stats] (
[id] [int] not null,
...
Hi
I've seen examples of this all over the place, but i can't seem to get it to work for me.
I'm using oracle 8.1.7 on (i think a solaris machine)
with my 8i client and apache on Red Hat ...
I have a table that is generated with Dynamic SQL. The columns of the table are built depending on data that is inserted to a table.
I have a stored procedure that pulls data from this tab...
I could't find any explaination about this error message from Oracle8 help file. Normally we will get 5 digits number but this is 6 digits number.. and start with number 3.. emm..
I got thi...
Description of Weak and Strong Entities.
Hello there,
I have downloaded ERwin,but i dont know how to call my database in it,to draw an er diagram for me. when i start erwin i get a connection manager dialog box. in there i choos...
I want to run an update query after a command is clicked on a form. This update query will update all dates to match another date field. What code would I put in to run an update query after...
That's an easy one, but I'm new to DB2 and I really just need write a quick query, so here it goes:
What's the "DB2 equivalent" for SQL Server's IsNull() and for DateAdd() ?
Definitions ...
Here are the two tables:
The first table is "Customer File"
ID Number First Name Last Name Account Balance
1 JOHN CARTER $0.00
2 CHRIS HARRI...
Hello everyone.
I'm a newbie here...so go easy on me. I have the following code in a .cmd file ( sdv.cmd ). I run it from a command prompt like this c:\sdv.cmd >h:\projects\sdv.txt. It r...
I have a problem in a client application which began occurring after an Oracle database installed Oracle 8.1.7. Once the software installation has completed, to configure the Oracle Net8 clie...
Hi,
I urgently need to calculate the number of business days in a given month. I realise that there are a number of submissions that calculate weekdays etc, but I specifically need to get the...
hi,
I am trying to create referential integrity between two tables. (One-To-Many Relationship)
One table has a primary key - DocID
The other table has the same field - DocID.
Both data t...
Is there a easy way to use the prompt output command with dates Eg, I need to get the following output instead of using DBMS
report for 01-JAN-2003 to 30-JAN-2003.
I need to get this on ...
Hello everyone
I have a query that has a where clause and in my where clause I am using
WHERE DATEPART(mm, [CreateDate]) = DATEPART(mm, '8/01/2007)
AND DATEPART(yyyy, [CreateDate]) = DATEP...
This questions extends previous one re SQL Update Statement in SQL Server 2000. I have managed to replace apostrophe with ’ (due to XHTML!!). The previous field was nvarchar so arguments...
