Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

New answers tagged

1

there are command line tools that do field type inferencing. One is xsv https://github.com/BurntSushi/xsv/ Running this command on this (https://gist.githubusercontent.com/aborruso/3b1af402f0d2ed49465f218d19be81d9/raw/c0e95b320924e9e49902633d16e7ab253046ca16/input.csv) xsv stats input.csv --everything | xsv table you have field type sum ...


0

Where does the csv originate from? - I would guess some other database - can't you use the create table statements used for the other database? That aside, though a second data-set would be helpful - IDI is obviously an integer S02Q01_Gender .. depending on your scenario most likely an enum type the other columns look like string-data so tinytext seems ...


0

After some research, I believe that the second way I suggested, is usually considered the best method (depending on how many unique columns the sub types have). I also discovered that this is called "Table Inheritance". However, as it stands there are a few issues with this method: It is possible that no sub-type exists for a particular It is possible ...


2

I'd say this depends on the set requirements - many projects demand that the database never forgets "things" - to be able to generate reports and so on. In these cases you usually have this deleted column already. On delete you update said column - and for the report-functions you have an additional table that keeps record of who "ordered the delete" (just ...


2

A Work colleague pointed out the following to me, for anyone else that stumbles upon this question, use DBA_ALL_TABLES Lodewicus thanks for the help :)


5

You are right. XDB$RESOURCE is not in DBA_TABLES. It is in DBA_OBJECT_TABLES, because it is an object table. Object tables are listed in {DBA,ALL,USER}_OBJECT_TABLES. All regular (non-object) tables are in {DBA,ALL,USER}_TABLES.


2

Does sys.dba_tables show data relevant to access you have ... No. The DBA_ views should only be accessible to Database Administrators who, by definition, have access to [pretty much] everything. Can an index in oracle be against a deleted table? Yes. By default, a dropped table goes first into the Recycle Bin (basically it gets renamed) and only get ...


3

You might want one of these queries: #1 Extra column with window function: SELECT [GuidEmployee], [Date], [Hours], SUM([Hours]) OVER(PARTITION BY GuidEmployee,[Date]) as total_hours FROM [dbo].[Time]; Result GuidEmployee Date Hours total_hours 1 2012-03-02 00:00:00.000 2.00 6.50 1 ...


0

You have not explained, how you start your SP. If done via db-jobs, then you might have this problem. But you can also start a request via any client-tool. Simply by using sqlplus or any other client, connecting the db and returning the threshold to any location you like. Similar way (client-access) is made by many monitoring tools. You can create a ...


0

Depending on how you plan on using the reading values, I would lean towards option 2 for this. Since you have different categories of sensors, with different types of values being used for each, then it would make sense to to have a master table that stores all the sensors and their type and status (online/offline) and location. There would then be a table ...


Top 50 recent answers are included