Merge branch 'master' of https://github.com/oracle/oracle-db-examples

Kuassim · Kuassim · commit df67952d0682 · 2018-07-03T19:40:32.000-07:00
diff --git a/README.md b/README.md
@@ -5,6 +5,7 @@ This repository stores a variety of examples demonstrating how to use the Oracle
 | ------------- | ------------- |
 | [db-sample-schemas](https://github.com/oracle/db-sample-schemas) | Git submodule of the Oracle Database Sample Schemas |
 | [dotnet](./dotnet) | .NET based examples |
+| [exadata-express](./exadata-express) | Exadata Express examples |
 | [java](./java)  | Java based examples |
 | [javascript](./javascript) | JavaScript based examples |
 | [optimizer](./optimizer) | Oracle Optmizer and Optimizer Stats examples |
diff --git a/exadata-express/Query.py b/exadata-express/Query.py
@@ -0,0 +1,37 @@
+#------------------------------------------------------------------------------
+# Query.py
+#
+# Demonstrate how to perform a query of a database schema, configured with Oracle's sample HR Schema, in your Exadata Express
+# Cloud Service.
+#
+# Before running this app:
+#   1. From the Exadata Express Cloud Service Console, click on Develop, then click on Python. Follow displayed instructions to: 
+#      - Install instant client.
+#      - Enable client access and download your Exadata Express Cloud Service credentials.
+#      - Install the Python Extension module (cx_Oracle) to enable access to your cloud service.
+#   2. Create a schema using the Exadata Express Cloud Service Console. Remember the schema name and password for step 4.
+#   3. Configure the schema with Oracle's Sample HR Schema. Scripts to configure this schema can be found on GitHub. 
+#      See github.com/oracle/db-sample-schemas for scripts and instructions.
+#   4. Modify cx_Oracle.connect to connect to the HR schema you created in step 2: 
+#      - The first value is the name of your HR schema.
+#      - The second value is the password for your HR schema.
+#      - The third value is "dbaccess", which is defined in the wallet downloaded from the Exadata Express Cloud Service 
+#------------------------------------------------------------------------------
+
+from __future__ import print_function
+
+import cx_Oracle
+
+
+connection = cx_Oracle.connect('HR',password,'dbaccess')
+
+sql = """
+select * from employees where department_id = 90"""
+        
+
+print("Get all rows via iterator")
+cursor = connection.cursor()
+for result in cursor.execute(sql):
+    print(result)
+print()
+
