folks,how do i load a csv file into oracle
i e fields id and description from table a
'1111','car'
all help will do(an example will be great)
r
Hi ,
I got a execution plan of a query using explain plan and when i analyzed it, there are two Full table scans on two most important tables in the query. I looked at these two tables...
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
System: Microsoft Windows Serv...
Is there a way to define an Oracle RPC in VS 2005 C# the way you would in PowerBuilder? I have an Oracle package procedure I need to fire with the client entering the parameters themselves. I ...
I want to find out what the NLS_DATE_FORMAT is set to in Oracle
Hello
I want to be able to create a conditional join between two tables - e.g.
(bit pseudo codeish!).........
select
t1.name,
phil.test
from table1 t1
innner join (select case when...
Hi,
i tried to use a stored procedure,for truncating tables.
but it throws exceptions
-----------------------------------------------------------------------------
4/10 PLS-00103: En...
Schedule an SQL query to produce a daily report
I would like to create an oracle job to execute a query daily at specified time except on Sundays.
The sql script (prat_daily.sql) resides in...
RMAN backup Failure. Oracle database version 9.2.0.8.0.
Its very urgent and so i am opting for maximum points.Please suggest complete steps 1 by one to solve this.Thanks for your help.
err...
Below is an update statement:
UPDATE PS_JRNL_LN SET BUDGET_LINE_STATUS = 'V' , PROCESS_INSTANCE = 16813030 WHERE EXISTS
( SELECT 'X' FROM PS_KK_SOURCE_HDR KKSH , PS_JRNL_HEADER HDR
WHERE ...
Hi i got a mail from DBA's like below:
Due to audit requirements we are working on implementing a lock-down of our Oracle environment.
To accomplish this task, while still allowing select ...
How to rename a column name in ORACLE 9i
Here's the script:
update t1
set t1.descr = t2.descr
from tax_juris_mstr t1
inner join taxjuris t2
on t1.juris_id = t2.juris_id
The 00933 error is referring to the 'from' line. Wh...
Hi,
I am writing a function in Oracle 9i to send an email and so using a variable of XMLTYPE.
Assuming variable name being emailText, the statement
utl_smtp.write_data(mail_conn,emailTex...
I have a .SQL text file with basic SQL commands in it that I need executed by oracle. I know there are tons of better ways to do this, but for now I just want oracle to execute the script. I...
Hi! I need to perform an update on a table that contains around 10.000.000 of record.
What I have to do is write an sql script that performs this operation, using a rownum, to perform commit...
Thanks to provide a HOWTO on how to upgrade from Oracle 9.2.0.1 client to Oracle 9.2.0.8 client.
I have two tables, parent/child (1-m). I need to track all changes made to either table and maintain the relationships at the same time so I can capture an audit trail and also a snapshot at a...
Can anyone help me with databinding to a text box using an oracle datareader in C# Visual Studio .NET 2005? The query statement and datareader work fine but when I debug and get to this line:
...
Hi,
I want to pass two parameters (a choice from a list, and a text box value) from a .jsp as IN parameters to an Oracle Stored Procedure. The procedure is quite complex so I must use this ap...
Hi,
I have a PL/SQL codes which will get a number of records as parameter to a function.
My codes look like below
for k in (select * from emp where emp_no=t_emp_no ) loop
select get...
When trying to upgrade using a response file instead of GUI, there is an ORACLE_HOME_NAME that needs to be supplied. The GUI would figure it out and present it to me, but there is no display ...
We have recently done a server migration. When we try to print a specific report, not all reports. We get the error message:
ORA-12705: invalid or unknown NLS parameter value specified
A...
How can i alter the configuration of the Oracle's ArchiveLog to reduce the size of the files, or better, reduce the time of the restore on-line? Our DB is a DataWareHouse, then every day all b...
Hi, we have two databases db817 (8.1.7) and db9i (9i)
db817 has user dbs and dblink db9ilink that connects to db9i
db9i has schema emp and table employees in it.
How can I grant sele...
