Category Archives: Database

[python]Using cx_Oracle module

Posted on October 20, 2018 by

This is a try out for using cx_Oracle module maintained by Oracle. The version I am trying is version 12.2 Here’s the same code: The above is a test out code, to test on how to connect to the oracle … Continue reading →

Posted in Database, Python | Tagged | Leave a comment

Database – Normalisation

Posted on October 18, 2018 by

All the examples will use this simple table for explanation. Attribute is column, and tuple is row. In this table the attributes are from A to F. Functional dependency A is determinant, B is dependant. B is functional dependent on … Continue reading →

Posted in Database | Tagged , | Leave a comment

Database: count number of rows in a table

Posted on September 25, 2018 by

This is to count the number of rows in a table. Cyrus is the owner and customer is the table.

Posted in Database | Tagged | Leave a comment

Database: Check all tables from a known owner

Posted on September 22, 2018 by

This is an oracle 12c query to find out all tables that are owned by “cyrus”. select owner,table_name from all_tables where owner=’CYRUS’; the contents in the row is case sensitive, in this example the content in row “owner” is CYRUS … Continue reading →

Posted in Database | Tagged , | Leave a comment