Home » SQL & PL/SQL » SQL & PL/SQL » Test Oracle SQL
Test Oracle SQL [message #682118] Tue, 06 October 2020 01:28 Go to next message
misterbean
Messages: 1
Registered: October 2020
Junior Member
Hello. everyone!

Could anyone help to solve the test Oracle sql? Test in attached PDF file.

It is translated from Russian into English.
  • Attachment: testEn.pdf
    (Size: 971.85KB, Downloaded 34 times)
Re: Test Oracle SQL [message #682119 is a reply to message #682118] Tue, 06 October 2020 01:34 Go to previous messageGo to next message
John Watson
Messages: 8426
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read the OraFAQ Forum Guide and How to use code tags and make your code easier to read

What have you tried so far? On what are you stuck?
Re: Test Oracle SQL [message #682120 is a reply to message #682118] Tue, 06 October 2020 01:35 Go to previous message
Michel Cadot
Messages: 67544
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

Previous Topic: extract string and compare
Next Topic: Row Generator Using MODEL Clause, # Repeats Table-Based?
Goto Forum:
  


Current Time: Sat Nov 28 11:03:56 CST 2020