Sql

Search

CX_Oracle - import data from Oracle to Pandas dataframe

query = """SELECT* 
           FROM TRANSACTION
           WHERE DIA_DAT >=to_date('15.02.28 00:00:00',  'YY.MM.DD HH24:MI:SS')
           AND (locations <> 'PUERTO RICO'
           OR locations <> 'JAPAN')
           AND CITY='LONDON'"""
df_ora = pd.read_sql(query, con=connection)

Comment

PREVIOUS	NEXT

Code Example
Sql :: how to get nears location in mysql with latitude and longitude
Sql :: brew install mysql 8
Sql :: postgres datetime now
Sql :: MYSQL select last query
Sql :: create pl/sql stored procedure
Sql :: how to import large sql file in phpmyadmin in ubuntu
Sql :: postgresql dump and restore db
Sql :: sql add two values together
Sql :: oracle sql create table from select
Sql :: convert money to varchar sql server
Sql :: mysql alter table add column first
Sql :: postgres set column based on another column
Sql :: rename database in sql
Sql :: concat using laravel
Sql :: sql query to list all tables in a database sql server
Sql :: plsql print
Sql :: describe table postgres
Sql :: store select query result in variable sql server
Sql :: download mysql 64 bit
Sql :: sql update where id
Sql :: postgresql get today
Sql :: replace null value within column mysql
Sql :: python postgresQL select table
Sql :: update with select postgresql
Sql :: oracle list grants on package
Sql :: sql server case sensitive search
Sql :: get data every 30 days in sql
Sql :: postgresql Create a new role with a username and password
Sql :: return result of function in postgresql
Sql :: sqlite3 import csv

Search

SQL

CX_Oracle - import data from Oracle to Pandas dataframe

ADD CONTENT