Reputation
4,415
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 14 34
Newest
 Suffrage
Impact
~167k people reached

Feb
5
comment How to relate a [ parent common] table with (possibly many) subtype tables?
My understanding now is that any one row in SystemCommon is to be related to just one row in just one of the four SystemType tables. Is that correct? If so, this looks like a case of table inheritance to me. I'm sure I've seen questions on this topic (some of them with great answers by @MDCCL too), but I'm still struggling to find one that would best fit your scenario (and also contain an example of implementation), without irrelevant details so as to make it less confusing for you.
Feb
5
comment How to relate a [ parent common] table with (possibly many) subtype tables?
Perhaps I'm missing something but why are you talking about parents and types? Is the Parent table supposed to be a parent to a (sub)type table or is it a parent to a completely different table? If it's important for us to know that the table with which you are trying to associate a SystemType table is a parent table (to something else), please show the relevant parent-child relationship. But if a child table is irrelevant to the problem, then please don't use the term "parent", that's just confusing. I mean, if I knew why that was important, I might understand your issue better.
Feb
5
comment What is the correct way to rename/swap a table in production
Or maybe you could elaborate in your question how you did the renaming (exactly what commands or tools you used). All the more so since you've already been pointed to a couple of renaming methods.
Feb
4
reviewed Close Which data type should I use to store a 11 digit number
Feb
4
comment Fatal error when not numeric value - PostgreSQL 9.2
You could have spared people's time by not posting your question until you got the complete information.
Feb
4
reviewed Close Is there a TSQL command or another way to rename AOAG (Always On Availability Group)?
Feb
3
revised Slow subquery in SELECT statement
formatting
Feb
3
comment Counting outdated records
I wasn't clear, sorry. JSON is fine when you are dealing with JSON. But when you are dealing with tabular data, the tabular form is most convenient to work with. Please take a look at these various questions to get the idea about what I meant by "data sample", "current result", and "expected result": 1) dba.stackexchange.com/q/42841/6965 2) dba.stackexchange.com/q/111624/6965 3) dba.stackexchange.com/q/122226/6965 4) dba.stackexchange.com/q/80315/6965 5) dba.stackexchange.com/q/123401/6965
Feb
3
comment Counting outdated records
Your goal isn't clear at this point. Could you please post a data sample, the result your current query would give you, and the expected result?
Feb
3
comment How to compare dates on minute level in plsql?
@Phil: Or perhaps TRUNC(sysdate, 'MI') instead (since it's sysdate <= column and not the other way round).
Feb
3
reviewed Close Is it important to make transaction log backups?
Feb
3
reviewed Close Can you please explain about Remedy ticketing tool
Feb
3
revised Enforce NOT NULL for set of columns with a CHECK constraint only for new rows
cleared an incorrect supposition
Feb
3
revised Enforce NOT NULL for set of columns with a CHECK constraint only for new rows
additional note
Feb
3
answered Enforce NOT NULL for set of columns with a CHECK constraint only for new rows
Feb
3
comment ERROR: check constraint is violated by some row
Or like this: WHERE ("qb_id", "xero_id", "freshbooks_id", "myob_id", "ppy_id") IS NOT DISTINCT FROM (NULL, NULL, NULL, NULL, NULL).
Feb
3
comment Get start time and end time of a trip in SQL Server
It'll be great if you show us what you have tried. That way you may be more likely to learn something new rather than just get another proverbial fish for a day.
Feb
2
comment Recursive Join to get Spans
Solutions for Oracle and for MySQL would likely differ very much. Or, if a universal one is possible, it's probable that it wouldn't be very efficient for this type of problem. I suggest you stick with Oracle in this question and, if you need a solution for the other platform as well, ask a new question for MySQL. (But please make sure you've searched for ready answers. I'm sure questions of this kind have been asked before both here and on Stack Overflow. Search either site for [gaps-and-islands] [mysql].)
Feb
2
reviewed Leave Closed How to get data from three different tables
Feb
2
reviewed Close What can become a reason of database failure?