SQL ,PLSQL , Unix

-- DB design drop table emp_Salary; drop table emp_Designation; drop table emp; drop table Designations; drop table Departments; drop table Salary_Bands; drop table Addresses; Create table emp( emp_id number, emp_Name varchar2(20), emp_address_id varchar2(10), emp_created_date date, emp_created_by varchar2(20), constraint e_pk primary key(emp_id) ); Create table Departments( dept_id number, dept_name Varchar2(20), constraints dept_pk primary key(dept_id) ); Create table Designations( dept_id number references Departments(dept_id), desg_id number, desg_description varchar2(20), constraints desg_pk primary key(dept_id,desg_id) ); Create table emp_Designation( emp_id number references emp(emp_id), emp_des_dept_id number references departments(dept_...

How to read live logs from SQL? Consider that you want to read the following application log from SQL. /var/log/appDaily.log 1. Create a directory CREATE OR REPLACE DIRECTORY live_Log_Directory AS '/var/log'; 2. Create external table CREATE TABLE Live_APP_Log(     log_text CHAR(250) ) ORGANIZATION external(     Type Oracle_Loader     Default Directory live_Log_Directory     records delimited by newline     LOCATION('appDaily.log')     Reject limit unlimited; 3. Create a view on Live_APP_Log     Create or Replace view App_Log_Information     AS     Select * from Live_APP_Log;     4. Grant necessary permissions to users 5. Now Query Live_APP_Log whenever you want to fetch log information from SQL