How can I get column names from a table in Oracle?

by

You can query the USER_TAB_COLUMNS table for table column metadata.

SELECT table_name, column_name, data_type, data_length
FROM USER_TAB_COLUMNS
WHERE table_name="MYTABLE"

More Related Contents:

  1. How do I reset a sequence in Oracle?
  2. ORA-00904: invalid identifier
  3. Is there any boolean type in Oracle databases?
  4. SQL ROWNUM how to return rows between a specific range
  5. MySQL equivalent of DECODE function in Oracle
  6. SQL recursive query on self referencing table (Oracle)
  7. create table with sequence.nextval in oracle [duplicate]
  8. Oracle – How to create a materialized view with FAST REFRESH and JOINS
  9. Deferrable Constraints in SQL Server
  10. Oracle (Old?) Joins – A tool/script for conversion?
  11. How to populate calendar table in Oracle?
  12. What is it exactly a BLOB in a DBMS context
  13. What can cause an Oracle ROWID to change?
  14. Does ‘Select’ always order by primary key?
  15. Is there a version control system for database structure changes?
  16. Local Temporary table in Oracle 10 (for the scope of Stored Procedure)
  17. How do I list all the columns in a table?
  18. How do you interpret a query’s explain plan?
  19. Oracle DB: How can I write query ignoring case?
  20. How do NULL values affect performance in a database search?
  21. Query a Table’s Foreign Key relationships
  22. Oracle , != , ^= operators
  23. SQL Server equivalent of WM_CONCAT function [duplicate]
  24. ORA-01652: unable to extend temp segment by 128 in tablespace SYSTEM: How to extend?
  25. Reset identity seed after deleting records in SQL Server
  26. MySQL dump by query
  27. How would you implement sequences in Microsoft SQL Server?
  28. SQL how to compare two tables for same data content?
  29. Select a random sample of results from a query result
  30. In Oracle, is it possible to INSERT or UPDATE a record through a view?

Leave a Comment