How do I get column datatype in Oracle with PL-SQL with low privileges?

by

ALL_TAB_COLUMNS should be queryable from PL/SQL. DESC is a SQL*Plus command.

SQL> desc all_tab_columns;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 OWNER                                     NOT NULL VARCHAR2(30)
 TABLE_NAME                                NOT NULL VARCHAR2(30)
 COLUMN_NAME                               NOT NULL VARCHAR2(30)
 DATA_TYPE                                          VARCHAR2(106)
 DATA_TYPE_MOD                                      VARCHAR2(3)
 DATA_TYPE_OWNER                                    VARCHAR2(30)
 DATA_LENGTH                               NOT NULL NUMBER
 DATA_PRECISION                                     NUMBER
 DATA_SCALE                                         NUMBER
 NULLABLE                                           VARCHAR2(1)
 COLUMN_ID                                          NUMBER
 DEFAULT_LENGTH                                     NUMBER
 DATA_DEFAULT                                       LONG
 NUM_DISTINCT                                       NUMBER
 LOW_VALUE                                          RAW(32)
 HIGH_VALUE                                         RAW(32)
 DENSITY                                            NUMBER
 NUM_NULLS                                          NUMBER
 NUM_BUCKETS                                        NUMBER
 LAST_ANALYZED                                      DATE
 SAMPLE_SIZE                                        NUMBER
 CHARACTER_SET_NAME                                 VARCHAR2(44)
 CHAR_COL_DECL_LENGTH                               NUMBER
 GLOBAL_STATS                                       VARCHAR2(3)
 USER_STATS                                         VARCHAR2(3)
 AVG_COL_LEN                                        NUMBER
 CHAR_LENGTH                                        NUMBER
 CHAR_USED                                          VARCHAR2(1)
 V80_FMT_IMAGE                                      VARCHAR2(3)
 DATA_UPGRADED                                      VARCHAR2(3)
 HISTOGRAM                                          VARCHAR2(15)

More Related Contents:

  1. Place to store PL/SQL block [closed]
  2. ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT CLUSTER KEY WORD IS MISSING? [closed]
  3. Get counts of all tables in a schema
  4. Printing the value of a variable in SQL Developer
  5. PL/SQL – Use “List” Variable in Where In Clause
  6. Passing an array of data as an input parameter to an Oracle procedure
  7. Convert comma separated string to array in PL/SQL
  8. UTL_FILE.FOPEN() procedure not accepting path for directory?
  9. Oracle stored procedure with parameters for IN clause
  10. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  11. Split function in oracle to comma separated values with automatic sequence
  12. check if “it’s a number” function in Oracle
  13. ORA-06508: PL/SQL: could not find program unit being called
  14. PL/SQL print out ref cursor returned by a stored procedure
  15. How to return a resultset / cursor from a Oracle PL/SQL anonymous block that executes Dynamic SQL?
  16. How to send email using Oracle 10 g Forms
  17. SQL*Plus how to accept text variable from prompt?
  18. SQL Fiddle Output Error
  19. oracle PL/SQL how to calculate range ip for IPv6 cidr
  20. if (select count(column) from table) > 0 then
  21. Why cannot I use bind variables in DDL/SCL statements in dynamic SQL?
  22. Trying to export a Oracle via PL/SQL gives a date of 0000-00-00
  23. Oracle: how to INSERT if a row doesn’t exist
  24. Functions vs procedures in Oracle
  25. How to see refcursor result/output in Oracle SQL Developer? [duplicate]
  26. How to output result of SELECT statement which is executed using native dynamic SQL?
  27. Cursor For Loop with dynamic SQL-Statement
  28. Why cannot I create triggers on objects owned by SYS?
  29. No more data to read from socket
  30. automating rollback script oracle

Leave a Comment