Write a pl-sql program using the implicit cursor, PL-SQL Programming

Assignment Help:

Question:

a) Given the following relation:

Location(loc_id, bldg_code, room, capacity)

The underlined field is a primary key.

(i) Write a PL/SQL program using the implicit cursor to display the building code of location id 5.

(ii) Write a PL/SQL program that uses an explicit cursor to retrieve and display the room value for every record in the location table in which the building code value is "LIB".

(b) Write a PROLOG program that answers the question about family members and relationships. Include predicates and rules which define sister, brother, father, mother, grandchild, grandfather and uncle. The program should be able to answer queries such as the following:

- father(X,Bob)
- grandson(X,Y)
- uncle(Bill, Sue)
- mother(mary, X)

Related Discussions:- Write a pl-sql program using the implicit cursor

Natural join - sql, Natural Join - SQL In the absence of NATURAL JOIN...

Natural Join - SQL In the absence of NATURAL JOIN Example has to be replaced by something rather more longwinded, as shown in Example. Example: Joining IS_CALLED and IS_EN

Cursors, What is Cursors how to use it in Real time application ?

What is Cursors how to use it in Real time application ?

Semidifference via not in and a subquery , Semidifference via NOT IN and a ...

Semidifference via NOT IN and a subquery SELECT StudentId FROM IS_CALLED WHERE Name = 'Devinder' AND StudentId NOT IN (SELECT StudentId FROM IS_ENROLLED_ON WHER

Theory of biogenesis, THEORY OF BIOGENESIS - This theory explains th...

THEORY OF BIOGENESIS - This theory explains that the existing living organisms originated from pre-existing living beings not from non living entities. This concept of or

Using exists - collection methods, Using EXISTS The EXISTS(n) returns ...

Using EXISTS The EXISTS(n) returns TRUE if the nth element in a collection exist. Or else, EXISTS(n) returns FALSE. Primarily, you use EXISTS with DELETE to maintain the spars

Keyword and parameter description in pl sql, Keyword and Parameter Descript...

Keyword and Parameter Description: label_name: This is an undeclared identifier which optionally labels the PL/SQL block. When used, label_name should be enclosed by the do

Example of shorthand for a row constraint - sql, Example of Shorthand for a...

Example of Shorthand for a row constraint Example: Shorthand for a row constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Mark_in_range CHECK (Mark BETWEEN 0 AND 100);

Information hiding in pl/sql, Information Hiding With the informatio...

Information Hiding With the information hiding, you see only the details that are significant at a given level of algorithm and data structure design. The Information hiding

When or then key constraints, WHEN or THEN Key Constraints Suppose a t...

WHEN or THEN Key Constraints Suppose a table has two columns representing a period of time throughout which the information conveyed by the other columns is recorded as having

Create Tables, Hi there, I have the final part of a submission to do, it ...

Hi there, I have the final part of a submission to do, it is a demonstration that takes place tomorrow. I do not have to use previous information, but i have resources that sho

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages