question

OraLearner avatar image
OraLearner asked

DUAL table structure in Oracle ?

Can anybody explain me the structure of DUAL table of Oracle. Can we add records to this table ? Thank you.

oracletable
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
KillerDBA avatar image
KillerDBA answered

There's a FAQ for that

Don't add or delete any records, you might get unpredictable results when it returns more or less than ONE row.

Update: As of a recent release, it's an internal table structure. It could be that you can't add a row. I'm not testing that, as there'd be no point to it and it could cause problems or confusion. You're welcome to try it, of course.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.