Home » SQL & PL/SQL » SQL & PL/SQL » join (oracle 9i)
join [message #426606] Fri, 16 October 2009 23:19 Go to next message
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
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
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.

Re: join [message #426615 is a reply to message #426606] Sat, 17 October 2009 01:30 Go to previous message
Michel Cadot
Messages: 65088
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.

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

Current Time: Wed Jul 26 00:02:56 CDT 2017

Total time taken to generate the page: 0.11358 seconds