Categories
Archives
-
Recent Posts
Top Posts
Advertisements
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
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
This is to count the number of rows in a table. Cyrus is the owner and customer is the table.
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