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 meaning of purchase default and what are the types

0 Answers  


what are the setup from scrap in R12.?

1 Answers   Systems Plus,


Can different SOBs share the same value set?

3 Answers  


What is dynamic insertion ? How to turn off the dynamic insertion ?

8 Answers   Oracle,


While you are in implemenation what are the u issues faced? tell me what some issues?

6 Answers   iFlex, TCS, Tesco,






What is price break and what are the different types of price breaks ?

3 Answers   FIC,


what are the depreciation methods in oracle financials- fixed assets?

2 Answers   HP,


While setting up the cross validation rules is it necessary to enable the SECURITY RULE check box along with CROSS VALIDATION RULE check box in flexfield structure. plz clarify my dt

3 Answers  


What is the Customization? Can any one tell me with examples in Real time scenarios?

1 Answers  


in general ledger it is posiible for reverse entry in any another option ( not reverse tab)

5 Answers  


6. TDS accounting entry

1 Answers   ABC, Arihant,


Why assign balancing segment flex field qualifier in company segment ?

1 Answers   Deloitte,


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)