click on the one you want ... The aggregate functions are:
AVG<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions010.htm#i82074> COLLECT<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions020.htm#i1271564> CORR<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions024.htm#i82637> CORR_*<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions025.htm#i1293691> COUNT<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions028.htm#i82697> COVAR_POP<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions029.htm#i1008854> COVAR_SAMP<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions030.htm#i82820> CUME_DIST<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions031.htm#i82886> DENSE_RANK<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions038.htm#i1064409> FIRST<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions048.htm#i1000901> GROUP_ID<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions053.htm#i1002035> GROUPING<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions054.htm#i77498> GROUPING_ID<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions055.htm#i1001964> LAST<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions061.htm#i1000905> MAX<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions075.htm#i89072> MEDIAN<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions076.htm#i1279886> MIN<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions077.htm#i1280029> PERCENTILE_CONT<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions100.htm#i1000909> PERCENTILE_DISC<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions101.htm#i1000913> PERCENT_RANK<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions099.htm#i1043951> RANK<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions108.htm#i1269223> REGR_ (Linear Regression) Functions<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions117.htm#i85922> STATS_BINOMIAL_TEST<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions135.htm#i1279891> STATS_CROSSTAB<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions136.htm#i1333770> STATS_F_TEST<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions137.htm#i1279901> STATS_KS_TEST<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions138.htm#i1279906> STATS_MODE<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions139.htm#i1279911> STATS_MW_TEST<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions140.htm#i1279921> STATS_ONE_WAY_ANOVA<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions141.htm#i1335576> STATS_T_TEST_*<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions142.htm#i1279931> STATS_WSR_TEST<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions143.htm#i1279951> STDDEV<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions144.htm#i89108> STDDEV_POP<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions145.htm#i86639> STDDEV_SAMP<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions146.htm#i86697> SUM<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions148.htm#i89126> VAR_POP<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions195.htm#i87119> VAR_SAMP<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions196.htm#i87169> VARIANCE<http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/functions197.htm#i89144> On Fri, Oct 14, 2011 at 12:23 PM, Sanket Gaikwad <[email protected] > wrote: > no.but i want the code for using agg. function. > eg > suppose there is a button > count students > after clicking on that button it shoe the number of students in the > text field > > On 10/15/11, Michael Moore <[email protected]> wrote: > > Do you have a specific question about PL/SQL? > > > > Mike > > > > On Fri, Oct 14, 2011 at 12:12 PM, Sanket Gaikwad < > [email protected] > >> wrote: > > > >> hi > >> i am doing project using java and oracle > >> for student info. mgmt > >> i want to use aggregate functions which will show the result in the > >> respective filed > >> after click on the button. > >> > >> thnx and regards > >> > >> -- > >> You received this message because you are subscribed to the Google > >> Groups "Oracle PL/SQL" group. > >> To post to this group, send email to [email protected] > >> To unsubscribe from this group, send email to > >> [email protected] > >> For more options, visit this group at > >> http://groups.google.com/group/Oracle-PLSQL?hl=en > >> > > > > -- > > You received this message because you are subscribed to the Google > > Groups "Oracle PL/SQL" group. > > To post to this group, send email to [email protected] > > To unsubscribe from this group, send email to > > [email protected] > > For more options, visit this group at > > http://groups.google.com/group/Oracle-PLSQL?hl=en > > > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en > -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
