Sql queries-oracle , PL-SQL Programming

1- You can check attribute names from each table in DBF11 by running for example:

 desc dbf11.Member;

 desc dbf11.Agent;

 desc dbf11.Producer;

Because some attribute names in the tables might be slightly different from those in the assignment blue sheet, please make sure to verify the attribute names first before querying the tables.

This way, you check the real data set first before validating your queries.

2- For question 1d:

Display the month(s) in which the number of entries for the awards is higher than the monthly average of entries for the current year.

The 'number of entries' refers to the FILM entity, and the montly average comes from the 'entry_date'. This question is referring to the number of films that have been entered into the award system.

3- INSTRUCTIONS for TASK 3 FILES

- You need to run (or cut and paste) 'task3-build.sql' on your own oracle account to create the required tables for question 3

- You then need to populate the tables with data by running (or cutting and pasting) 'task3-populate-before-trigger.sql'

- You can then implement the trigger questions for the assignment.

- You need to submit your spool for trigger questions by showing the results of executing (or cutting and pasting) 'task3-populate-after-trigger.sql'.

Posted Date: 3/12/2013 2:29:37 AM | Location : United States







Related Discussions:- Sql queries-oracle , Assignment Help, Ask Question on Sql queries-oracle , Get Answer, Expert's Help, Sql queries-oracle Discussions

Write discussion on Sql queries-oracle
Your posts are moderated
Related Questions
The requirements as follows: Create a folder called "SECURITY" on the server and upload all your project files to that folder. Please note, the "SECURITY" folder is NOT to be IN

RETURN Statement The RETURN statement instantly completes the execution of a subprogram and returns control to the caller. The Execution then resumes with the statement below t

SQL Cursor   The Oracle implicitly opens a cursor to process each SQL statement not related with an explicit cursor. The PL/SQL refers to the most current implicit cursor as t

MERGE and TRUNCATE in SQL SQL has two more table update operators, MERGE and TRUNCATE. MERGE, like INSERT, takes a source table s and uses it to update a target table t. Brief

Grouping and Ungrouping in SQL Example specifying EXAM_MARK in place of COURSE in the main FROM clause. Example: Obtaining C_ER2 from EXAM_MARK SELECT CourseId, CAST

Brewbean's is implementing a new discount for return shoppers - every fifth completed order receives a 10% discount. The count of orders for a shopper is placed in a packaged varia

Declaring Exceptions The Exceptions can be declared only in the declarative part of the PL/SQL subprogram, block, or package. By introducing its name, you can declare an excep

Example of ADD CONSTRAINT in SQL Example: Alternative formulation for MAX_ENROLMENTS ALTER TABLE IS_ENROLLED_ON ADD CONSTRAINT MAX_ENROLMENTS CHECK ((SELECT COUNT (*)

Providing Results of Queries Expressing queries in SQL is the (big) subject. Here I present just a simple example to give you the flavour of things to come in those chapters.

Tautology - Equivalences Rules: If there Tautologies are not all the time as much easy to note as the one above so than we can use these truth tables to be definite that a sta