Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
Which one do better performance NOT IN vs NOT EXISTS ?
Hi @Maran Firstly It’s not about the difference in performance only because they are not the same when dealing with nulls in the data. for example, we want to check how many employees are not managers of other employees by using NOT IN SELECT COUNT (*) FROM EMPLOYEES WHERE EMPLOYEE_ID NOT IN (SELECTRead more
Hi Maran Firstly
It’s not about the difference in performance only because they are not the same when dealing with nulls in the data.
for example, we want to check how many employees are not managers of other employees by using NOT IN
the result will be :
This means all employees are managers in this case.
let’s then take the same example but using NOT EXISTS
the result will be :
So here, out of 101 employees, there are 89, not managers.
The most crucial thing is NULL represented in the manager_id column for the first employee 101 (Steven King). So wherever null is there while using NOT IN or IN, the evaluation of the inner query will be either FALSE or NULL and will return no records.
So now, when it comes to performance, it depends on the amount of data that both subquery and the outer query returns. If they are small, then IN is typically more appropriate. And vise versa. But remember, we have assumed that there are no nulls in the subquery result.
Regards
See lessHow to select a random row in SQL& MySQL?
Hi Sam I don't know what the case you need this to, but anyway you can use the following query to get random row from employees table as an example. 1- Oracle : SELECT * FROM (SELECT * FROM EMPLOYEES ORDER BY DBMS_RANDOM.VALUE) WHERE ROWNUM = 1 2- MySQL : SELECT column FROM table ORDER BY RAND() LIMRead more
Hi Sam
I don’t know what the case you need this to, but anyway you can use the following query to get random row from employees table as an example. 1- Oracle :
2- MySQL :
The idea here in both examples is to get all rows in employees table but in random orders then using ROWNUM in Oracle and LIMIT clause in MySQL to return one row from them.
See lessHow to use COMMIT or ROLLBACK inside database trigger ?
Hello @albert Actually we cannot do commit or rollback inside a database trigger, because the trigger is an extension of a DML statements (Insert & Update & Delete). So the changes happened inside trigger should be committed or rollbacked as part of the original transaction. So if you are trRead more
Hello albert
Actually we cannot do commit or rollback inside a database trigger, because the trigger is an extension of a DML statements (Insert & Update & Delete). So the changes happened inside trigger should be committed or rollbacked as part of the original transaction.
So if you are traying to do commit inside the trigger you will get clear exception which is :
See lessHow to loop through VO View Object in OAF?
Hello @Chandra, To iterate through a VO in OAF by either RowSetIterator and then loop through it to fetch attributes value, or using FilteredRows this will give us an advantage of getting only rows that meets a particular condition, or using RowQualifier this is similar to FilteredRows but insteadRead more
Hello Chandra,
To iterate through a VO in OAF by either RowSetIterator and then loop through it to fetch attributes value, or using FilteredRows this will give us an advantage of getting only rows that meets a particular condition, or using RowQualifier this is similar to FilteredRows but instead of typing the condition using VO attribute, we are write normal SQL condition.
Now let’s see an example using the first option:
See lessHow To store WHO Column values In new custom forms ?
Hello @Beter, To set who columns in a new custom form in oracle apps you have to follow this two basic steps: 1- you have to have the who columns which is (CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_DATE and LAST_UPDATE_LOGIN) first created on the table whose your database block is based oRead more
Hello Beter,
To set who columns in a new custom form in oracle apps you have to follow this two basic steps:
1- you have to have the who columns which is (CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_DATE and LAST_UPDATE_LOGIN) first created on the table whose your database block is based on.
2- Call fnd_standard.set_who; on (pre-insert & pre-update) triggers on block level.
That’s it.
See lessHow to get the length of a list in Python?
len() function is used to get the length of a list in python Consider we have a list of numbers like this: numberList=[1,3,4,5,7] So to get the length we can use len(numberList) And the result will be : 5 elements in the list
len() function is used to get the length of a list in python
Consider we have a list of numbers like this:
So to get the length we can use
len(numberList)And the result will be : 5 elements in the list
See lessHow to concatenate strings in Python?
Hi @Rain, To concatenate strings in Python we have to use " + " operator ex : 'Oraask' + '.com' hope that help.
Hi Rain,
To concatenate strings in Python we have to use ” + ” operator
ex : ‘Oraask’ + ‘.com’
hope that help.
See lessHow To Enable OAF Personalization In Oracle APPS R12
Hello Maram, To enable personalization link on OAF pages in Oracle EBS you have to set these system profile options with corresponding values : Profile Name Value FND: Personalization Region Link Enabled Yes Personalize Self-Service Defn Yes Disable Self-Service Personal No Hopefully this will helpRead more
Hello Maram,
To enable personalization link on OAF pages in Oracle EBS you have to set these system profile options with corresponding values :
Hopefully this will help you. Regards
See lessHow to grant read and write on directory in oracle ?
To give a particular user permission on oracle directory we can use the following commands: — Grant read permission to oraask user GRANT READ on DIRECTORY &directory_name to oraask; — Grant write permission to oraask user GRANT WRITE on DIRECTORY &directory_name to oraask; — Grant read/writeRead more
To give a particular user permission on oracle directory we can use the following commands:
— Grant read permission to oraask user
— Grant write permission to oraask user
— Grant read/write permissions to oraask user at one command
Hope this helpful.
API to update AR invoice in oracle apps R12?
Hello @matheo, Unfortunately this functionality doesn't exist until now. There is no Public API available from Oracle to update AR invoice. And regarding the API you mentioned in your question it's not the correct API, and please don't use it because basically it's not public and official released fRead more
Hello matheo,
Unfortunately this functionality doesn’t exist until now. There is no Public API available from Oracle to update AR invoice.
And regarding the API you mentioned in your question it’s not the correct API, and please don’t use it because basically it’s not public and official released from oracle as per this Doc ID 1388129.1.
The only way for now to update AR transaction is to perform this action from application specifically from transaction workbench.
Hope That will help you.
Best Regards.
See less