Search Result

Hi and thanks for checking out my post.
My problem is connecting to a remote oracle database from my unix machine. The remote database is on the network and I typicaly connect to it using an alias, username and password.

In the past I have connected to the database using sqldeveloper. The connection type is TNS and the network alias is abc123(for example)I also supply my username and password.

I have also connected...

Hiii,
I had written procedure which will display missing data from a table

...

Hi All,

I have a web application built using ASP.Net and communicates with a Web services which uses oracle rdb odbc driver to connect to RDB server, but after a while I started getting this error when executing simple statements like insert or update against the database:
Data : System.Collecti ons.ListDiction aryInternal
Source : SQRDB3.DLL
Message : ERROR [08S01] [Oracle][ODBC][Rdb] send() Ret -1 Err#10038 WSAENOTSOCK...

Hi,
When i tried to connect to ORACLE 10g through TOAD I am getting this error.

Can't initialize OCI. Error -1

Kindly provide me some suggestions to fix this error and access the database

I want to upload a text.txt file through oracle store procedure using utl_file package.

Sample
Open OS file
utl_file.fopen( filename)
Close OS file
utl_file.fclose

the text.txt content:

QRIFR6M Index,BID,0.787 5
QRIFR9M Index,BID,0.862 5
QRIFR1Y Index,BID,0.975
QRIFROVN Index,ASK,0.743 75
QRIFR1W Index,ASK,0.781 25
QRIFR1M Index,ASK,0.906 25

Its Urgent...

Does anyone know of an SQL statement that combines data directly from two different databases?

Hi,

I want to do something like this -

Get Wind_direction, Wind_speed, SiteCode, Latitude, Longitude side by side-

The problem is that (DataValue as wind_direction) Wind_direction and (DataValue as)wind_speed are under the same column DataValue and for Wind_direction variableID is 4 and for Wind_speed is 3

the schema can be found here (Fixed to show instead - NeoPa)

And here's the query...

I initially thought this had to do with Daylight savings time change, but now that it has passed in the US, I looked at the query and now I observed this behavior:

begin_time is my column and is assumed to be UTC+0.

This Yields 01:30
Okay, let's convert that to US/Eastern:

This Yeilds 20:30 (Makes sense, 01:30-5:00=20:30)...

I created an index for a table but the performance increased just a little.
What the problem is and how should I create the index?
The SQL cannot be changed and only an index is required to increase the performance.

The following is detailed enviorenment.
(1)DB: Oracle10.2.0.3
(2)SQL:
select * from
(SELECT col1,col2, col3, col4 FROM table1
where col0 = 140 AND
col2>=to_date(' 2011-08-30','YYYY-MM-DD')...

I've changed this drastically as I'd thought I'd posted a solution, but I was wrong. Now I'm looking for help!

I write Aceess 2003 front ends against an Oracle database using pass through queries (PTQ) instead of linked tables. I was modifying an application report I came upon Admin - 00 type tables that were mysteriously appearing in my table tab. These would appear whenever my code called upon some PTQs or when I ran those particular...

Hello,
I have a strange situation with something and maybe someone here can help me. I have a function in Oracle that returns a sequence number. When i try to get that value in C# by a parameter it always tells me that the parameter type is invalid. A sample value of that returned value is 115545. If indeed this error is correct then what is the correspondent in ODBCType for this value? If it isn't correct then what is the problem?
...

i want to get whick primary key act as forgein key in whick table by some joins by linking parent table with child and applying constraints;


this query gives me some info about forign keys with column ids but not linked with which primary keys of parent table ;

SELECT * FROM ALL_CONS_COLUMN S A JOIN ALL_CONSTRAINTS C ON A.CONSTRAINT_NA ME = C.CONSTRAINT_NA ME
WHERE C.TABLE_NAME = 'STUDENT_COURSE '
AND...

With regular decimal numbers you can just write them in. With hexadecimal I tried using 0x### but it didn't help.

Here's how i'm temporarily doing it:

flags field is a RAW data type.

silly right? Just to get a hex number?

There's got a better way. Care to share?

Thanks,



Dan

I want to write a query to get the interpolated result.

I have a table (which contains the gridded data - means lat, long, sst values for some points), the table contains around 100 million records.

I need to get a sst for my lat,long values (for these lat, long there is no exact match of records, so i need to take the result on interpolation based).

Please help me how to write the query to get the result...

Hi,

I have many Excel files (more than 200 files). I'm using TOAD to import the Excel files into the Oracle table, but this process is boring and time-consuming especially for this huge number of files.

So, I'd like to do a PHP code which takes the path of the Excel file and imports it automatically into the Oracle table without using TOAD or any other programs.

I'm using PHP OCI8 to handle Oracle queries....