sql - ORA-01427: single-row subquery returns more than one row- multiple values needed -

-

i have following sql query on oracle 

select    case     when (select distinct(trim(z.m_base_acct))       acc_mapping_rep z       z.m_dyn_acct=b.m_en_credit       , z.m_ref_data  =b.m_ref_data) in 'samanos'     '7200000888001x'    end m_en_crdr   acc_journal_rep b , b.m_ref_data       = 41091 , b.m_en_date        = '21-sep-15' , b.m_entity         = 'ln' , b.m_nb_trn         = 0

i having oracle error ora-01427. due line have case when condition knowing did put in operator instead of equal. please advise. need have multiple values in case condition.

if you've shown have 1 value compare, 'samanos', can swap terms:

select    case     when 'samanos' in (select distinct(trim(z.m_base_acct))       acc_mapping_rep z       z.m_dyn_acct=b.m_en_credit       , z.m_ref_data  =b.m_ref_data)     '7200000888001x'   end m_en_crdr ...

you left-join acc_mapping_rep table, distinct , trim worrying - if needed becomes little more complicated , you'd need left-join inline view of table.

the b.m_en_date = '21-sep-15' worrying; if m_en_date date column you're relying on implicit conversions , session nls settings. better use to_date(), or fixed value date literal: b.m_en_date = date '2015-09-21'.

your original longer code benefit using ansi joins instead of old oracle-specific (+) outer join operator.


Comments

Post a Comment

Popular posts from this blog

Capture and play voice with Asterisk ARI -

-
there channel ari demo in wich can control channel state: ring, answer, play silence, play tone or audio-file ( https://github.com/asterisk/ari-examples/tree/master/channel-state , https://wiki.asterisk.org/wiki/display/ast/ari+and+channels%3a+manipulating+channel+state ) possible receive chunks (parts, buffers, etc.) of call voice (which created remote subscriber) or write chunks of voice, example array of bytes (not file) in audio format (alaw, ulow etc). you can use asterisk eagi interface voice data. other option use record or mixmonitor app record channel(channel have put stasis allow dialplan control ari) "write chunks of voice" can done application playback also can create own application using c/c++, compile asterisk , result want. no, can't redirect voice directly using ari.
Read more

c - Unrecognised emulation mode: elf_i386 on MinGW32 -

-
i'm trying make kernel, , cannot link c output assembly. ld . i'm getting error: unrecognized emulation mode: elf_i386 i'm using windows 10 professional mingw32 , msys. code using: link.ld /* * link.ld */ output_format(elf32-i386) entry(start) sections { . = 0x100000; .text : { *(.text) } .data : { *(.data) } .bss : { *(.bss) } } kernel.c /* * kernel.c */ void kmain(void) { const char *str = "my first kernel"; char *vidptr = (char*)0xb8000; //video mem begins here. unsigned int = 0; unsigned int j = 0; /* loops clears screen * there 25 lines each of 80 columns; each element takes 2 bytes */ while(j < 80 * 25 * 2) { /* blank character */ vidptr[j] = ' '; /* attribute-byte - light grey on black screen */ vidptr[j+1] = 0x07; j = j + 2; } j = 0; /* loop writes string video memory */ while(str[j] != '\0') { /...
Read more

Python : How can I access Lotus Notes 8.5 Inbox to read emails -

-
i want make script in python reads mails lotus notes 8.5 , create each email issue in jira returns me error when try read mails lotus: traceback (most recent call last): file "from_lotus_to_jira.py", line 46, in <module> main() file "from_lotus_to_jira.py", line 39, in main folder = notesdatabase.getview('$inbox') file "c:\python27\lib\site-packages\win32com\gen_py\29131520-2eed-1069-bf5d-00 dd011186b7x0x1x2.py", line 1849, in getview ret = self._oleobj_.invoketypes(1610743866, lcid, 1, (9, 0), ((8, 1),),pname pywintypes.com_error: (-2147352567, 'exception occurred.', (0, u'notesdatabase', u'database server_name!!c:\\users\\myname\\appdata\\local\\lotus\\notes\\data\\ma il202\\myname.nsf has not been opened yet', none, 0, -2147217441), none) here .py file import win32com.client import pywintypes import getpass def main(): # credentials mailserver = 'server_name' mailpath = 'c:\user...
Read more