Search results for query: *

Hello everyone. I am brand new to mySQL, so I am not sure if this can be done. Is there a way to capture a schema. I am taking over a number of databases, and I'd like to get a better understanding of each database. Thanks in advance.

Works great. Thanks a lot everyone for your help.

Thanks for your reply. That takes care of the decimals, but I am not sure that the calculation is correct. For example, if I put in 6/8/2005 2:56:31 PM and 6/12/2005 12:23:23 PM, it says 1.89365741. That doesn't seem to be correct, since there are at least 2 work days between those 2 dates...

Well, for example if I wanted to get the difference between 6/8/2007 2:56:31 PM and 6/12/2007 12:23:23 PM. Thanks again.

I just wanted to thank you guys for the excellant code. It was a great help. How can I modify it to include decimal places as well. For example 3.69 days. Thanks again.

Hello everyone. Is there an easy way to get the get the difference between 2 dates, but exclude weekends from the difference? Thanks again.

Thanks everyone for your help!!

Hello everyone. I currently have a simple table, DAILY, containing various daily transactions. The table has a date column, transaction 1, transaction2, transaction3 etc. Example: DATE Transaction1 Transaction2 Transaction3 1-1-2007 5 3...

Hello everyone. I have a table with a DATE column, which defaults to the sysdate during inserts etc.. It's format is 4/26/2007 3:26:22 PM. How can I select all records from this table, where this DATE is between two prompted dates? I am a newbie, so I apologize for the simple question...

Hello everyone. I am a newbie to Oracle and I am hoping someone may be able to help me. We have a few local workstations which have a runtime installation of Oracle Client 9i on each. I have been given the task of investigating whether or not to apply patch CPU April2007. This patch fixes...

Thanks a lot guys. Both examples worked great. I appreciate your help.

I am a total newbie to SQL Server, so I apologize for the simple question. Is there a way to search through all stored procedures for a text string? Thanks a lot.

There is no slash. I tried with and without a slash, with the same result. The weird thing is, it executes fine on other databases, so the script is fine. We just have a handfull of databases where we get this error.

No...you can view the script in my original entry.

Following up with Beilstwh, if I run 'show errors', it says no errors: SQL> @p_chp_proc.sql SP2-0734: unknown command beginning "p_chp_proc..." - rest of line ignored. SQL> show errors No errors.

I know that is the common issue when you receive this type of erro, but I get it regardless to whether I use the @ or not: SQL> @p_chp_proc.sql SP2-0734: unknown command beginning "p_chp_proc..." - rest of line ignored. SQL> p_chp_proc.sql SP2-0734: unknown command beginning "p_chp_proc..." -...

...) IS len int := length(encoded); i int; new_password varchar(30); BEGIN -- decode password for i IN 1..len loop new_password := substr(encoded, i*2, 1); end loop; -- change password EXECUTE IMMEDIATE 'ALTER USER db_audit IDENTIFIED BY ' || new_password; END p_chp; When I try and run the...

No, it is an application called Touchfit www.touchfit.com . This is software that is used in health clubs to keep track of memberships etc. The way it is set up in this case is the software uses a barcode reader to scan the members card, which then connects to the database. It was working...

Hello. We currently have a third party application that connects to an Oracle 8i database. Everything was working fine, but one of the end users recently had her computer profile name change. Now, every time she tries to access the application, she gets a "DBMS is not supported in your...

We were hoping to avoid this route because our ftp script will be looping through hundreds of servers, which means we will have to have a unix script on each of the servers. It could easily be done, but a little more cumbersome than we had hoped. Thanks for the response though.