pl/sql dollar operator?

Question

I encountered the following ddl in a pl/sql script this morning:

create index genuser.idx$$_0bdd0011 ...

My initial thought was that the index name was generated by a tool...but I'm also not a pl/sql superstar so I could very well be incorrect. Does the double dollar sign have any special significance in this statement?

Answer 1

No special meaning or significance.

SQL> create table t (col number)
  2  /

Table created.

SQL> create index idx$$_0bdd0011 on t(col)
  2  /

Index created.

Note: CREATE INDEX is a DDL statement which is usually executed in a SQL script, not in PL/SQL.

Answer 2

Your initial thought seems to be correct. That would look to be an index name generated by a tool (but not assigned by Oracle because an index name wasn't specified). Dollar signs don't have any particular meaning other than being valid symbols that are rarely used by human developers and so are handy to reduce the risk that a system-generated name conflicts with a human-generated name.