---
title: "Which SQL command to get all details about a table in Oracle?"  
description: "Which SQL command to get all details about a table in Oracle?"  
author: "Utpal Vishwas"  
published: 2023-07-17  
updated: 2023-07-18  
canonical: https://www.mindstick.com/forum/159132/which-sql-command-to-get-all-details-about-a-table-in-oracle  
category: "oracle"  
tags: ["sql", "database table", "oracle"]  
reading_time: 1 minute  

---

# Which SQL command to get all details about a table in Oracle?

Which [SQL command](https://www.mindstick.com/blog/142/categorize-sql-commands-in-sql-server) to get all details about a [table](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap) in [Oracle](https://www.mindstick.com/articles/13016/alter-table-statement-or-command-in-oracle)?

## Replies

### Reply by Aryan Kumar

To get all details about a table in Oracle, you can use the `DESCRIBE` [command](https://www.mindstick.com/blog/178/synchronous-and-asynchronous-command-execution-in-c-sharp-dot-net). The `DESCRIBE` command will return a list of all the columns in the table, as well as their data types, sizes, and other properties.

For example, to get all details about the table `employees`, you would use the following command:

[SQL](https://www.mindstick.com/articles/13115/types-of-keys-in-sql-or-oracle-database)

```plaintext
DESCRIBE employees;
```

This would return a list of all the columns in the `employees` table, as well as their data types, sizes, and other properties.

Here is an example of the output of the `DESCRIBE` command:

SQL

```plaintext
COLUMN_NAME                    DATA_TYPE         PRECISION  SCALE       NULLABLE
-----------------------------  --------------  --------  --------  --------
employee_id                   NUMBER         10         0          N
first_name                    VARCHAR2       255         0          Y
last_name                     VARCHAR2       255         0          Y
email                          VARCHAR2       255         0          Y
phone_number                   VARCHAR2       255         0          Y
hire_date                     DATE           0          0          N
```

The `DESCRIBE` command is a powerful tool that you can use to get information about tables in Oracle. By using the `DESCRIBE` command, you can learn about the structure of a table and the data that it contains.


---

Original Source: https://www.mindstick.com/forum/159132/which-sql-command-to-get-all-details-about-a-table-in-oracle

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.