1,207 reputation
735
bio website espn.go.com/womens-basketball
location Boston, MA
age 37
visits member for 2 years, 10 months
seen 2 days 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.


2d
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
Aug
1
asked most effective architecture to apply mulitple functions
Jul
25
awarded  Popular Question