Create index INDEXNAME ON table(column-name);

How to create index-by table in oracle?

Question Posted / sourav mukhopadhyay

3 Answers
6693 Views
I also Faced
E-Mail Answers

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

List out the components of logical database structure of oracle database.

1088

How to drop an existing table in oracle?

1099

Is a rollback possible to any savepoint?

1146

How to execute a stored program unit?

1125

Explain the use of tables option in exp command.

1166

Explain the truncate in oracle?

1009

Can multiple cursors being opened at the same time?

1113

20. Using a set operator, display the client number of all clients who have never placed an order.

2236

How would you go about verifying the network name that the local_listener is currently using?

2105

what is reindexing?

1727

How to create a stored function in oracle?

1156

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1829

What is bulk load in oracle?

1122

What is the difference between Delete, Truncate and Drop in Oracle?

1179

What is a subquery?

1191