Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DBA_USERS: duplicated rows.
I would know if I can execute newly SQL.BSQ ?
Jerry Gitomer wrote:
> Hi,
>
> When you run the query to display the information from the view concatenate
> each column with leading and trailing special characters so you can see if
> there are any leading or trailing non-printing characters or spaces in the
> names. e.g;
>
> SELECT '&'||owner||'&'||table_name||'&' FROM ....
>
> regards
> Jerry Gitomer
> ---------------------------------------------
>
> Kekko wrote in message <377C6C5D.BA364B25_at_adr.it>...
> >I still continue to have a problem with the dba_users view: it has
> >duplicated rows. I recreated it but the problem isn't resolved. Than I
> >modified the creaption script in the catalog.sql: I specified the select
> >distinct.
> >Oracle 8.0.5
> >Digital UNIX 4.0d
> >Digital Alpha Server 2100
> >
> >Thank you very much.
> >
> >Kekko
> >
> >
Received on Thu Jul 08 1999 - 11:02:49 CDT
![]() |
![]() |