Menu
In Sql Developer under tables I see tables, but some of the tables have $ in name.
Example:
tb$something
What does that '$' sign mean when in name of table?
802
quotes around the table name: create table "$$tmp$$"(id int) . And no, the $ doesn't have any special meaning, except that it shouldn't be used by the user, because various internal tables have names that contain a $ (think v$session). The $ is supposed to avoid name conflicts.
The double ampersand will prompt once and everywhere that variable is used it will use what was entered. If it had only one ampersand, you would get a prompt for every occurrence.
You can narrow down your search by providing the owner of the table. The owner is the schema in which the table resides. select owner, table_name from all_tables where table_name='table%' and owner='MYOWNER'; Alternatively you can log into that particular schema and query user_tables.
Tables that contain the prefix V$ are tables that store volatile information.
Volatile information is produced by an oracle instance while it is in use (In use means the instance is up and running). Volatile Information includes Statistics, session information of users, memory allocation.
132
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
