problem with SQL query using python on cx_oracle. Thread starter madmanX; ... I had a python script that needs to access an oracle 11g database and run a select statement to pull back some records.

When you use the new names in the first SELECT statement, you can specify the names in any order. Add the NOLABEL option to the query to display the renamed columns. The PROC SQL SELECT statement uses ...

Using SELECT. A simple SELECT statement is the most basic way to query multiple tables. You can call more than one table in the statement’s FROM clause to combine results from multiple tables.

create view proclib.view1 as select * from accrec.invoices as invoices using libname accrec oracle user=username pass=password path='dbms-path'; For more information on the SAS/ACCESS LIBNAME ...