Archives

Filter:AllOpenResolvedClosedUnanswered
What are the advantages of using %TYPE and %ROWTYPE in PL/SQL?
ResolvedQuestions Master asked 9 years ago • 
6166 views0 answers0 votes
A table is uploaded with partial number of records and then a table is created without using a commit on the previous table. How many records do we find in a different session?
ResolvedAnonymous asked 9 years ago • 
1611 views0 answers0 votes
how to Call Fast Formula from PL/SQL
ResolvedAnonymous asked 9 years ago • 
4114 views0 answers0 votes
Lets say there is a table with 500 rows. Write a query to display rows from 101 to 500.
ResolvedAnonymous asked 9 years ago • 
2906 views0 answers0 votes
Query to find records inserted in last 2 hours
ResolvedAnonymous asked 9 years ago • 
14593 views0 answers0 votes
How to display the GL Periods in order (like Jan,Feb,Mar…..)
ResolvedAnonymous asked 9 years ago • 
4463 views0 answers0 votes
What is Available to Reserve & Available to Transact??
ResolvedQuestions Master asked 9 years ago • 
2983 views0 answers0 votes
Can we use RETURN STATEMENT and RETURN key word in Procedure, if we use what will happen?
ResolvedQuestions Master asked 9 years ago • 
4605 views0 answers0 votes
What is Multi Org in Oracle Apps?
ResolvedQuestions Master asked 9 years ago • 
2932 views0 answers0 votes
What is Multi Org Flow in Oracle Apps?
ResolvedQuestions Master asked 9 years ago • 
2938 views0 answers0 votes
How do you create a table validated value set dependent on another value set?
ResolvedQuestions Master asked 9 years ago • 
9624 views0 answers0 votes
How to ensure that only one instance of a concurrent program runs at a time?
ResolvedQuestions Master asked 9 years ago • 
3472 views0 answers0 votes
How to submit a concurrent request directly from the operating system(unix)?
ResolvedQuestions Master asked 9 years ago • 
2487 views0 answers0 votes
How to generate a trace file for a PL/SQL based concurrent program?
ResolvedQuestions Master asked 9 years ago • 
4116 views0 answers0 votes
How to "write" to the concurrent request Log and Output?
ResolvedQuestions Master asked 9 years ago • 
5046 views0 answers0 votes
AP module
ResolvedAnonymous asked 9 years ago • 
1506 views0 answers0 votes
Flexfeilds
ResolvedAnonymous asked 9 years ago • 
1592 views0 answers0 votes
List all different types of Data Types in PL/SQL?
ResolvedQuestions Master asked 9 years ago • 
3967 views0 answers0 votes
What is %TYPE and %ROWTYPE in PL/SQL??
ResolvedQuestions Master asked 9 years ago • 
4137 views0 answers0 votes
What is the disadvantage of using %ROWTYPE in PL/SQL?
ResolvedQuestions Master asked 9 years ago • 
4831 views0 answers0 votes
What is difference between % ROWTYPE and TYPE RECORD?
ResolvedQuestions Master asked 9 years ago • 
8506 views0 answers0 votes
What are the Disadvantages of Cursor Variables?
ResolvedQuestions Master asked 9 years ago • 
4444 views0 answers0 votes
What is Cursor Variables or REF CURSOR ?
ResolvedQuestions Master asked 9 years ago • 
4121 views0 answers0 votes
Can we write When OTHERS Exception at the beginning of the exception block and some other exceptions after that ?
ResolvedQuestions Master asked 9 years ago • 
3620 views0 answers0 votes
Is it mandatory to close the Cursor in a PL/SQL block ?
ResolvedQuestions Master asked 9 years ago • 
4089 views0 answers0 votes
What is the different between Analytic and Group function in SQL?
ResolvedQuestions Master asked 9 years ago • 
4478 views0 answers0 votes
How to find SQL statements which takes more time to run on Database?
ResolvedQuestions Master asked 9 years ago • 
2978 views0 answers0 votes
What is the purpose of WHERE CURRENT OF statement in PL/SQL?
ResolvedQuestions Master asked 9 years ago • 
3790 views0 answers0 votes
How to avoid usage of Cursors in PL/SQL?
ResolvedQuestions Master asked 9 years ago • 
3821 views0 answers0 votes
What is BULK COLLECT in PL/SQL?
ResolvedQuestions Master asked 9 years ago • 
5696 views0 answers0 votes
What is Workflow Background Process?
ResolvedQuestions Master asked 9 years ago • 
1448 views0 answers0 votes
How is Workflow Background Process called from both back end and front end?
ResolvedQuestions Master asked 9 years ago • 
4258 views0 answers0 votes
Why should Workflow Background Process be scheduled to run in frequent intervals?
ResolvedQuestions Master asked 9 years ago • 
1471 views0 answers0 votes
In workflows, assume you have two different notifications and upon approval from both the notifications certain action should be performed. How do you achieve this?
ResolvedQuestions Master asked 9 years ago • 
1245 views0 answers0 votes
What is ITEM TYPE in workflows?
ResolvedQuestions Master asked 9 years ago • 
1963 views0 answers0 votes
What is Item Key in Workflows?
ResolvedQuestions Master asked 9 years ago • 
2919 views0 answers0 votes
What is Logical Apps in brief ???
ResolvedQuestions Master asked 9 years ago • 
2446 views0 answers0 votes
how to find out table name and column name of OAF page in apps
ResolvedAnonymous asked 9 years ago
5741 views0 answers0 votes
What is Diagnostics in Oracle Apps??
ResolvedAnonymous asked 9 years ago • 
3273 views0 answers0 votes
Name any 5 PL/SQL exception types
ResolvedQuestions Master asked 9 years ago • 
5388 views0 answers0 votes
123…5