I need to write a C program to compare two files not in the same sequence.
ie. Take one line from first file....compare with all lines in second file....If there is no match....put it in a third file
If there is any match ...leave that line...and go to the second line in the first file....again compare with all lines in second file.
Continue the same procedure till we reach the end of the first file....
anithas
Last Activity: Jul 13 '07, 08:55 AM
Joined: Feb 7 '07
Location:
-
C Program to compare two files
-
sorry can u be more clear in where im goin wrong and what i need to do wrt to the query... -
ms-access to oracle migration
SELECT [FDDS-Customers].REGION, [FDDS-Customers].DISTRICT, [FDDS-Customers].TERRITORY, [FDDS-Customers].[CUSTOMER NAME], [FDDS-Customers].ADDRESS, [FDDS-Customers].[ADDRESS 2], [FDDS-Customers].CITY, [FDDS-Customers].STATE, [FDDS-Customers].ZIP, [FDDS-Customers].[PHONE NUMBER], [FDDS-Customers].[CONTRACT NUMBER], [FDDS-Customers].[CONTRACT TITLE], [FDDS-Customers].[CONTRACT DESCRIPTION], [FDDS-Customers].[CONTRACT TYPE], Format([CUSTOMER LINKED DATE],"m/d/yyyy")... -
MS-access to oracle migration
Hi,
I am using a particular query already existing in Ms-access , to oracle..
But i do not get the correct order or sequence though using the orderby clause.....
There is some hidden sorting done in access...which im not sure how to implement in oracle.
Please help...... -
error in cursor
bELOW IS MY SCRIPT...USING A CURSOR FOR A SELECT STATEMENT AND INSERTING EACH SELECTED RECORD INTO ATABLE CALLED TESTCUR.......T HE LOOP CONTINUES UNTIL THE ALL RECORDS HAVE BEEN FETCHED...but i receive the error as below
line xx, column yy PL/SQL: SQL Statement ignored
what i need to do
DECLARE
CON_NUM TESTCUR.contrac t_numbr%TYPE;
CON_TIT TESTCUR.CONTRAC T_TITLE%TYPE;... -
writing output from Pl/SQL o txt file
I need to write the o/p from an Oracle Pl/SQL to a txt file.
I tried the following , but i get an error
declare
f utl_file.file_t ype;
s varchar2(200) := 'this is some info';
begin
f := utl_file.fopen( 'SAMPLEDATA','s ample2.txt','W' );
utl_file.put_li ne(f,s);
utl_file.fclose (f);
end;
error is : r): ORA-29280: invalid directory path ORA-06512:... -
Thanks for ur response....its a macro which when executed, runs a list of SQL queries written in MS access.
Now i have to write these MS access queries to PL/SQL procedures...th ough the syntax is more or less similar in structure.....i f i have any converter tool...i can cross verify the syntax and help me
To put it staright....i need the name of any tool...which will convert MS aCCESS sQL queries to Pl/SQL...Leave a comment:
-
MS ACCESS to PL/SQL converter
Hi,
Currently im working on implementing a MS ACCESS macro functionality to Oracle Pl/SQL package. I need to know if there are any tools available for MS ACCESS to Oracle Pl/SQL or SQL. I need it for reference purpose....for checking for syntax etc....since Im new to Oracle Pl/SQL
No activity results to display
Leave a comment: