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 834 Nov-02-2023, 11:45 PM
Last Post: hatflyer
  Web project and running a .py file emont 0 734 Dec-11-2022, 11:15 PM
Last Post: emont
  batch file for running python scipt in Windows shell MaartenRo 2 2,067 Jan-21-2022, 02:36 PM
Last Post: MaartenRo
  rows from sql query need to write to a file as columns sjcsvatt 6 2,578 Oct-09-2021, 12:45 AM
Last Post: snippsat
  write mariadb table rows query to each file? shams 1 2,015 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,869 Jan-14-2021, 08:58 PM
Last Post: snippsat
  WinError 87 while running .exe file Timych 0 2,485 Aug-06-2020, 02:36 PM
Last Post: Timych
  Write SQLite query result to file hjk6734 1 2,025 May-27-2020, 12:17 PM
Last Post: menator01
  problem running python file using cmd panzers 2 2,400 Dec-19-2019, 04:04 PM
Last Post: panzers
  Interpreter and running a .py file give different outputs PythonNPC 5 3,222 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