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 difference between initial mass copy and periodic mass copy?

1 Answers   BirlaSoft, Cap Gemini, IBM,


R there any setups to change the source while entering Journals manually? The defaulted one is manual and the box is greyed out, how can i change the source?

1 Answers   Pfizer,


how to load ap invoice from legacy to our system and should show the paid invoice as paid and un paid as unpaid

3 Answers   Accenture, SDF,


What Are Important Reports In AP,AR?

3 Answers   Wipro,


In Oracle GL how to review the accounts associated with the financial statements?

1 Answers  






What is the difference between Currency Translation, conversion and revaluation?

2 Answers   Oracle,


How can we Integrate AP,AR,CM & FA to GL? What is the procedure need to fallow as a functional consultant?

2 Answers   Genesis,


in payable module mandatory setup.

1 Answers  


Hi, I actually finished my oracle financials R12 course recently and am planning to attend an interview next week...so can any one help me with some of the important interview questions? I am actually keeping 2 yrs fake exp....

1 Answers  


What is the difference between Standard Remittance and Factoring Remittance?

1 Answers   TCS,


What is the difference between data converson and data migration

3 Answers   ABC, TCS,


1)I created business group and assigned profile classes in responsibility level, now my question is in GL add operting units page my BG not appering but VISION CORPORATIONS is coming. 2)in purchasing >financial options under human resource tab My BG is not coming but VISION CORPORATION is coming. How to solve this two.

1 Answers   NTT Data,


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)