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 " & _...
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...
Hi,
i have two oracle 9i servers one @ datacenter which is live 2nd @ office for development I have already imported full database dump file @ office few weeks ago but now I want update wh...
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 ...
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
We have 2 databases. A live database that we copy every so often and restore into a test database. Every time we restore the database onto the test database (on a different server) a couple ...
I have an Excel sheet looks like this:
PartID MinQty MaxQty
Par1 10 20
Part2 15 20
Part3 20 30
I need to update this to database like:
PartID Warehous...
Is there a command so I can execute a entire Request Set trought a PL/SQL ?
I know about FND_REQUEST.SUBMIT_REQUEST but this command only execute a single concurrent.
Best Regards,
Pe...
I have a data source previously installed on one computer in our office that I need to copy to another computer. How do I copy the data source/driver/settings, either manually or using third-p...
I am trying to do an update query in SQL 2k that updates a name field and removes only the pattern of space middle initial space. I do not want it to strip out any additional names in the fiel...
O.k...
I have this issue.
I install an configure SQL Server 2000 and the service pack 4 for it.. on windows 2003 SP1 server computer.
I´m triyng to remotely connect by 1433 TCP port, b...
I am writing a program in Pro*C with embedded SQL commands. My program inputs data from a tab delimited text file, copies the values into the Pro*C variables and then inserts the values into a...
Any ideas how to get this fixed--urgent
Event ID: 17052
Error: 9002
Severity: 17
State: 2
The log file for database ' ' is full. Back up the transaction log for the database to free up ...
I need to update user information in a huge table. First name and last name columns have to be replaced by same length masked values. Which of the following ways is the most efficient solution...
Hi, I need a function that will calculate the fiscal year of a date field passed to it
i.e. GetFiscalYear(apptdate)
will return yyyy
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...
In Java, I've tried using the Date class, and Time class, but I can't insert it into a MySQL table as a DateTime.
I have a field in a MySQL table which is of a DateTime format. How do I use...
This error is very confusing. I wouldn't be surprised if someone can not answer this question. I am offering 500 points.
The problem is with the Informix ODBC Driver. We use Informix ODBC D...
I have just setup 2 NT 4.0 workstations on a small LAN. I am trying to execute a Delphi program(That is on the network) that accesses some Visual DBase databases... I get an error when it is...
It seems that office 2007 (excel 2007) can no longer save files to dbase. I had been using this facility to create the field headers for dbase files. Can you suggest some workarounds? A utilit...
I loaded the incorrect version of ODBC drives when attempting to re-install lost application. I installed version 2.573.9001.00 of "Microsoft for Oracle". I later discovered that I need to ins...
Hi experts:
I am creating a simple E-R diagram.
I would like to learn how to handle the following relationships:
instructors, department chairperson and student advisor.
What I hav...
whenever I try to
start MySQL service while using windows 2000 OS:
"System Error 1067 has occurred" Could not start the MySQL service on Local Computer.
I looked in the GUI of WinMySQLad...
Can anyone tell me why the following works:
SELECT m.value||'\'||'ORA'||ltrim(to_char(p.spid,'00000'))||'.trc'
FROM v$session s, v$process p, v$instance i, v$parameter m
WHERE m.name = '...
Every 4-5 days our Oracle (version 9.2) database is shutting down and we have to reboot the OS (Windows 2000 Server) to get the database working again. The database shuts down after 3-4 hours ...
