Home » SQL & PL/SQL » SQL & PL/SQL » Function Name ? (Window XP)
Function Name ? [message #601303] Tue, 19 November 2013 07:14 Go to next message
sahnra
Messages: 39
Registered: November 2013
Location: India
Member
which function is used to generate data:

All the data from Table A and from Table B only that data which is not matching from Table
A

[Updated on: Tue, 19 November 2013 07:16]

Report message to a moderator

Re: Function Name ? [message #601305 is a reply to message #601303] Tue, 19 November 2013 07:19 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
FUNCTION can only return a scalar
Re: Function Name ? [message #601306 is a reply to message #601305] Tue, 19 November 2013 07:23 Go to previous messageGo to next message
sahnra
Messages: 39
Registered: November 2013
Location: India
Member
ok BlackSwan, So what else I can do in this case
Re: Function Name ? [message #601308 is a reply to message #601306] Tue, 19 November 2013 07:25 Go to previous messageGo to next message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
Your question is very vague, but I have a feeling that you are looking for an outer join.
You really need to start putting more effort into how you ask questions.
Re: Function Name ? [message #601309 is a reply to message #601308] Tue, 19 November 2013 07:31 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Previous Topic: Date Format
Next Topic: synonym deadlock
Goto Forum:
  


Current Time: Fri Apr 19 08:32:50 CDT 2024