what is count(*) from po_vendors(any table)? what does it do
and
what 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

Answer Posted / koti

Not For above Qution..........

Q)How to fine How many coloumns in the APPs TABLES ?

Ans):-

select count(*) from dba_tab_columns
where table_name ='give apps table name';

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

1640


What are the different components of soa suite?

713


where to define interorganization transaction charges and what are the different options?

1942


What is instead of trigger in where we will use?

670


How can you achieve loose coupling in soa framework?

713






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 lessthen it must shows some error how we will make?

622


In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

2455


CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2083


Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

1680


how can i print random rows in plsql table

1926


what is pay run id ?

1704


List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

1793


Do you know what is applysys in oracle application database schema, what is apps?

666


Can you explain the difference between architecture followed in 10g & 11g?

650


What are the Standard Reports and Forms in HRMS?

1764