Hi all,

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



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

Answer / 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

More Oracle Apps Financial Interview Questions

what is the importance of below three profile options? 1.HR Business group 2.HR User type 3.HR Security

3 Answers   Genesis,


What Move/Merge Does ?

2 Answers  


What is the way in which a Trial Balance of a company be loaded into Oracle; assuming that there are no sub-ledger transactions to be loaded?

1 Answers  


What is the meaning holding tax?

0 Answers  


what is the use of below profile options while configure multiorg? 1. HR: Security Profile 2. MO: Security Profile 3. GL Set of books name 4. MO: Operating Unit 5. HR: User type

4 Answers   IBM,






What are the pre-requisites for an AP Invoice line to move to FA module?

3 Answers  


What is an ERS

3 Answers   IBM,


what is the use of Allow amortized changes in fixed assets

4 Answers  


if you are not having a cashmanagement module how to reconcile or how to clear the transactions?

2 Answers   Genpact,


What is the difference between Secondar ledger and Reporting Currency Ledger.

3 Answers   4i Apps,


Why Retained Earning Account is necessary for the set of book creation while implementing oracle new business.

4 Answers  


How to open the new future periods in GL while we are in P2P or in O2C

1 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)