06-10-2010
difference in files.
Hi All,
****************************************************************
File1:
CREATE TABLE "TESTIHUB"."CINEMA"
( "NAME" VARCHAR2(20),
"ACTOR" VARCHAR2(20),
"YEAR" NUMBER
);
/
CREATE TABLE "TESTIHUB"."PANT"
( "CNAME" VARCHAR2(20),
"AMOUNT" NUMBER,
"STOCKNO" NUMBER
);
/
*****************************************************************
File2:
CREATE TABLE "TESTIHUB"."CINEMA"
( "NAME" VARCHAR2(20),
"ACTOR" VARCHAR2(20),
"YEAR" NUMBER
"PRODUCER VARCHAR2(20)
);
/
CREATE TABLE "TESTIHUB"."PANT"
( "CNAME" VARCHAR2(20),
"AMOUNT" NUMBER,
"STOCKNO" NUMBER
);
/
*********************************************************************
I want to compare these two files with respect to blocks I mean to say I want to compare entire create statments as one unit. Incase of any difference out-put the difference
into a file with both create statements and difference element. As here in file2 in create statment CINEMA in file2 producer is added.
Thanks
Naree
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i have 2 files
file 1---------> hello
file 2---------> hello world
is there any command that we find the diff b/w two files and gives the ans as what is not matched with file 2.
diff file 1 file 2
here the desired o/p should be: world
as "world" is not found in file 1. (2 Replies)
Discussion started by: ali560045
2 Replies
2. Shell Programming and Scripting
I know the basic difference between .pm and .pl files. But wat puzzles me is when to go for creating a module and when to create .pl files.Based on wat criteria we sholud decide to make a function whcih implements a common functionality as module or a .pl file ?? (3 Replies)
Discussion started by: Anuj8584
3 Replies
3. Shell Programming and Scripting
Hi All,
I need your help to find out the difference between 3 files.
How can i get the output which says that FILE2 contains additional (YYY,900,100) compare to FILE1 and FILE3 contains addition record (ZZZ,904,908) compare to FILE1?
I have tried using diff3 command, but was not able to get... (2 Replies)
Discussion started by: Amit.Sagpariya
2 Replies
4. Shell Programming and Scripting
I have two files like follows: -
File 1: -
A 20
B 15
D 10
C 6
File 2: -
B 21
A 20
C 11
D 10
Now I want file like this: -
It should pick up 'A' from File 1 and pick up 'A' from File 2 and should get difference of the numbers in 2nd column and display result as follows ... (2 Replies)
Discussion started by: balu_puttaganti
2 Replies
5. Shell Programming and Scripting
HI Folks,
sorry if it is a naive question.
i have two files . "file1.txt" & "file2.txt"
contents in files:
file1.txt file2.txt
-------- ---------
1 ... (2 Replies)
Discussion started by: babusek
2 Replies
6. Shell Programming and Scripting
i have two files A and B and i want the difference to be printed in file C
as in example below
File A
10E32E7BCC5881DDB6||002878|1|1|
10E32E7BCC5881DDB7||002878|1|1|
10E32E7BCC5881DDB8||002878|1|1|
10E32E7BCC5881DDB9||002878|1|1|
File B
10E32E7BCC5881DDB1||002878|1|1|... (4 Replies)
Discussion started by: tomjones
4 Replies
7. UNIX for Advanced & Expert Users
I need the get the difference between 2 files and the result, I need to output it to an other file
file1
1
1
2
file2
1
1
2
3
Result....File3=3
used diff file1 file2 > file3 ( not working as expected)..Exact requirement..I have 2 flatfiles to compare and load only the difference in a... (0 Replies)
Discussion started by: win4luv
0 Replies
8. UNIX for Dummies Questions & Answers
Hi all,
I have problem in finding the difference. suppose i have two file
file1 file2
1xyz 1xyz
1asd 1xyz
1asd 1abc
2adf 1asd
3asd 2abd
4abc 2adf
3asf
I need to... (7 Replies)
Discussion started by: XXLMMN
7 Replies
9. Shell Programming and Scripting
HI Team,
Could you please help me here.
I need to compare 4 files
a)
1
2
3
4
b)
1
5
3
4
c)
1
2
5 (1 Reply)
Discussion started by: madhuchilipi
1 Replies
10. UNIX for Beginners Questions & Answers
I have two file as given below which shows the ACL permissions of each file. I need to compare the source file with target file and list down the difference as specified below in required output. Can someone help me on this ?
Source File
*************
# file: /local/test_1
# owner: own
#... (4 Replies)
Discussion started by: sarathy_a35
4 Replies
LEARN ABOUT CENTOS
select_into
SELECT
INTO(7) PostgreSQL 9.2.7 Documentation SELECT INTO(7)
NAME
SELECT_INTO - define a new table from the results of a query
SYNOPSIS
[ WITH [ RECURSIVE ] with_query [, ...] ]
SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
* | expression [ [ AS ] output_name ] [, ...]
INTO [ TEMPORARY | TEMP | UNLOGGED ] [ TABLE ] new_table
[ FROM from_item [, ...] ]
[ WHERE condition ]
[ GROUP BY expression [, ...] ]
[ HAVING condition [, ...] ]
[ WINDOW window_name AS ( window_definition ) [, ...] ]
[ { UNION | INTERSECT | EXCEPT } [ ALL | DISTINCT ] select ]
[ ORDER BY expression [ ASC | DESC | USING operator ] [ NULLS { FIRST | LAST } ] [, ...] ]
[ LIMIT { count | ALL } ]
[ OFFSET start [ ROW | ROWS ] ]
[ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLY ]
[ FOR { UPDATE | SHARE } [ OF table_name [, ...] ] [ NOWAIT ] [...] ]
DESCRIPTION
SELECT INTO creates a new table and fills it with data computed by a query. The data is not returned to the client, as it is with a normal
SELECT. The new table's columns have the names and data types associated with the output columns of the SELECT.
PARAMETERS
TEMPORARY or TEMP
If specified, the table is created as a temporary table. Refer to CREATE TABLE (CREATE_TABLE(7)) for details.
UNLOGGED
If specified, the table is created as an unlogged table. Refer to CREATE TABLE (CREATE_TABLE(7)) for details.
new_table
The name (optionally schema-qualified) of the table to be created.
All other parameters are described in detail under SELECT(7).
NOTES
CREATE TABLE AS (CREATE_TABLE_AS(7)) is functionally similar to SELECT INTO. CREATE TABLE AS is the recommended syntax, since this form of
SELECT INTO is not available in ECPG or PL/pgSQL, because they interpret the INTO clause differently. Furthermore, CREATE TABLE AS offers a
superset of the functionality provided by SELECT INTO.
Prior to PostgreSQL 8.1, the table created by SELECT INTO included OIDs by default. In PostgreSQL 8.1, this is not the case -- to include
OIDs in the new table, the default_with_oids configuration variable must be enabled. Alternatively, CREATE TABLE AS can be used with the
WITH OIDS clause.
EXAMPLES
Create a new table films_recent consisting of only recent entries from the table films:
SELECT * INTO films_recent FROM films WHERE date_prod >= '2002-01-01';
COMPATIBILITY
The SQL standard uses SELECT INTO to represent selecting values into scalar variables of a host program, rather than creating a new table.
This indeed is the usage found in ECPG (see Chapter 33, ECPG - Embedded SQL in C, in the documentation) and PL/pgSQL (see Chapter 39,
PL/pgSQL - SQL Procedural Language, in the documentation). The PostgreSQL usage of SELECT INTO to represent table creation is historical.
It is best to use CREATE TABLE AS for this purpose in new code.
SEE ALSO
CREATE TABLE AS (CREATE_TABLE_AS(7))
PostgreSQL 9.2.7 2014-02-17 SELECT INTO(7)