SQL*Plus: Release 9.0.1.0.1 - Production on Mon Sep 10 17:39:13 2007
For my VDB_OWNER schema
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Enter password: ********
Conn...
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'm trying to launch oracle enterprise manager console and it prompt me an error:
Failed to parse tnsname.ora file
Oracle.net.config.servicesaliasexception:TNS-04404 no error caused b...
Hi Experts,
I am unable to start the Oracle 9i agent. I am not sure if it's because the server name has been changed. How can I find out the cause and remedy this problem?
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 need to do a bulk load into Oracle 9i DB.
Would you please advice the easiest and most efficient way or/and give a reference for complete, detailed step-by-step instructions. I ass...
Hello I'm using Oracle 9i .
Do u have any idea how can I reduce buffer gets except from using bigger block_size
Thank you
oracle 9.2.0.7.0
HP-UX machine
i want to take a schema export from production server and import into a different unix server.
1)how to use pipes to export and import this dump?as the d...
How to check table whether value exists or not from a flat file containing two columns(file containing data), if values not exists i want to write to a file stating that value does not exists?...
Hi,
I have a question related to .BAT (batch) file processing.
I need to execute several commands (like isql and sqlldr) in a batch.
Does DOS (MS Windows XP) have a possibility to ver...
Hey Frnz..
I am trying to compile a procedure by command ALTER PROCEDURE MY_PROC COMPILE;
But everytime i do this, get the below error.
ORA-04021: timeout occurred while waiting to lock obj...
Hi Experts,
I have a CUSTOMER_MASTER table in Oracle (9i) which contains the following fields:
CUST_CODE (varchar2(20))
CUST_NAME (varchar2(50))
BIRTH_DATE (Date)
SEX (varchar(1))
...
Hi all,
How to actually monitor Oracle tablespaces? Could anyone explain or point me at some useful links, which answers the following,
1. How to diagnose the actual free space ...
select test1, test2, test3 from testtable;
test1 test2 test3
---------- -------- ---------
today is Monday
ye...
Well, I finally need to bite the bullet and upgrade my clients from 8i to 10g. Is there anyone that can give me some tips as to what problems I may run across?
Any recommendations on migrating a DB2 v8 database on AIX to Oracle 10g or 9i on HP-UX? It looks like the Oracle Migration Workbench only supports up to DB2 v7 on Windows. Is there a plugin av...
I need some help for connect a ORACLE Database (version 9i) using ODBC. I get some connection strings for testing a program which connects to a ORACLE Database for update some tables in 2 diff...
Query output are like this (in TOAD)
1.select current_timestamp from dual
8/13/2007 7:59:02.549200 PM +05:30
In java
I update the timestamp datatype through java application prepared sta...
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 ...
With the following code, Identify gaps in data
Data Given:
RecordID BeginDate EndDate Type
1 1/1/1900 3/3/2003 ...
I have two arrays arrA,arrB with strings. Is there a efficient way to find out if any one element of arrA is
member of arrB using Javascript methods(for all browsers)
Hello!
I have a server which runs Oracle 9i with alot of data in a database. I want to install Oracle 10g in another server (and I installed), then I want to get a full dump (backup) from O...
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...
How will I recover the following:
Oracle 9.2.0.5 database.
Backup steps..
1. Alter system switch logfile;
2. ALTER DATABASE BACKUP CONTROLFILE TO $ctrlbck'
3. All tablespaces but in...
Are rebuilding and recreating(drop and create) of Indexes different? I have seen that recreating the indexes at times gived a performance improvement. Why is it so? On a related topic I see th...
