Reputation
5,521
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
2 18 31
Newest
 Yearling
Impact
~351k people reached

7h
comment Query on Standby redo logs - Oracle
In 11.2, LNS does the log transport, not ARCH or LGWR (those parameters are no longer documented for >= 11.something).
9h
revised DBMS_METADATA.GET_DDL not displaying complete DDL for big tables
added 18 characters in body; edited tags
9h
comment What kind of database should I use?
Your structure's more complex than a tree if you model the categories (because the nodes can belong to several categories).
11h
comment What kind of database should I use?
Have yu looked into graph databases?
1d
revised Why is a gin index on a jsonb column slowing down my query and what I can do about it?
edited title
1d
comment Calculating table size
I guess the thing you're missing is how many rows you plan to store in there. Otherwise, as I've said, if you just create the table you'll get INITIAL allocated and that's it. (Ignoring deferred segment creation.)
1d
comment Calculating table size
Still don't understand what you're try to measure. You already have the table size (initial). If that's not what you want, what is it?
1d
comment Calculating table size
What are you trying to calculate exactly? If you set initial to 1M and don't load any rows, your table will consume 1M of storage, 100% of it empty (+/- some metadata). But that's pretty useless/trivial information.
Aug
27
reviewed Edit Unable to restore the database with the query
Aug
27
revised Unable to restore the database with the query
Better formatting
Aug
24
comment create a trigger to alter table add column based on inserted row
Just do it manually.
Aug
24
comment create a trigger to alter table add column based on inserted row
Creating a trigger for that sounds like a great waste of time for something you'll do once in a blue moon. If you must, write a stored procedure to do the insertion and modification.
Aug
24
revised Can a Table Lock eliminate a deadlock or make it worse Oracle
deleted 14 characters in body
Aug
23
comment Recover Oracle database with damaged system datafile
Contact Oracle support. There's no general way of dealing with this sort of thing.
Aug
22
revised Interactive Brokers python how to close a trade?
added 418 characters in body
Aug
18
revised Merging adjacent date intervals into a single row
edited title
Aug
14
awarded  Yearling
Aug
13
comment What is the best way to create a table with 800 columns in a single script?
I doubt you'll find "best practices" to do this, since creating such a table it in the first place is clearly not advised at all. Your split approach should work though, so why are you looking for alternatives?
Aug
12
comment Segmenting data by percentage of a column total
Hum... there's an issue with this query though, not sure if that's a problem for you: if there are very few rows (e.g. 1), or if you have unbalanced values (say 1 row a = 100, and 10 rows a = ~1; or 1 row a=75 and 1 row a=25) you probably won't get the categories you expect. If that's a problem, could you edit the question to say what you would expect in those cases?
Aug
12
revised Total sum of database field value with where condition in Laravel
added 5 characters in body; edited title