thank you On 10/15/11, Michael Moore <michaeljmo...@gmail.com> wrote: > 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 <sanket.gaikwa...@gmail.com >> 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 <michaeljmo...@gmail.com> wrote: >> > Do you have a specific question about PL/SQL? >> > >> > Mike >> > >> > On Fri, Oct 14, 2011 at 12:12 PM, Sanket Gaikwad < >> sanket.gaikwa...@gmail.com >> >> 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 Oracle-PLSQL@googlegroups.com >> >> To unsubscribe from this group, send email to >> >> oracle-plsql-unsubscr...@googlegroups.com >> >> 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 Oracle-PLSQL@googlegroups.com >> > To unsubscribe from this group, send email to >> > oracle-plsql-unsubscr...@googlegroups.com >> > 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 Oracle-PLSQL@googlegroups.com >> To unsubscribe from this group, send email to >> oracle-plsql-unsubscr...@googlegroups.com >> 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 Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > 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 Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
