7 Replies Latest reply on Aug 29, 2008 12:07 PM by happy10319

    PSPRCSRQST table column definition

    happy10319
      Hi,
      where can I find PSPRCSRQST table column definition ?
      Thank you.
        • 1. Re: PSPRCSRQST table column definition
          Nicolas Gasparotto
          I'm not sure to understand trhe question as well, but you could check the table on the database side :
          desc PSPRCSRQST 
          Or with in the Application Designer, open the record definition according to the table you want to check.

          Nicolas.
          • 2. Re: PSPRCSRQST table column definition
            happy10319
            Thank you Nicolas. I'm looking for something like this :
            http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/ch289.htm#84294
            1.     ALL_TAB_PRIVS 
            ALL_TAB_PRIVS lists the grants on objects where the user or PUBLIC is the grantee. This view does not display the OWNER column. 
            2.     Related views:
            •     DBA_TAB_PRIVS lists all grants on all objects in the database. This view does not display the TABLE_SCHEMA column. 
            •     USER_TAB_PRIVS lists grants on all objects where the current user is the grantee. This view does not display the TABLE_SCHEMA column. 
            Column      Datatype      NULL      Description 
            GRANTOR      VARCHAR2(30)      NOT NULL      Name of the user who performed the grant 
            GRANTEE      VARCHAR2(30)      NOT NULL      Name of the user to whom access is granted 
            OWNER      VARCHAR2(30)      NOT NULL      Owner of the object 
            TABLE_SCHEMA      VARCHAR2(30)      NOT NULL      Schema of the object 
            TABLE_NAME      VARCHAR2(30)      NOT NULL      Name of the object 
            PRIVILEGE      VARCHAR2(40)      NOT NULL      Privilege on the object 
            GRANTABLE      VARCHAR2(3)            YES if the privilege was granted with ADMIN OPTION; otherwise NO 
            Regards.

            Edited by: user522961 on Aug 26, 2008 4:35 AM

            Edited by: user522961 on Aug 26, 2008 4:36 AM
            • 3. Re: PSPRCSRQST table column definition
              Nicolas Gasparotto
              You have more than one way :
              1. you have an access to the support website, then you could be able to read some datamodel
              2. you are able to connect to Application Designer, so open the record, and see the columns' description
              3. you are able to connect onto the db, so you could run the following query :
              break on recname, descrlong
              select d.recname,
                     d.descrlong,
                     b.fieldnum,
                     b.fieldname,
                     case c.fieldtype when 0 then 'Character'
                                      when 1 then 'Long Character'
                                      when 2 then 'Number'
                                      when 3 then 'Signed Number'
                                      when 4 then 'Date'
                                      when 5 then 'Time'
                                      when 6 then 'Date Time'
                                      when 8 then 'Image'
                                      when 9 then 'Image reference'
                                      else 'N/A' end type,
                     c.length,
                     a.shortname
              from   psdbfldlabl a, psrecfield b, psdbfield c, psrecdefn d
              where  d.recname   = 'PSPRCSRQST'
              and    d.recname   = b.recname
              and    nvl(trim(b.label_id),b.fieldname)  = a.label_id
              and    b.fieldname = a. fieldname
              and    a.fieldname = c. fieldname
              order by fieldnum;
              Nicolas.
              • 4. Re: PSPRCSRQST table column definition
                Nicolas Gasparotto
                Maybe better query
                select d.recname, 
                       d.descrlong,
                       b.fieldnum,
                       b.fieldname,
                       case c.fieldtype when 0 then 'Character'
                                        when 1 then 'Long Character'
                                        when 2 then 'Number'
                                        when 3 then 'Signed Number'
                                        when 4 then 'Date'
                                        when 5 then 'Time'
                                        when 6 then 'Date Time'
                                        when 8 then 'Image'
                                        when 9 then 'Image reference'
                                        else 'N/A' end type,
                       c.length,
                       a.shortname
                from   psdbfldlabl a, psrecfield b, psdbfield c, psrecdefn d
                where  d.recname   = 'PSPRCSRQST'
                and    d.recname   = b.recname
                and    nvl(trim(b.label_id),b.fieldname)  = a.label_id
                and    b.fieldname = a. fieldname
                and    a.fieldname = c. fieldname
                order by fieldnum;
                Nicolas.
                • 6. Re: PSPRCSRQST table column definition
                  Nicolas Gasparotto
                  Is it helpful or correct answer ?
                  ;-)

                  Nicols.
                  • 7. Re: PSPRCSRQST table column definition
                    happy10319
                    it is correct thank you.