SQL Get All column names from All Tables

	Use MyDataBaseName
	select column_name, data_type, data_length, data_precision, data_scale
	from user_tab_columns
	-Useing above statement, i will get all column names from my database
	-Now i want get details of my column from my table
	select column_name, data_type, data_length, data_precision, data_scale
	from user_tab_columns
	where column_name='ProductName'
	and table_name='Products';
	-Using above statemnt i will get details of ProductName column from Products table

view raw gistfile1.sql hosted with ❤ by GitHub