[DATABASE]SQL query examples

There are three relations used for this example - RENTAL_CUSTOMER, CAR, RENTAL. Below are the SQL statements used to create the relations. Data have been inserted to the relations: RENTAL_CUSTOMER CAR RENTAL List all cars rented by Smith since 1st of August 2017 List each make of the cars and the total number of cars … Continue reading [DATABASE]SQL query examples

Advertisements

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 not Cyrus or cyrus. another way if you do not know the case of the … Continue reading Database: Check all tables from a known owner