Search results for query: *

what i just need is a procedure, because offshore facilities are far. thanks AQM

I already have this tables, what I need is a procedure that will constantly insert the comments captured from offshore by operators from one database into another different database with the same data. thats why i need a procedure to do that. please help AQM

my table structure is: CREATE TABLE FV_EVENT_CODES ( CODE_ID VARCHAR2 (23) NOT NULL, CODE_TYPE NUMBER (10) NOT NULL, DELETE_DATE DATE, NAME VARCHAR2 (120), CODE VARCHAR2 (15), DESCRIPTION VARCHAR2 (768) ) ; ---this is the table where the codes are...

dir gurus, how do I create a procedure to insert text comments to my database? this comments comes from offshore operators.

Dear Gurus, I need help on a PL/SQL procedure to import comments into my Database with the following format: EVENT#Surface#20060825#200608250000#200608260000#9PAL P2## PALP2: Pression arrivée pipe gaz lift =114bar. Arrêt volontaire de la 2GX301A de reprise huile bloc2 pour le préventif...

I actually thought to bind this query to an atribute. so I did a select(select * from fv_data_dictionary where column_name like '%CARRIED%' order by column_name) to see which tables do I have this atribute that I will use to identify whether data was entered or it just did a carryforward. this...

sorry for my basic ignorance in queries. these column EXPECTED_OIL_PROD, EXPECTED_WATER_PROD from FV_BATTERY_NON_PROD tables could be an example and then the rest I will add to try it.

it does work but can you help to view the columns in these tables of which data is missing? because this query displays the dates only and not their respective column where data is missing. I want to specifically display Oil , water and meter data if you check the table scrips you will see these...

I tried this code below but the SQL*plus gives this error: Invalid Identifier "missing_dates" column. cna you please explain if this is a column of Oracle all_objects or I must replace that with a column named similar from my database? thanks MAQAQM

this is indeed what I want, but I will try and use this one if it works. My Crystal Report version is 10. please can you work out a solution with this: "unrepresented dates" from EACH of the tables individually or from ALL of the tables collectively (i.e., if you harvest ALL of the DATEs from...

below are the table scripts: ================================ CREATE TABLE FM_SPECIFICATION ( KIND NUMBER NOT NULL, START_DATE DATE, END_DATE DATE, NAME VARCHAR2 (150), DEFINED_BY VARCHAR2 (20), TYPE NUMBER ) ; CREATE TABLE...

the table involved are so many tables, but I past them below. the Date column is Date_stamp from FV_DATES table and that's the only column i it. the rest if you need their column, please let me know. I want to check from selected options, or range of dates that the database will verify. e.g...

Dear Gurus, I want to build a view and from it create a report with crystal reports, the query must be able to tell me how many days are missing data in the database! can someone help me on this? a query which tells me the days where there is no data in the tables of the database thanks AQM

Now i discussed with exchange admin, has opened an exception with ironport we use by allowing the IP address of my server to send email through the port 25. and it worked. I received the emails from the script and other also who I have sent, thanks man for your great help! AQM

I tried several different address not still it does not work. it says: unable to relay to th email address. I spoke to the exchange admin, and says that there is no restriction, otherwise they would not be able to send e-mails. thanks AQm

Dear guru, it just one problem. it works for the internall e-mail only. when I send it out of my network it gives the message: unable to deliver to amaquengo45@hotmail.com. and I am to add Bcc and Cc recipients but does not accept. is there any other trick? AQM

thanks man. it really worked. i Tested it and it is great!!

I will be basically doing the following: - The batch file export the data into a .txt - and then this same batch file at the end of the export, it calls the VB script you gave me to send the generated files to the client immediatelly. - The files I will be sending are in the same...

Yes dear, thanks. I did the telnet and it worked. it connected to the exchange server. please give next instructions. thanks AQM

Yes, I want to be adding the sysdate to the script after attachments or attach them with different names.