1,212 reputation
1038
bio website espn.go.com/womens-basketball
location Boston, MA
age 38
visits member for 3 years, 1 month
seen Nov 19 at 20:18

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.


Nov
18
revised How can I tell which data sources are being used in SSRS?
it's a reference to a table.column
Oct
17
awarded  Yearling
Oct
16
awarded  Notable Question
Oct
8
awarded  Popular Question
Sep
30
awarded  Explainer
Sep
16
awarded  Popular Question
Sep
15
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.