oracle show index columns
Solutions on MaxInterview for oracle show index columns by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "oracle show index columns"
Isaac
05 Mar 2020
1SELECT TABLE_NAME, INDEX_NAME, COLUMN_NAME
2FROM DBA_IND_COLUMNS -- or ALL_IND_COLUMNS
3WHERE TABLE_OWNER = 'MY_SCHEMA' AND TABLE_NAME = 'MY_TABLE'
4ORDER BY TABLE_NAME, COLUMN_POSITION;similar questions
oracle sql drop indexoracle character indexhow to select an index in oracle sqloracle index size calculationoracle list index on tableoracle get table column namesoracle columns tableoracle show column of tableoracle index hint multiple tables exampleselect index table oraclelister les index d 27une table oracleshow index tabledrop index oraclehow to know the character set of an oracle databesrebuild index oracleforce using index oracleoracle index hintoracle index sizeoracle index partitionoracle create index parallelindex a database column sqlsql view indexoracle rename indexoracle create indexindex using in query plsql your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful