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
%ROWCOUNT The %ROWCOUNT yields the number of rows affected by the INSERT, UPDATE, or DELETE statement, or returned by a SELECT INTO statement. The %ROWCOUNT yields zero when a

In Packages The Forward declarations also group logically related subprograms in the package. The subprogram specifications go in the package specification, & the subprogram b

Expression: This is a randomly complex combination of constants, variables, literals, operators, & function calls. The simplest expression consists of a single variable. If th

FOR-LOOP While the number of iterations through a WHILE loop is unknown till the loop completes, then the number of iterations through a FOR loop is known before the loop is ent

I need SQL to infopath data connection Project Description: Want data retrieval connection from SQL to SharePoint infopath Skills required are Sharepoint, SQL

Other monadic - SQL In 2VL there are just 4 (2 2 ) monadic operators, of which negation is really the only "useful" one. When a third truth value is introduced we have 27 (3 3

I need SQL , WP SQL Expert Project Description: Expert required to modify WP SQL query. Skills required are MySQL, SQL, PHP, Wordpress

Left and Right Joins LEFT OUTER JOIN can be used when you want to retrieve the data from the main table (table1) even if there is no match in other tables (table_2, table_3...

Cursor Variables As Parameters You can declare the cursor variables as the formal parameters of the functions and procedures. In the illustration below, you define the REF CUR

Object Types An object type is a user-defined complex datatype which encapsulates the data structure along with the functions and procedures required to manipulate the data. Th