I'm going to have to start muting people who are shouting that this new space we've migrated to absolutely must adjust to them or else, because it's getting harder to keep my temper about it. I don't want to be Shouty McWordshivs here. Plenty of places for that already. #dbad #soTired

@kdarty FWIW, I don't agree with this sentiment & feel like folks should be free to post whatever makes them happy (remembering, of course, the golden rule: #DBAD). But if it helps, you can anti-follow tags. So maybe suggesting that folks tag #twitter posts appropriately so that those uninterested can easily avoid?

It may be common knowledge but my mind was blown. :amaze:

We're using CentOS and my DBAD (Database Admin) instructor hinted at the option to make user input variables in some of the new dictionary views we learned this module and using WHERE name = UPPER('&NAME') in the select statement.

I had no idea you could prompt for user input... I was in the middle of making 3 profiles, 9 roles,
16 users, granting them roles and/or privileges as I went, editing a text file in gedit with the new user data and pasting it into the terminal.

It may not actually be faster but it feels faster (I may be biased because I love database). The &UNLIMITED_QUOTA_TABLESPACE variable name is not the best and very long, use &QUOTA_TABLESPACE or something shorter, and the size can be changed to &SIZE_APPEND_M so you can enter 20M but we were using unlimited for the lab.

#CentOS #Oracle #SQL #DBA #OracleSQL #Database #DBAdmin #DBAD #CentOS5 #Oracle12c