Oracle RSS Oracle RSS

Oracle SQL Plus Joining

Reply

•
•
Join Date: Nov 2008
Posts: 3
Reputation: axxouk is an unknown quantity at this point 
Solved Threads: 0
axxouk axxouk is offline Offline
Newbie Poster

Oracle SQL Plus Joining

 
0
  #1
Nov 29th, 2008
Author Table

INSERT INTO Author VALUES (12,'James Smith' );


Using join conditions
Find memebers (by name) who have ever borrowed a book written by certain authour (JAMES SMITH)
Last edited by axxouk; Nov 29th, 2008 at 8:12 pm. Reason: Attaching more files
Attached Files
File Type: doc ERD DIAGRAM-.doc (35.5 KB, 3 views)
File Type: doc conceptual model.txt[1].doc (182.5 KB, 3 views)
File Type: doc entity relationship.txt[1].doc (202.5 KB, 3 views)
Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2004
Posts: 4,212
Reputation: peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of 
Solved Threads: 489
Moderator
Featured Poster
peter_budo's Avatar
peter_budo peter_budo is offline Offline
Code tags enforcer

Re: Oracle SQL Plus Joining

 
0
  #2
Nov 30th, 2008
And what you expect us to do with this?
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Reply With Quote Quick reply to this message  
•
•
Join Date: Feb 2007
Posts: 2,122
Reputation: debasisdas will become famous soon enough debasisdas will become famous soon enough 
Solved Threads: 129
debasisdas's Avatar
debasisdas debasisdas is offline Offline
Postaholic

Re: Oracle SQL Plus Joining

 
0
  #3
Dec 1st, 2008
what have you tried till date.

i do not open all the attachments that i come across in net .
Share your Knowledge.
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2008
Posts: 3
Reputation: axxouk is an unknown quantity at this point 
Solved Threads: 0
axxouk axxouk is offline Offline
Newbie Poster

Re: Oracle SQL Plus Joining

 
0
  #4
Dec 2nd, 2008
I need help with joing two tables to get the results which is the author name and what booked he borrowed
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the Oracle Forum
Thread Tools Search this Thread



2009predictions acquisition amazon.com bartz bernanke cia citrix cloudcomputing crm database dell economy editor enterprise enterprise2.0 enterprisesoftware federalreserve forbes hp ibm intellipedia internet larryellison layoffs linux loughridge mediawiki michaeljackson microsoft neverland nortel notebooks oil operatingsystem oracle palm rimm saas salesforce sap seagate socialcomputing sql sun sybase technologystocks virtualiron virtualization vmware wiki wikipedia xen yahoo zoho
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC