Database table structure compare(Oracle)

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

Database table structure compare(Oracle)

GKT
Unladen Swallow

Posts: 4

Threads: 2

Joined: Oct 2019

Reputation: 0

Oct-16-2019, 03:16 PM

with open(file_path, "w", newline='') as csv_file: # Python 3 version
csv_writer = csv.writer(csv_file)
csv_writer.writerow([i[0] for i in curs.description]) # write headers
csv_writer.writerows(curs)

hope this clears you question.

Find

Messages In This Thread

Database table structure compare(Oracle) - by GKT - Oct-15-2019, 07:25 PM

RE: Database table structure compare(Oracle) - by Larz60+ - Oct-15-2019, 07:37 PM

RE: Database table structure compare(Oracle) - by GKT - Oct-15-2019, 08:01 PM

RE: Database table structure compare(Oracle) - by Larz60+ - Oct-16-2019, 02:21 AM

RE: Database table structure compare(Oracle) - by GKT - Oct-16-2019, 03:16 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	How to use pandas to compare two DataFrames having different structure	traja47	0	799	Sep-24-2022, 08:07 AM Last Post: traja47
	SaltStack: MySQL returner save less data into Database table columns	xtc14	2	2,193	Jul-02-2021, 02:19 PM Last Post: xtc14
	Yahoo_fin, Pandas: how to convert data table structure in csv file	detlefschmitt	14	7,841	Feb-15-2021, 12:58 PM Last Post: detlefschmitt
	Load data from One oracle Table to Multiple tables	amy83	1	1,795	Dec-02-2020, 01:57 AM Last Post: Larz60+
	Fetch Oracle DB rows & print it in HTML file with table's col headers in table format	tssr_2001	1	3,010	Sep-04-2020, 01:39 PM Last Post: ibreeden
	Load table from Oracle to MYSQL using python	himupant94	0	1,666	May-12-2020, 04:50 PM Last Post: himupant94
	Database structure (no code?)	BlackmoreSteve620721	1	1,850	Apr-13-2020, 10:39 PM Last Post: Larz60+
	How to compare in python an input value with an hashed value in mysql table?	Formationgrowthhacking	4	3,357	Jan-14-2020, 11:43 AM Last Post: Formationgrowthhacking
	MYSQL how to assign a table for each user in my username table database?	YoshikageKira	1	2,830	Dec-26-2019, 05:57 AM Last Post: buran
	How read Table Structure from Database	nnsatpute	5	3,753	Oct-25-2019, 10:08 AM Last Post: Larz60+

Users browsing this thread: 2 Guest(s)

View a Printable Version

Database table structure compare(Oracle)

User Panel Messages

Announcements