Search results for query: *

We have Exchange 2007 and MS Office 2007 here. One day while setting up the "Out Of Office Assistant", I noticed that it did not work properly. With Outlook 2007, this feature (Out of Office Assistant) is greatly enhanced, however, it did not work as it should. There are 2 parts of this new...

I am running a query to capture data in the last 48 hours and wonder if someone can shed some lights for me on this: This is part of the query.... SELECT FIELD1 FROM TABLE1 WHERE ADD_DATE > SYSDATE-2 The query runs every day at 7:00 PM. For example, when it runs at 7:00 PM today, I want to...

I create a query and would like to export it to Excel format. I would like to automate this process so it will run by itself. I created a Macros so this can be done automatically. While creating the query, the process needs to access two separate databases to gather the data. One is Oracle...

Hi all, I have two tables which were initially created to hold temp data. When those two tables were created, we did not define any of the max extents size. Today, the business requirements have changed and we are adding more data into those two tables more than ever before. As a result, I...

Does anyone know how to backup the configuration file for this switch using an Internet Browser (Internet Explorer or FireFox)? A step by step instruction is appreciated.... I need to back it up before making a change to it so I can reverse the change if I need to. Thanks...

Hi all, I am running a query which will pull approx 35,000 rows of record. The script is very simple as shown below: ****************************** set echo off set feedback off set pages 0 set heading off set flush off set trimspool on SELECT SKU, MANUFACTURERSKU,RETAILSKU,ALTSKU FROM SKU...

Hi all, I am executing an SQLLDR command to load data into a table on my Oracle 8i database. The control files are located on the Oracle server, however, the dat files are located on another NT server. I am getting the following error message every time: SQL*Loader-500: Unable to open file...

Hi all, I am creating a query which will run every day at a specific time. My database is Oracle 8i. I need to know the last unique key the system used the previous day. My script looks like this: select max(orderdetail.orderkey) from orderdetail,orders where...