Home » SQL & PL/SQL » SQL & PL/SQL » join (oracle 9i)
join [message #426606] Fri, 16 October 2009 23:19 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
Table1 Table2
Column A Column B
1 1
2 ->this is Null Value
3 5
4 4

How can we get the output like this
A B
1 1
2 ->this is Null Value
4 5
Re: join [message #426611 is a reply to message #426606] Sat, 17 October 2009 00:42 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Is there any rule, to get required output?
And explain scenario in more detail.

regards,
Delna
Re: join [message #426615 is a reply to message #426606] Sat, 17 October 2009 01:30 Go to previous message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Explain the rule.
Post a working Test case: create table and insert statements along with the result you want with these data.
Read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version with 4 decimals.

Regards
Michel
Previous Topic: nested materialized views
Next Topic: job name in DBMS_SCHEDULER.CREATE_JOB
Goto Forum:
  


Current Time: Thu Sep 29 05:36:49 CDT 2016

Total time taken to generate the page: 0.11048 seconds