Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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?

2380


Do you track and record relationships between customers e.g. franchises, subsidiaries etc.?

2116


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

7386


I have created an invoice and made the payment in Accounts payable. Now the payment status is Negotiable and accounting status is processed. I reconciled the transaction in Cash Mgmt, The status changed from negotiable to Reconciled in CM. I checked the payment status for the invoice in payment window(AP), the payment status changed to RECONCILED UNACCOUNTED i.e correct but the accounting status is remain processed which is not the correct. I hope the transaction will be correct if the accounting status would have changed to PERTIAL . Please suggest any solution for the above query.

5316


What is the Invoicing System in Oracle R12

1417


how service tax work.

2396


I am working on PPR process to print checks. Currently the checks are printing for each supplier, supplier site and payment method group. My requirement is the invoice level one DFF is available (like A and B are the input values). Please let me know how include this DFF at invoice grouping level.

1627


How will account an advance of Rs.10000/- which is a permanent prepayment, can I make payment for this?

1384


What is automation of accounts payable activities (evaluated receipt settlement)?

1251


What is the use of operating unit, while configure multiorg?

1114


1.what is the name of program to create invoice automatic from po.? 2.How to auto upload the bank statement? 3.PO tax has not flown to invoice . why? Debit memo not generated for return of goods.??

3463


What is the meaning holding tax?

1101


How do you adjust receivables?

2180


Can Adjustments be imported?

2139


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

2324