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

How many views are generated when compiling flexfield structure ?

1 Answers   Oracle,


What could be the probable reason for Not Showing the Taxes in Project Draft Invoices?

1 Answers  


what is value set

4 Answers  


What is the difference between data converson and data migration

3 Answers   ABC, TCS,


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

3 Answers  


Do you receive deposits and/or prepayments?

3 Answers  


As Supplier Header Information can share from another operating unit. Not Sites and other information...... but for a supplier if one OU(1) has made a prepayment..and other OU(2) of the same balancing segment has to make a payment to the same supplier..the prepayment available with that supplier is overlooked or not considered….is it true

1 Answers  


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

2 Answers   Genpact,


1.what is difference between (New feature) 11i & R12 for Receivable, Fixed asset, GL, Payables.? 2.How was your previous company segment qualifier was defined.? 3. How many segment qualifier? 4. How the intracompany transaction take place.?

1 Answers   L&T, TTN,


What is the use of auto create?

2 Answers  


Difference between header level tax calculation and line level tax calculation

0 Answers   IBM,


What's the difference between cross validation rules and security rules?

6 Answers   IBM, Syntel,


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)