oracle - Need a fix for merge update query (Simple but still confusing) -

- 

  तालिका में एक प्रयोग करें (तालिका 2 से चुनें *) b चालू (a.row_id = b.row_id और a .in_correct IS NULL) जब मिलान किया गया था तो सेट करें a.in_correct = 'Y';   
 उपर्युक्त प्रश्न में ओआरए -38104: स्तंभ पर संदर्भित कॉलम अपडेट नहीं किया जा सकता।  
 मैं इसे सुलझाने के लिए घंटों तक बैठा हूं।  < पी> मैंने यह पहचान लिया है कि समस्या फ़ील्ड में गलत है।  
 यह फ़ील्ड "इनकाओक्ट" दोनों को धारा में और एसईटी के बाद भी नहीं लगाया जा सकता है। लेकिन मेरे मानदंडों को पूरा करने के लिए मेरे पास कोई विकल्प नहीं है।  
 कृपया मेरी मदद करें   
 
 < पूर्व>  तालिका में एक मेजबानी करें (तालिका 2 से चुनें *) b ऑन (a.row_id = b.row_id) जब मिलान की गई एटीसी सेट a.in_correct = NVL (inaccorrect, 'Y');   
 अद्यतन:  
 एक और अधिक "सामान्य" कमांड (गैर शून्य मानों के लिए):  
  तालिका में एक प्रयोग करें (चयन करें SELECT * टेबल से) * बी ऑन (a.row_id = b.row_id) जब मिलान किया गया था तो तयशुदा सेट a.in_correct = मामला जब in_correct = 'valuetobereplaced' और फिर 'वाई'; अन्य गलत; समाप्त;

Comments

Post a Comment

Popular posts from this blog

mysql - BLOB/TEXT column 'value' used in key specification without a key length -

-
I have developed an extension which works up to 1.6 on Magren (I'm trying Enterprise Edition, And I think the community is the same problem, because it is the same code). In my install script, I see the $ installer-> gt; CreateEntityTables ($ this- & gt; getTable ('alphanum / info')); The installation is done until it is not in the _text unit table. It crashed there! It turns out that when I log in to SQL and run it via PHPmyadmin, then this error is: Blob / Text column 'value' is used without the key 'key' . I saw the code there, and this is what is trying to create an index on the value column: -> addIndex ($ this- & gt; getIdxName ($ eavTableName, array ( 'attribute_id array (' attribute_id ',' value ')) - & gt; addIndex ($ this- & gt; getIdxName ($ eavTableName, array (' entity_type_id ' , 'Value')), array ('entity_type_id', 'value')) If there is no if statement is n...
Read more

javascript - What is an alternative to using getElementByClass for hiding multiple elements? -

-
I have a page with some links that I would like to be able to toggle with two buttons. It works with a link using getElementById, but I need to toggle some of those groups. I started with it, but it failed to work. I've heard that GetElementByClass has worked with everything but IE, but I'm using Opera 11.5 and it still does not work. I've searched a bit, but I'm new to some JavaScript and most of the explanation is not understood. Does anyone help me with a simple option, or can I help me fix the problem I've made? This is a test page I was using. & lt; Head & gt; & Lt; Script type = "text / javascript" & gt; Function hideNames () {document.getElementByClass ("WebName"). Style.display = "none"; } Function ShowName () {document.getElementByClass ("WebName"). Style.display = "inline"; } & Lt; / Script & gt; & Lt; / Head & gt; & Lt; Body & gt; & Lt; P class = "web...
Read more

javascript - Making the first column of a table fixed on horizontal scroll -

-
Thanks for reading I have a table inside a divan container (div0). The table is populated with data and is dynamically generated. Therefore, the height and width of the table is not fixed. Both the vertical and horizontal scrolls can be seen to view the entire table in the outer table. Now the requirement is that I need to correct horizontal horizontal form of the first column of the table. When scrolling the horizontal scrollbar, the first column should be fixed and the rest should be skulled. Just some indication on this, how is it necessary to get it? I'm thinking of dividing the first column content in a div (div1) (which is not horizontal scroll), and the second scroll material is in a different divis (div2) both a line and 2 Has been placed in the table with TDS. Now I am getting 2 probes with this approach, 1 when I scroll right, div is going to divulge the scrollbar inside div0 (thinking of using a jquery scrollbut but how it is excluded from div2 ) The second is alig...
Read more