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 r the validations we will do in Customer Interface

3 Answers   Fidelity,


I hv done revaluation corectly even got the result also but why report showing in warning mode in view window after refreshing ?

2 Answers  


What is Proxima Payment Terms?

4 Answers   HCL, IBM, TCS,


Payment Methods?

5 Answers  


Please let me know the various accounting entries in AP & AR for a layman. Like invoice posting, payment, offset entries, exchange fluctuation entries, i am preparing for an interview. PLEASE HELP

4 Answers   Oracle,


what is $flex used in oracle apps ?

5 Answers   iFlex,


Which interface tables are used for Invoice Import , give the important columns?

1 Answers   HCL, IBM, TCS,


What is Difference between Auto Copy Journal and recurring journal?

0 Answers   Evo Tech,


I am created credit memo in at but while trying to complete it showing error message-hz_party_location

0 Answers   Sonata,


payment types and payment methods.

0 Answers  


in Oracle Payable s we are not matching Po how to clear accrual account in P2p cycle?

1 Answers   Hitachi,


Describe the key configuration decisions you would need to undertake when implementing the cash management module?

1 Answers   Wipro,


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)