Search results for query: *

Hi All, Does anyone know how to test to see if a linked server really exists? Not that the link exists, rather that the actual server can be reached over the network. For example, if I execute the following query: select count(*) from server99.testdb.dbo.user_accounts I am returned the...

I have had a similar experience and solved it by completely redoing my control file - it was as if there was a blank or strange character embedded in the file that was causing SQLLoader to gag. You probably do want to use the TRAILING NULLCOLS parm if the last column indeed could be NULL. Good...

Your pretty much stuck with DTS or BCP (Bulk Copy Program) for loading data. If your data file format is consistent, BCP is quick and easy to use, although you don't have the capabilities that DTS has (e.g. constructs to clean or change data during the load process). From QA, you can always...

I posted this in the Enterprise tools forum, but I thought I'd try here too. Does anyone know how to install Dev2k (Forms 4.5) on a PC that already has an oracle home that was created by having Oracle 8i client tools installed on the machine previously? The new Universal installer doesn't...

Does anyone know how to install Dev2k (Forms 4.5) on a PC that already has an oracle home that was created by having Oracle 8i client tools installed on the machine previously? The new Universal installer doesn't recognize the old product file format, so I can't use that one and I'm having...

Jim's right, as long as your LONG column contains less than 32k of information, you could select the LONG column in to a VARCHAR2 variable (of 32767 length) in PL/SQL and then perform an INSTR function on the VARCHAR2 column, searching for your to_char(NUMBER) column value. Nasty problem...

There is no way to directly associate the sequence with your column, nor is there a perfect black-box way of solving your problem. One thing to consider... If you need to get that primary key value for additional/subsequent processing, popping the nextval in a trigger or directly inside the...

This is a common dilema. Most often, I would recommend storing date and time in separate columns as you have done. To further ease your burden, I would suggest storing the time in a varchar2(8) column in the format of HH:MI:SS if possible. If not, you just have to be aware of how te get data...