Oracle function based index with empty function name

I’m trying to understand this syntax in the creation of an index in a database I’m using:

CREATE  INDEX IDX ON SQ.MYTABLE (('ID_COLUMN1'), ('ID_COLUMN2'), ('ID_COLUMN3')); 

After searching for a while, I could not find any example using this syntax, and how it is different from a normal multi column index:

CREATE  INDEX IDX_2 ON MYSQ.MYTABLE ('ID_COLUMN1', 'ID_COLUMN2', 'ID_COLUMN3'); 

I figured out it is a function based index, analyzing the following example I was trying to assemble:

CREATE TABLE t (a number, b number, c number);  insert into t values (1, 2, 3); insert into t values (4, 5, 6); insert into t values (7, 8, 9); insert into t values (10,11, 12); insert into t values (13, 14, 15); insert into t values (16, 17, 18);  CREATE INDEX IDX2 ON t (a, b, c); CREATE INDEX IDX ON t (('d'), ('b'), ('c'));  select * from USER_INDEXES;   INDEX_NAME  INDEX_TYPE  TABLE_OWNER     TABLE_NAME  TABLE_TYPE  UNIQUENESS  COMPRESSION     PREFIX_LENGTH   TABLESPACE_NAME     INI_TRANS   MAX_TRANS   INITIAL_EXTENT  NEXT_EXTENT     MIN_EXTENTS     MAX_EXTENTS     PCT_INCREASE    PCT_THRESHOLD   INCLUDE_COLUMN  FREELISTS   FREELIST_GROUPS     PCT_FREE    LOGGING     BLEVEL  LEAF_BLOCKS     DISTINCT_KEYS   AVG_LEAF_BLOCKS_PER_KEY     AVG_DATA_BLOCKS_PER_KEY     CLUSTERING_FACTOR   STATUS  NUM_ROWS    SAMPLE_SIZE     LAST_ANALYZED   DEGREE  INSTANCES   PARTITIONED     TEMPORARY   GENERATED   SECONDARY   BUFFER_POOL     FLASH_CACHE     CELL_FLASH_CACHE    USER_STATS  DURATION    PCT_DIRECT_ACCESS   ITYP_OWNER  ITYP_NAME   PARAMETERS  GLOBAL_STATS    DOMIDX_STATUS   DOMIDX_OPSTATUS     FUNCIDX_STATUS  JOIN_INDEX  IOT_REDUNDANT_PKEY_ELIM     DROPPED     VISIBILITY  DOMIDX_MANAGEMENT   SEGMENT_CREATED IDX2    NORMAL  USER_4_AE9EA5   T   TABLE   NONUNIQUE   DISABLED    (null)  FIDDLEDATA  2   255     65536   1048576     1   2147483645  (null)  (null)  (null)  (null)  (null)  10  YES     0   1   6   1   1   1   VALID   6   6   2019-08-19T22:06:23Z    1   1   NO  N   N   N   DEFAULT     DEFAULT     DEFAULT     NO  (null)  (null)  (null)  (null)  (null)  NO  (null)  (null)  (null)  NO  NO  NO  VISIBLE     (null)  YES IDX     FUNCTION-BASED NORMAL   USER_4_AE9EA5   T   TABLE   NONUNIQUE   DISABLED    (null)  FIDDLEDATA  2   255     65536   1048576     1   2147483645  (null)  (null)  (nul 

http://www.sqlfiddle.com/#!4/ae9ea5/5

What is the purpose of this index?

Is there a valid Constitution based build?

Okay, so there are a lot of builds for SAD (Single Attribute Dependency) characters out there, which can be further helped along with the addition of certain magical items, spells, etc. However, I’ve yet to see a good SAD build designed around solely Constitution, where the character is basically just a tank/defender type character who can take a LOT of hits with a LOT of hit points, occasionally shoring up their health with some healing.

While thinking this through, I figured the closest I could put together would be a 20th level Ancestral Guardians Hill Dwarf, with the Dwarven Fortitude, Tough, and Durable feats, with a maxed out Constitution score, going unarmored (still has a shield). Basically, the goal would be to use your attacks to get your abilities to draw attackers towards you, where you would focus on taking the brunt of the damage, and occasionally using the Dodge action to heal yourself up a bit using your Hit Dice (thanks to Dwarven Fortitude. If someone can come up with a better Constitution based build, I would love to hear it.

Oh, of note, I know that Moon Druid can be a great tank due to their unlimited high-level Wildshapes, but as that build doesn’t necessarily benefit from having a high Constitution, I don’t think it’s quite what I’m looking for.

Concatenative programming language based on the stack as a non-trivial virtual machine

For a functional programming language project like Haskell, I design a VM whose intermediate language is stack-based, and focused on the concatenative paradigm:

- Functions / quotations / combinators - Stack shufflers - Data - An FFI targeting C 

Let’s summarize it this way.

My question is whether this is sufficient and relatively efficient to

- Compile a Haskell-like language typed in this IR - Interfacing and using all kinds of foreign C functions 

and if, possibly, you have an idea about how to do it or any ressources.

The biggest challenge, I think, will probably be, if possible, to represent the data according to the type 1) of the source language (Haskell-like) and 2) of the FFI targeting C, through an IR that has no typing notion (except internally the distinction of numbers, static arrays and characters). If you had any advice on that, it would also be interesting.

Web UX – Serving two versions of site based on selected customer type

I’m building a site for an accounting firm. They would like to serve two distinct home pages for “Individuals” and “Businesses.”

The site would look similar but have different content relating to the services they offer these two types of customers.

  • What is the best way to allow users to choose their customer type? (Currently thinking pop-up prompt on first visit)
  • How easy should it be for users to switch between types?
  • How obvious should I make it for the user to know which version of the site they are on?
  • Any differences between desktop and mobile?

Thank you!

Update column value based on other column with manage duplicate value MySQL query

I need to update column value based on other column with adding separator and with manage duplicates values using sql query.

For example :

I have one database table A.

Here in it two columns : 1) locality 2) slug

Locality column already have data. So need to update ‘slug’ column based on locality value. Please review below screenshots.

Currently i have below table.

enter image description here

And i need to update ‘slug’ column like below screenshot. column value based on i

Data Entry Typing Job From Home for Survey based chineese company for $20

Hey There, We usually do data entry for the largest company and we need some typing specialist who can help us hand in hand to complete our survey form with us. The pay will be based on how many forms you will complete per day. Then we will pay you here through seoclerks.

by: MDHasib14921
Created: —
Category: Data Entry
Viewed: 272


How to assign people to categories based on some voting rules?

Say in an election there are predefined categories users can be assigned to. Of the people who are assigned to a certain category, other users can vote for them. To compute the results, the following rules have to be adhered to:

  1. Highest voted user in category wins
  2. If 1 user have same 5 vote count for 1 category and 8 vote for 2 category then he/she will be elected for category 2.
  3. If 1 user have same 5 vote count for 1 category and 5 vote for 2 category then the winner selection will be On Hold
  4. If two or more users in a same category has the same votes, then goes on hold

So, for example: the table lists the positions and for each position it gives the name of the user and the votes they received.

enter image description here

For this, the winners should be as follows:

  • Position 1: User 1
  • Position 2: User 3
  • Position 3: User 2 (User 3 loses because of rule 2 and wins in position 2)
  • Position 4: User 5 and User 6 are both kept on hold (rule #4)
  • Position 5: User 4 on hold (rule #3)
  • Position 6: User 4 on hold (rule #3)

I have tried solving this using the Hungarian algorithm to no avail. It works quite well, after some modifications, for this problem. But doesn’t live up to the following case:

enter image description here

In this case, the results are as follows:

  • Position 1: User 1
  • Position 2: User 2
  • Position 3: EMPTY (User 1 and 2 loses due to rule 2)
  • Position 4: EMPTY (User 1 and 2 loses due to rule 2)
  • Position 5: EMPTY (User 1 and 2 loses due to rule 2)

Basically, no user can be assigned to more than one position.


Any help solving this would be extremely helpful.

Thank you

Move Item from Drop Off Library to Destination Library and create folder structure in Destination Library based on certain criteria

The project i started with SharePoint from my previous question has moved to the second stage. The documents added to our Drop Off Library, after I manually run the workflow to strip the document name to its respective columns, will need another workflow to move the items from the Drop Off library to a destination library called “Employee Files” in the format below enter image description here

The Drop Off Library list has the following fields enter image description here

The workflow has to create a Root folder for example A (based on the last name index on Drop Off), then create sub-folder (a.) with last name, first name (emp ID) and sub-folder within (a.) based on the HR Employee File Category. I am able to come up with creating a folder in Employee Files library based on Last Name Index, or move just the document from Drop Off to Employee Files, but have no idea how to do all the necessary actions i.e create the complex sub folder structure, move to Employee Files and copy the document (there is an attached pdf before Name)inside one of these folders based on the HR category and the Payroll folder. Is the workflow in SP Designer 2013 doable?

Thanks again for all your help!

Sam