For sorting we use order by clause in select statement. This is used to sort data in ascending order or descending order.
To group data based on perticulr column we use groupby clause.
Both are used to get distinct values.
What are the error tables in OM?
Tell me where we find the status of order information?
Explain what are the tables of auto invoice?
What is count(*) from po_vendors(any table)? What does it do andWhat is count(1) from po_vendors(any table)?What is count(0) from po_vendors(any table)the out put is same what is the difference?
What is the difference between request group and request security group in oracle apps?
Suppose for report i have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is less then it must shows some error how we will make?
Tell me how to find the custom directory in front end?
i have 3 parameters like p1,p2,p3. In p1 i have 2 parameters like a,b.if pass parameter a p2 should be enable and p3 should be disable then if pass parameter b the vice versa?
How to Create a purchase order without a requisition?
There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
