Home » SQL & PL/SQL » SQL & PL/SQL » HAVING ISSUES UNDERSTANDING HOW TO SOLVE THIS ORACLE QUESTION (ORACLE SQL)
HAVING ISSUES UNDERSTANDING HOW TO SOLVE THIS ORACLE QUESTION [message #673573] Sat, 24 November 2018 19:58 Go to next message
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 #673574 is a reply to message #673573] Sat, 24 November 2018 20:24 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read


using COPY & PASTE post the FULL results of the SQL below

SELECT * FROM V$VERSION;
Re: HAVING ISSUES UNDERSTANDING HOW TO SOLVE THIS ORACLE QUESTION [message #673575 is a reply to message #673573] Sun, 25 November 2018 01:19 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
TTHis is a college homework question? You need to show what SQL you have tried, and of course describe (with DESCRIBE) the tables.

By the way, you will not get good marks if you say "record" when you mean "row".
Re: HAVING ISSUES UNDERSTANDING HOW TO SOLVE THIS ORACLE QUESTION [message #673576 is a reply to message #673573] Sun, 25 November 2018 01:21 Go to previous message
Michel Cadot
Messages: 68624
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

Previous Topic: General Question on altering table without locking it
Next Topic: How to run the procedure that have array output?
Goto Forum:
  


Current Time: Thu Mar 28 04:13:15 CDT 2024