Search
 
SCRIPT & CODE EXAMPLE
 

SQL

oracle get table column names

SELECT COLUMN_NAME
FROM DBA_TAB_COLS
WHERE table_name = 'my_table';
Comment

column names in oracle sql

DESCRIBE Table_Name;

OR 

DESC Table_Name;
Comment

oracle tables with column name

SELECT * FROM USER_TAB_COLUMNS WHERE COLUMN_NAME = 'MY_COLUMN'; -- Connected user
SELECT * FROM ALL_TAB_COLUMNS WHERE COLUMN_NAME = 'MY_COLUMN';	-- Other schemas
SELECT * FROM DBA_TAB_COLUMNS WHERE COLUMN_NAME = 'MY_COLUMN';	-- All tables
Comment

SQL column name Oracle

SELECT table_name, column_name, data_type, data_length
FROM USER_TAB_COLUMNS
WHERE table_name = 'MYTABLE'
Comment

PREVIOUS NEXT
Code Example
Sql :: find most frequent value in sql column 
Sql :: postgresql get year 
Sql :: Oracle NLS_CHARACTERSET 
Sql :: oracle trace file 
Sql :: mysql shell ERROR: Not connected. 
Sql :: how to drop a trigger in postgresql 
Sql :: varchar plsql 
Sql :: mariadb number format 
Sql :: how to fetch alternate records from two tables 
Sql :: mysql round 
Sql :: sql create table with datetime automatically 
Sql :: oracle ora-00054 resource busy 
Sql :: oracle grants 
Sql :: SQLite order random 
Sql :: wsl centos 8 mysql 
Sql :: mysql Like(searching in the string) 
Sql :: sql server format datetime 
Sql :: stop and start mysql 
Sql :: date in where on datetime column clause mysql 
Sql :: add foreign key constraint in postgresql 
Sql :: sql create table primary key autoincrement 
Sql :: python sqlite3 prepared statement 
Sql :: t sql to rebuild all indexes in a database 
Sql :: mysql remove duplicates 
Sql :: drop unique key constraint in sql server 
Sql :: sql calculate percentage 
Sql :: restore postgres database from dump 
Sql :: convert date to dd/mm/yyyy sql 
Sql :: mysql ifnull 
Sql :: laravel get sql query eloquent with parameters 
ADD CONTENT
Topic
Content
Source link
Name
5+7 =