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...
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...
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 ...
Hi Experts,
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\\exceltest.xlsx" +
@";Extended Properties=""Excel 8.0;HDR=YES""";
Doesn't open office 2007 x...
Hello All,
I need to connect to a Sybase ASE 12.5.3 ESD2 Database in order to read data from a couple of tables. No one here is accessing these databases from .Net so I need some help. I tr...
I have a webpage that is executing updates to a SQL 2000 database.
From time to time I get the following error message when executing the updates on tables:
& was deadlocked on lock res...
Orion here onec again...
can u plze help me 2 solve this error
ORA-01810: format code appears twice
update MF_QA set OFFR_DUE_DT = to_date (to_char(OFFR_DUE_DT,'MM/DD/YYYY')||(substr(OF...
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...
ORA-19815 :WARNING :DB_RECOVERY_FILE_DEST_SIZE OF 2147483648 BYTES IS 100% USED AND HAS 0 REMAINING BYTES AVAILABLE.
ABOVE MESSAGE COME WHILE I TAKE HOT BACKUP.
PLS DO WRITE ME THE SOLUTI...
Hi Team,
I have a question regarding indexes.
Why do we required to drop index on prodcution database and recreate it again. I have seen somany times, guys are talking about droping in...
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...
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 am attempting to write an sql query to select the top 3 distinct scores from a table structured as follows:
ID Score User
1 10 5
2 ...
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...
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...
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...
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...
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...
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, I need a function that will calculate the fiscal year of a date field passed to it
i.e. GetFiscalYear(apptdate)
will return yyyy
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...
Is ity possible to stop and start a MS SQL 2000 Job from the Windows command line or in a batch file ?
Thanks,
Chris.
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...
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 = '...