Using the relations and the rules set out in the notes under
each relation, write table create statements for the
relations EMPLOYEE, FIRE and DESPATCH. You should aim to
provide each constraint with a formal name, for example
table_column_pk.
No Answer is Posted For this Question
Be the First to Post Answer
What is a select query statement in oracle?
what is difference between foreign key and reference key
What is bulk copy or bcp in oracle?
interview questions with answer for cts
What is a initialization parameter file in oracle?
How to execute a stored program unit?
what is the uses of cusor
What is a Private Synonyms ?
How to update values on multiple rows in oracle?
create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......
What are ACID properties in databases?
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 Answers College School Exams Tests, DELL,