HAVING ISSUES UNDERSTANDING HOW TO SOLVE THIS ORACLE QUESTION [message #673573] |
Sat, 24 November 2018 19:58 |
|
pastorfloxy1@gmail.com
Messages: 1 Registered: November 2018
|
Junior Member |
|
|
In the database you will find a table called postcodes owned by the schema postcode. This table holds around 1.7 million records. The tithe parcels are stored in the table tithe_sdo in the tithedb schema. Use your data discovery skills to familiarise yourself with the data in the postcodes and tithe_sdo tables. The queries are designed to build on each other. Answer in the order given, as the answer to the first query will form the basis of the second query, which forms the basis of the third and so on.
:
A.Get a user running your query to enter a postcode to find all the basic information from the tithe parcel table that contains the postcode point given. Think about how you can make this easier for a user. For testing use 'PO1 5DN' and 'PO188BJ'.
Please, any idea on how i should go about this on oracle SQL?
|
|
|
|
|
Re: HAVING ISSUES UNDERSTANDING HOW TO SOLVE THIS ORACLE QUESTION [message #673576 is a reply to message #673573] |
Sun, 25 November 2018 01:21 |
|
Michel Cadot
Messages: 68645 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:Get a user running your query to enter a postcode
What is your client tool? SQL does not get something from the user.
Quote:to find all the basic information from the tithe parcel table that contains the postcode point given
Post a description of each table including the constraints inside and between them.
Quote:For testing use 'PO1 5DN' and 'PO188BJ'.
Post the CREATE and INSERT statements for all objects otherwise we can't make tests.
Note that this site will help you but will not do your homework.
[Updated on: Sun, 25 November 2018 01:24] Report message to a moderator
|
|
|