CODEWITHSUNDEEP
mysqloracle-database
codebee
codebee

Reputation: 57

What is the use of SET type in MySQL? How to implement in Oracle?

I was reading on https://dev.mysql.com/doc/refman/5.7/en/set.html but I could not understand its use much. Why do we need it? And how can we achieve this in Oracle?

Upvotes: 1

Views: 40

Answers (1)

Jeff Holt
Jeff Holt

Reputation: 3190

Why do we need it? We don't. Anything that you think you can do with a set, you can do with a parent-child relationship. You can even cluster tables if you so desire, which I suppose could be a concern.

The closest concept in Oracle to a MySQL SET is what Oracle calls a nested table.

The biggest problem with nested tables is that you would be hard-pressed to index them.

Upvotes: 1

Related Questions