New answers tagged table
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
