lavanyavijayan
Last Activity: Nov 9 '06, 12:36 PM
Joined: Nov 3 '06
Location:
-
test reply... -
Hi,
try the following query to get answer ...
select table_name from user_tab_column s where COLUMN_NAME='&C ol_name'
Here you just enter the column name you want to search
-Vijayan....Leave a comment:
-
Oracle: Grouping by all the columns of a table
Hi Guys,
I need a SQL statement to group by all the columns of a table without specifying all the columns. Indeed,I want the keyword or the syntax to do the same.
For example,
assume EMP table consists of the following columns,
ENO, NAME, DEPT and SAL and etc.
To group by ENO and DEPT, we can give GROUP BY ENO,DEPT.
But I want to group by all the fileds, without specifying...
No activity results to display
Leave a comment: