Home » SQL & PL/SQL » SQL & PL/SQL » Just a bit of help
icon1.gif  Just a bit of help [message #386428] Sat, 14 February 2009 16:59 Go to next message
JackH
Messages: 1
Registered: February 2009
Location: Britain
Junior Member
Hi Everyone Surprised ,

just looking for a bit of help and advice on how i would carry out the following exercise please:

create tables which will be used to provide examples of the following:

a) Subquery
b) Join of 3 tables
c) Correlated subquery

You must provide:

i) The SQL code to create the tables (DDL and DML)
ii) An ERD of the tables
iii) A printout of the tables
iv) THE SQL commands to demonstrate a) b) and c)
v) The output of these commands

Any help appreciated Smile

Regards,

Jack
Re: Just a bit of help [message #386429 is a reply to message #386428] Sat, 14 February 2009 18:05 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you

By the way, we don't do homework assignments here.
You are on the road to success. You've learned how to spell SQL! CONGRATULATIONS!
Re: Just a bit of help [message #386442 is a reply to message #386428] Sat, 14 February 2009 22:54 Go to previous messageGo to next message
m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh
Member

What's your actual problem? I mean what do you want to do?
Re: Just a bit of help [message #386444 is a reply to message #386442] Sun, 15 February 2009 00:40 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
m_golam_hossain wrote on Sun, 15 February 2009 05:54
What's your actual problem? I mean what do you want to do?

He wants us to do his homework. He didn't even bother to rewrite the assignment, so from the text of his post it is clear this is homework.
He first has to show us what he tried and where he got stuck before we can help him.
Simply providing an answer will not help him, nor us, since he will be back with his next assignment. He will not be able to accomplish the next assignment if he can't even do this one.
Re: Just a bit of help [message #386452 is a reply to message #386428] Sun, 15 February 2009 03:08 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
JackH wrote on Sat, 14 February 2009 22:59

just looking for a bit of help and advice on how i would carry out the following exercise please:


Read through your course notes and try to understand them. Then complete the assignment. Post back with specific issues, showing us what you tried and what happened when you tried it.
Re: Just a bit of help [message #386457 is a reply to message #386428] Sun, 15 February 2009 04:26 Go to previous messageGo to next message
m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh
Member

It is unethical and unjustified to have the home-task done by others or to ask for such solutions in such forums.

Thanks-

Mohd. Golam Hossain

[Updated on: Sun, 15 February 2009 04:28]

Report message to a moderator

Re: Just a bit of help [message #386493 is a reply to message #386444] Sun, 15 February 2009 21:44 Go to previous message
m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh
Member

Thanks to Frank for this clarification.

Regards.
Previous Topic: alternatives for utlmatch?
Next Topic: is it possible to create conditional foreign key reference (merged)
Goto Forum:
  


Current Time: Tue Dec 06 12:17:18 CST 2016

Total time taken to generate the page: 0.07333 seconds