Category Archives: Database

[python]Using cx_Oracle module

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

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

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

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