Toad for Oracle 10.5.1.3 - How to find DataType info like in Schema Browser
When using Toad for Oracle the wonderful schema browser provides a lot of information. One piece of that info that I would like to have available via a query is the Data Type information for a given table.
That extra bit of info listed in the Data Type column (1 Byte), provided in the Schema Browser is what I am looking for. When using the table ALL_TAB_COLS it provides a lot of that same info but not that additional info about the Data Type.
Is there any way to have a Select statement return that same information?
Thanks!
Solution
The DATA_LENGTH field in ALL_TAB_COLUMNS provides the the length of the column (in your case 1), while CHAR_USED flag differentiates between CHAR (C) and BYTE (B).
- PLS-00306 when calling Oracle stored procedure in Node.js
- ORA-28040: No matching authentication protocol exception
- Default username and password for Oracle database
- Update TransactionId based on mapping table data
- How to declare a constant in Oracle SQL PLUS?
- Oracle Hierarchical query with multiple Parent Levels : how to get required details
- Retrieve data from Json Column
- How to replace dbms_obfuscation_toolkit with dbms_crypto
- Create age group column from birthday
- Is there a way to do a like join on two columns based on only the first 3 characters of one of the columns?
- Select 3rd salary from employee table
- How to write a condition to do something where a for loop returns no rows
- How to get the tenure in current job role?
- Display contents of Oracle AQ SYS.AQ$_JMS_TEXT_MESSAGE
- ERROR: ORA-00923: FROM keyword not found where expected - Oracle JOIN SQL
- Oracle SQL JSON_TABLE PATH references in some columns returning next record (+1?) child data elements
- Need to send csv stored in UTL_FILE directory using UTL_SMTP
- Ordinal enum mapping with Hibernate 6.5
- Detect all special characters (ascii codes 128 to 255) on a varchar column
- PL/SQL block throwing a "variables not bound" error despite seemingly no errors in the code
- No more data to read from socket error
- INSERT and UPDATE the Values into the table based on condition
- How to force oracle to not to use an index
- Real time replication from on premises Oracle to AWS
- Invalid Identifier error while using standard_hash function in oracle 11g
- How to escape underscores in Oracle SQL Developer?
- Error- ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion
- SQL - How to Sum every line with record-3
- Oracle Scheduler Job Fails to Run: Not an Appropriate Date Error
- Database UTF-8 encoding problem when trying to retrieve data from spring boot application