Python Forum
Running Sql query stored in CSV file
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Running Sql query stored in CSV file
#1
Hi All,
I am developing one piece of code where I need to query oracle database and save result of query .

Query will be stored in CSV format at some local place . Python code should read query from local place and execute this.

How can I do this ? Can somebody help on this .

I donot want to hard code sql query inside python script because as per requirement we need to change the where clause again and again. I want to keep it in separate place and want to call from Python.


Can Somebody give me hint on this ??
Reply


Messages In This Thread
Running Sql query stored in CSV file - by purnima1 - Oct-02-2017, 06:15 AM
RE: Running Sql query stored in CSV file - by buran - Oct-02-2017, 06:56 AM
RE: Running Sql query stored in CSV file - by buran - Oct-02-2017, 08:25 AM
RE: Running Sql query stored in CSV file - by buran - Oct-02-2017, 09:01 AM
RE: Running Sql query stored in CSV file - by buran - Oct-02-2017, 09:12 AM
RE: Running Sql query stored in CSV file - by buran - Oct-03-2017, 11:15 AM
RE: Running Sql query stored in CSV file - by buran - Oct-04-2017, 10:17 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  error "cannot identify image file" part way through running hatflyer 0 862 Nov-02-2023, 11:45 PM
Last Post: hatflyer
  Web project and running a .py file emont 0 748 Dec-11-2022, 11:15 PM
Last Post: emont
  batch file for running python scipt in Windows shell MaartenRo 2 2,093 Jan-21-2022, 02:36 PM
Last Post: MaartenRo
  rows from sql query need to write to a file as columns sjcsvatt 6 2,610 Oct-09-2021, 12:45 AM
Last Post: snippsat
  write mariadb table rows query to each file? shams 1 2,031 Feb-02-2021, 04:10 PM
Last Post: buran
  Running A Parser In VSCode - And Write The Results Into A Csv-File apollo 5 4,902 Jan-14-2021, 08:58 PM
Last Post: snippsat
  WinError 87 while running .exe file Timych 0 2,500 Aug-06-2020, 02:36 PM
Last Post: Timych
  Write SQLite query result to file hjk6734 1 2,039 May-27-2020, 12:17 PM
Last Post: menator01
  problem running python file using cmd panzers 2 2,412 Dec-19-2019, 04:04 PM
Last Post: panzers
  Interpreter and running a .py file give different outputs PythonNPC 5 3,230 Jul-21-2019, 01:07 PM
Last Post: PythonNPC

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020