|
|
Re: Test Oracle SQL [message #682120 is a reply to message #682118] |
Tue, 06 October 2020 01:35 |
|
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Indent the code, use code tags and align the columns in result.
Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.
With any SQL or PL/SQL question, please, Post a working Test case: create table (including all constraints) and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.
Post what you tried.
We do not do your homework for you, we do not help you to cheat at your exam.
But we'll help you to find the solutions by yourself.
Tell me and I'll forget; show me and I may remember; involve me and I'll understand
[Updated on: Tue, 06 October 2020 01:36] Report message to a moderator
|
|
|