You Will Never Get Stuck Again!
This promise is immense; every day and every night, we are trying our best to fulfill it by helping others, leaving something worthwhile behind us, and living for a purpose that is "Enrich & Spread knowledge everywhere".
Join 15000+ Exceptional
Latest Python Wiki's
Python isdigit vs isnumeric vs isdecimal
Python deals with a wide variety of data types. This includes numbers, strings, objects, etc. We generally treat the digits, numerals, and decimals as different names of the same entity. However, in Python, there are significant differences between ...
Python Program to Check Prime Number using While Loop
Prime numbers are an essential concept in mathematics and computer science. They are numbers that are only divisible by 1 and themselves. In this article, we will explore the concept of prime numbers and learn how to write ...
Unable To Finally Close Purchase Ordes or Blanket Releases Because of Error: APP-PO-14160
While reversal amounts are calculated, the Final_amt field is updated. This can be null when final_amt is already null. you can refer to Document : Doc ID 1990193.1 to find the solution.
While reversal amounts are calculated, the Final_amt field is updated. This can be null when final_amt is already null.
you can refer to Document : Doc ID 1990193.1 to find the solution.
See lessIs it Possible to Migrate Blanket PO’S in Closed Status Like Standard PO’S?
Hi, Where you need to migrate exactly ? and if their status's is closed why you need them ? Regards.
Hi,
Where you need to migrate exactly ? and if their status’s is closed why you need them ?
Regards.
See lessrep-14015 : beforereport unkhown user exit fnd ?
The USER EXITS are specific to Applications. Try to check the report in builder by commenting those srw exits
The USER EXITS are specific to Applications. Try to check the report in builder by commenting those srw exits
See lessHow to remove duplicate rows by where condition ?
you can use : [code] SELECT * FROM test_table WHERE number_col NOT IN (SELECT number_col FROM test_table GROUP BY number_col HAVING count (*) > 1) [/code]
you can use :
[code]
See lessSELECT *
FROM test_table
WHERE number_col NOT IN (SELECT number_col
FROM test_table
GROUP BY number_col
HAVING count (*) > 1)
[/code]
Fatal Error EXCEPTION ACCESS VIOLATION (0xc0000005) when trying to run WEB (PIA) Server
this may be because of java compatibility, so try to delete all the Java files and cleaned the %PATH% and installed it again.
this may be because of java compatibility, so try to delete all the Java files and cleaned the %PATH% and installed it again.
See lessWould you use flashback query to synchronize two schemas as of a certain point in time?
there is two options here : a) use serializable or read only isolation - the database would be consistent. b) use flashback query themselves - mandate that you set undo_retention to "X" and then they can just flashback and get a read consistent version of the database back "X" units in time. anythinRead more
there is two options here :
a) use serializable or read only isolation – the database would be consistent.
b) use flashback query themselves – mandate that you set undo_retention to “X” and then they can just flashback and get a read consistent version of the database back “X” units in time.
anything else does not really make sense. To synchronize the two scheme’s (using flashback) would mean a big bump and grind – AND – would prove that the data they need is flashback queryable – meaning, they didn’t need to copy it, it already exist.
See lessHow do I append an object to an array in JavaScript?
Use the push() function to append to an array:[code]// initialize array var arr = [ "Adam", "panju", "keri" ];// append new value to the array arr.push("oraask");console.log(arr);[/code]Will print["Adam", "panju", "keri", "oraask"]
Use the push() function to append to an array:
[code]// initialize array
var arr = [
“Adam”,
“panju”,
“keri”
];
// append new value to the array
arr.push(“oraask”);
console.log(arr);[/code]
Will print
See lessHow to to check old and new values for item in Oracle Form ?
to get the database value there is one property (database_value) and here is the example to achieve this: [code] BEGIN IF :BLOCK.ITEM = GET_ITEM_PROPERTY('BLOCK.ITEM', database_value) THEN RETURN; END IF; END; [/code] sometimes this property return value (0) if so you can use another way : -take theRead more
to get the database value there is one property (database_value) and here is the example to achieve this:
[code]
BEGIN
IF :BLOCK.ITEM = GET_ITEM_PROPERTY(‘BLOCK.ITEM’, database_value) THEN
RETURN;
END IF;
END;
[/code]
sometimes this property return value (0) if so you can use another way :
-take the value in the pre text item trigger and keep it in global
– as about this value in when validate item trigger and so on
hope this may help you 🙂
See lessHow to return N of rows after ordering in oracle sql ?
You can use a subquery for this like [code] select * from ( select * from emp order by sal desc ) where ROWNUM <= 5; [/code] Starting from Oracle 12c R1 (12.1). there is a syntax available to limit rows or start at offsets (full syntax here) example : [code] SELECT * FROM employees ORDER BY salarRead more
You can use a subquery for this like
[code]
select *
from
( select *
from emp
order by sal desc )
where ROWNUM <= 5;
[/code]
Starting from Oracle 12c R1 (12.1). there is a syntax available to limit rows or start at offsets (full syntax here)
example :
[code]
SELECT *
FROM employees
ORDER BY salary
OFFSET 20 ROWS FETCH NEXT 10 ROWS ONLY;
[/code]
hope this helpful 🙂
See lessHow to create ArrayList from array in Java ?
you can use :[code]List<Integer> intList = new ArrayList<Integer>(Arrays.asList(a));[/code]
you can use :
[code]
See lessList<Integer> intList = new ArrayList<Integer>(Arrays.asList(a));
[/code]