Archives

You are currently viewing archive for February 2010
Category: Oracle
Posted by: hajime osako
%uFF20IT%uFF1AOracle%u7BA1%u7406%u8005%u306E%u305F%u3081%u306ESQL%u30EA%u30D5%u30A1%u30EC%u30F3%u30B9

GRANT {system_privilege | ALL PRIVILEGES}
[, system_privilege ]
TO {user | role | PUBLIC} [, {user | role} ]
[IDENTIFIED BY password]
[WITH ADMIN OPTION];
Category: Oracle
Posted by: hajime osako
How can I find Table, Index and Column which are indexed? : Oracle FAQ - dbapool.com

select index_name , table_name , column_name from user_ind_columns order by table_name ;
Category: Oracle
Posted by: hajime osako