1,212 reputation
836
bio website espn.go.com/womens-basketball
location Boston, MA
age 37
visits member for 2 years, 11 months
seen 4 hours ago

After spending two plus years learning all I could about SQL Server on a DBA-ish track... time to transition back to Oracle!

Database Designer. Healthcare Informatics Professional.


6h
awarded  Popular Question
1d
awarded  Notable Question
Aug
19
awarded  Popular Question
Jul
29
awarded  Popular Question
Jul
3
awarded  Popular Question
Jul
2
awarded  Inquisitive
Jul
2
awarded  Curious
Jun
26
awarded  Popular Question
Jun
16
awarded  Popular Question
Jun
2
comment check constraint where values must be a table name
Why should I avoid that? The table that I am creating will be used in a PL/SQL block to generate dynamic SQL using the name given in that column. That seems like an ideal use case - am I missing something?
Jun
2
asked check constraint where values must be a table name
May
20
awarded  Popular Question
Apr
9
asked are temporal relationships a good candidate for Oracle cubes?
Feb
19
awarded  Popular Question
Dec
16
comment can I quickly create tables for each partition?
I do not need to keep the data in the original table, though I would be curious for future needs if I could do that as well.
Dec
13
asked can I quickly create tables for each partition?
Oct
17
awarded  Yearling
Oct
11
awarded  Popular Question
Oct
10
awarded  Popular Question
Aug
29
awarded  Notable Question