Search results for query: *

Thank you Mufasa, That is what I had thought and just wanted confirmation on it since a "customer" was telling me it could be done. Thanks again for your time.

Hi, Is it possible to take a hot backup that was done on a Unix server and restore it to a Windows server? If it can, does anyone have any links or advice on how to proceed? Thanks for you time.

I couldn't agree with you more about "sequences" it would make things much easier. The database was created before I arrived, so I had no input during its creation. However, I have tried to convice the "higher ups" about the benifits of using sequences, but they don't want to make the change yet.

Sorry, I should have been more specific. I get the following - Warning: Procedure created with compilation errors.

Hi All, I am working with a database that uses a store procedure that calls a function in order to retrieve a "next id". I've been asked to combined the two by putting the logic of the function into the store procedure. After looking many different places on Tek-Tips and the Internet, I can't...

Hi All, I'm hoping that someone will be able to help me out or atleast point me in the right direction. I'm trying to use the If Update() in my trigger, my question is - can the value(column) that is placed in the parens be added "on-the-fly". The code below shows what I'm trying to do, but a...

Outstanding!!! It worked great, I think I was trying to make it harder than it actually was. Thanks again.

Hi All, I sure hope someone will be able to help me with this issue, first a little background. I work for a software company and the programmer that used to write the database scripts did not use a standardard naming convention for the foreign key constraints, they changed from one verstion to...