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...
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...
I have a databses wit specific collation, I want to change collation to another collation name.
How can I achive that ?
Thanks,
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 mysql database and have a datetime type column called mydt
How can I check the current date is larger then the mydatetime??
How can I get the current datetime??
e.g.
Today dat...
in insert statement how do i append a carriage return to a field. (at the end)
Hi,
Following is the procedure I am talking abt.
It ran suceefully before 2 weeks.I wonder what happened?
******************PROCEDURE create_user2*************
CREATE OR REPLACE procedur...
Dear experts
How do i run a sql file in oracle?
example test.sql exists in c:\blah\blah\test.sql
how do i say in sqlplus or command prompt for oracle to run
@test.sql..
how do ...
Hi,
I've got the need to select everything from table1 and only 1 row from table2. Table2 can hold any number of rows from 0 to 10,000
I've tried the following with no joy. Any ideas?
...
Tried to deploy report to page on website and got the following error.
TITLE: Microsoft Semantic Model Designer
------------------------------
A connection could not be made to the ...
We are using Oracle 8.17 and I am trying to load data into a oracle table. Data starts going into the table and then when a commit point reached -logical record count 13077. There should be ...
Hi,
What is the easiest way to read and manipulate an HSQL database directly? Is there a tool I could use?
Thanks.
Description of Weak and Strong Entities.
HI,
At present my SQL Server table has the following field as the Primary Key: mst_rec_nm
I would like a SQL script to re-assign the Primary Key to this field: rtns_prm_key
thanks a lot...
I have a client who has installed my software on a 64-bit box, making database connection to a 64-bit Ms SqlServer 2005.
My software's default connection string is like:
DSN=mySystemD...
I am sure there is a simple fix for this but I can't find it. I can make a connection to mysql using mysql -u root -p without a problem and I can use mysql -h local -u root without a problem,...
I am searching to find like items, for instance Bath tub, Bath tub jetted, Bath tub white.
I use this sql to find like items:
sql = "SELECT DISTINCT ContractItems.txtItemDescription " & _...
Hi ,
I had wirte a code to connect remote oracle server but i cant connect its says ORA-12514 error can u tell what is that error and how to slove that !!
Error Is
java.sql.SQLExce...
Hello,
I have a table which contains more than 200,000 records. Out of this i wish to conditional delete some records, the quantum of this records is around 70,000.
Once the records are ...
Hi Experts,
I have old window 2000 advanced server with SQL 2000 Server. I want to move SQL database to new window 2003 server and new SQL 2000 Server. What is the effect can be occur when ...
I have three systems 1 Windows 2000 and the other 2 running Linux. The ORACLE server is a LINUX server 192.168.1.220 (MDLITTLE). The other Linux system is a client that boot from a CD that i...
Hi everyone,
Platform: Windows XP Professional + SP1a, Office XP Professional + SP2, SQL Server 2000 + SP3a, Microsoft Excel 2002.
I am experiencing a bit of difficulty with some dates i...
Platform:
W2K SP3
Oracle 8.16
9iAS 1.0.2.2.2a (Apache web server in https, forms / reports server 6i)
Problem:
I keep getting that error listed above, which says: Your connection to...
Folks
I am having trouble using BCP to write to a text file... as discribed in the article I tried
bcp "SELECT * FROM pubs..authors" queryout authors.txt -U garth -P pw -c
in the Comma...
hello guys,
is it possible for me to delete or rename the column name in the table (oracle 8i). if that possible, can anyone give the idea on how to do it.
TQ
