Re: Java classes

Well, that was a purposedly stupid script whose sole purpose was to illustrate longname/shortname and here is the longname equivalent excerpted from the same section of the book.

SQL> col DBMS_JAVA.LONGNAME(OBJECT_NAME) format a45 SQL> select dbms_java.longname(object_name), object_type, status from user_objects

          where object_type not in ('TABLE', 'VIEW', 'INDEX') and
          dbms_java.longname(object_name) like '%LongNameSample'
          order by dbms_java.longname(object_name)

Kuassi

kuassi.mensah_at_gmail.com wrote:
> Vladimir M. Zakharychev wrote:
> >> Hmm... Have you tried this query yourself? ;)
>
> Yes indeed, see the query and the return in section 2.1.9 in my book
> fwiw, here is the script for creating the java class
>
> SQL>CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED LongNameSample AS
> package longnamepkg.subpackage.foo;
> class LongNameSample {
> public static void main (String argv[]) {
> System.out.println ("Hello LngNameSample");
> }
> }
> /
>
> >You probably meant something like this:
> >
> > col java_short_name format a30
> > select
> > dbms_java.shortname(object_name) java_short_name
> > ,object_type
> > ,status
> > from user_objects
> > where object_type like 'JAVA%'
> > and dbms_java.LONGNAME(object_name) = 'my/package/MyClassName'
> > -- alternatively:
> > -- and dbms_java.longname(object_name) like '%MyClassName'
> >
> > Regards,
> > Vladimir M. Zakharychev
> > N-Networks, makers of Dynamic PSP(tm)
> > http://www.dynamicpsp.com
Received on Wed Dec 06 2006 - 10:46:58 CST