How to see the table columns used in an index?

1070

What is the max number of columns in an oracle table?

1046

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1746

What is instant client oracle?

1072

Explain what are clusters?

1155

types of indexes and the rationale behind choosing a particular index for a situation.

2559

What is a initialization parameter file in oracle?

1081

Is oracle an open source?

1125

What is the data type of dual table?

1063

What are operators in oracle?

1101

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

2005

Explain a private synonyms?

1097

What is a user account in oracle?

1168

Can we use bind variables in oracle stored procedure?

985

Please explain oracle data types with examples?

1130