Is there any possibility that the number for parameter mentioned in procedure to take exactly 6 number not less than 6 and more than 6 exactly 6 should accept ,can we control that in the value set???
@@oratrainings one more doubt ,actually by entering data by clients in flexfields ,it will store data into table , but they will enter twice that make an error by single query fetching more than one .So in order to avoid i can manage it in procedure but i have to change so many places.But my question is Is there any possibility to avoid double entries without oaf but only by controlling value set
If i have only plsql query and need to create concurrent program and expect output in excel format then i need to create executable or else only define the program?
How can I make one concurrent program run only one at a time based on specific parameter either through pl/SQL or through Front end.
Is there any possibility that the number for parameter mentioned in procedure to take exactly 6 number not less than 6 and more than 6 exactly 6 should accept ,can we control that in the value set???
Yes, it is possible, conditionally you can control concurrent program parameters
@@oratrainings one more doubt ,actually by entering data by clients in flexfields ,it will store data into table , but they will enter twice that make an error by single query fetching more than one .So in order to avoid i can manage it in procedure but i have to change so many places.But my question is Is there any possibility to avoid double entries without oaf but only by controlling value set
If i have only plsql query and need to create concurrent program and expect output in excel format then i need to create executable or else only define the program?
You need both Executable And Program
@@oratrainings but i dont have package or procedure so how executable will be created?
@@supriyakhandave5479 so you just have SQL Query, then the conc executable should be of type : SQL*Plus