How to create index-by table in oracle?

Answer Posted / sourav mukhopadhyay

Create index INDEXNAME
ON table(column-name);

Is This Answer Correct ?    1 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain implicit cursor.

560


what is the scripts in data base?

1605


How to convert numbers to characters in oracle?

590


Explain oracle left join with an example?

588


What is a parameter file in oracle?

562






What is the usage of save points in oracle database?

533


How to resolve name conflicts between variables and columns?

574


Explain the features of oracle?

602


What is the data pump import utility?

585


What is oracle thin client?

538


What is a dead lock in oracle?

598


WHAT IS ecc 6.0

1666


What is the quickest way to export a table to a flat file?

573


What is the maximum limit on the number of columns in a table?

553


Compare and contrast between sql and sql server and explain its various functions?

538