Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> plsql

plsql

From: Ken Chesak <datavector_at_hotmail.com>
Date: 18 Jun 2002 12:02:13 -0700
Message-ID: <3f2f39c4.0206181102.4e47dc85@posting.google.com>


Following SQL produces these results.

 select table_name,grantee,PRIVILEGE

  from USER_tab_privs a
  where a.table_name = 'BEER_CLIENT'
 order by table_name

TABLE_NAME                     GRANTEE                        PRIVILEGE

------------------------------ ------------------------------ ------------------
----------------------
BEER_CLIENT IWS_WEB_DEV INSERT BEER_CLIENT IWS_WEB_DEV SELECT BEER_CLIENT IWS_WEB_DEV UPDATE BEER_CLIENT IWS_WEB_DEV DELETE

I would like SQL which produces one row as follows,

BEER_CLIENT IWS_WEB_DEV INSERT SELECT UPDATE DELETE Oracle 8.1.7 thanks Received on Tue Jun 18 2002 - 14:02:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US