Oct-02-2017, 09:12 AM
(Oct-02-2017, 09:11 AM)purnima1 Wrote: I am using oracle Database. and My code is returning list which is not good idea.
Ok I will follow as you have explained
In this case you need to use package/interface to work with Oracle DB, not sqlite
Assuming
my_query.sql
Output:SELECT WORK_PHONE, source_sys_cd, source_sys_id
FROM mdm_people_standard
WHERE source_sys_cd ='PWS' AND WORK_PHONE IS NOT NULL;
and python code to read itwith open ('my_query.sql', 'r') as query_file: sql_query = query_file.read() print(sql_query)