Hi all,

what are the mandatory sql/plsql commands functional consultant need to know, let me know please.....

Answer Posted / newbie

I would say basic select statement to query some data from base table , knowledge of various types of Joints( Inner/Outer ) , ability to convert data into specific format Like ( YYYY/MM/DD HH:MM:SS ) , truncate , delete

I think if you know these command you should be fine . I think w3schools is a good place to learn it

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Re: While you are in implemenation what are u faced the issues ? tell me what some ap & GL issues?

1959


Recurring Problem Posting i have Journals for sep 2018 that i approved but they are not available to post even though the period is open in Oracle R12 Issues

1265


Explain Customer Creation and Maintenance Process. Provide samples of customer master records with Payment Terms.

1784


Explain Customer Creation and Maintenance Process. Provide samples of customer master records with Payment Terms.

2568


what is the steps to customization ?

1914






How to refund for a customer who returns goods and wants a refund for $600 in R12 In above scenarios customer does not want Credit Memo or On- Account Credit, he wants refund check . and as we know we do not issue check from AR. How can we issue Check from AP and how offsetting is done for the same in R12

6565


can we define 2 different currency revaluation at a time??

1906


What is meant RD020

478


What kind of necessary ap information you gather from the client?

641


How do write a discoverer report to identify zero dollar suppliers/invoices where the supplier is on hold?

2317


What is the Invoicing System in Oracle R12

946


difference between tds and income tax (India)

1379


What are register in India localisation?

1578


What is gap analysis, how do you defined?

649


There is employee X and employee Y (who is supervisor of X); when Y submits expenses how will the system ensures that this should not go to X even if he has the approval authority.

4321