[Section 3 of RFC4122][1] provides the formal definition of UUID string representations.  It&#39;s 36 characters (32 hex digits + 4 dashes).

Sounds like you need to figure out where the invalid 60-char IDs are coming from and decide 1) if you want to accept them, and 2) what the max length of those IDs might be based on whatever API is used to generate them.

  [1]: https://www.rfc-editor.org/rfc/rfc4122#section-3

This is the perfect kind of field to define as CHAR 36, by the way, not VARCHAR 36, since each value will have the exact same length. And you&#39;ll use less storage space, since you don&#39;t need to store the data length for each value, just the value.

Most databases have a native UUID type these days to make working with them easier. If yours doesn&#39;t, they&#39;re just 128-bit numbers, so you can use BINARY(16), and if you need the text format frequently, e.g. for troubleshooting, then add a calculated column to generate it automatically from the binary column. There is no good reason to store the (much larger) text form.

I want to update my column CODE_DEST with an incremental number.  I have:

    CODE_DEST   RS_NOM
    null        qsdf
    null        sdfqsdfqsdf
    null        qsdfqsdf

I would like to update it to be:

    CODE_DEST   RS_NOM
    1           qsdf
    2           sdfqsdfqsdf
    3           qsdfqsdf

I have tried this code:

    UPDATE DESTINATAIRE_TEMP
    SET CODE_DEST = TheId 
    FROM (SELECT  Row_Number()   OVER (ORDER BY [RS_NOM]) AS TheId FROM DESTINATAIRE_TEMP)

This does not work because of the `)`

I have also tried:

    WITH DESTINATAIRE_TEMP AS
      (
        SELECT 
        ROW_NUMBER() OVER (ORDER BY [RS_NOM] DESC) AS RN
        FROM DESTINATAIRE_TEMP
      )
    UPDATE DESTINATAIRE_TEMP SET CODE_DEST=RN

But this also does not work because of union.

How can I update a column using the `ROW_NUMBER()` function in SQL Server 2008 R2?

SQL Update with row_number()

I am a system administrator and I have been asked to run a linux script to clean the system.

The command is this:

    perl script.pl &gt; output.log &amp;

so this command is ending with a `&amp;` sign, is there any special significance of it?

I have basic knowledge of shell but I have never seen this before.



What does &quot;&amp;&quot; at the end of a linux command mean?

We are using UUID as primary key for out oracle DB, and trying to determine an appropriate max character length for the VARCHAR. Apparently this is 36 characters but we have noticed UUID&#39;S generated which are longer than this - up to 60 characters in length.
Does anyone know a suitable max char length for UUID??

UUID max character length

<p>We are using UUID as primary key for out oracle DB, and trying to determine an appropriate max character length for the VARCHAR. Apparently this is 36 characters but we have noticed UUID'S generated which are longer than this - up to 60 characters in length.
Does anyone know a suitable max char length for UUID??</p>


Is there a way to display all the views currently set on an oracle database via sql developer?

Thanks.

Display all views on oracle database

I&#39;m using Oracle SQL developer version 3.0.04. I attempted to use the function `LISTAGG` to group the data together..

        CREATE TABLE FINAL_LOG AS
        SELECT SESSION_DT, C_IP, CS_USER_AGENT,
        listagg(WEB_LINK, &#39; &#39;)
	        WITHIN GROUP(ORDER BY C_IP, CS_USER_AGENT) &quot;WEB_LINKS&quot;
	        FROM webviews
	        GROUP BY C_IP, CS_USER_AGENT, SESSION_DT
	        ORDER BY SESSION_DT

However, I keep getting the error,

    SQL Error: ORA-01489: result of string concatenation is too long

I&#39;m pretty sure that the output may be more than 4000, since the WEB_LINK mentioned here is a concatenated value of url stem and url query. 

Is there any way to go around it or is there any other alternative?

LISTAGG function: &quot;result of string concatenation is too long&quot;

I would like to know:
How to rename a table column in Oracle 10g?

How to rename a table column in Oracle 10g

I have to store UTC dateTime in DB.&lt;BR&gt;
I have converted the dateTime given in specific timezone to UTC. for that I followed the below code.&lt;BR&gt;
My input dateTime is &quot;20121225 10:00:00 Z&quot; timezone is &quot;Asia/Calcutta&quot; &lt;BR&gt;
My Server/DB(oracle) is running in the same timezone(IST) &quot;Asia/Calcutta&quot; &lt;BR&gt;


**Get the Date object in this specific Timezone**

            String date = &quot;20121225 10:00:00 Z&quot;;
            String timeZoneId = &quot;Asia/Calcutta&quot;;
            TimeZone timeZone = TimeZone.getTimeZone(timeZoneId);

			DateFormat dateFormatLocal = new SimpleDateFormat(&quot;yyyyMMdd HH:mm:ss z&quot;);
                        //This date object is given time and given timezone
			java.util.Date parsedDate = dateFormatLocal.parse(date + &quot; &quot;  
							 + timeZone.getDisplayName(false, TimeZone.SHORT));

			if (timeZone.inDaylightTime(parsedDate)) {
				// We need to re-parse because we don&#39;t know if the date
				// is DST until it is parsed...
				parsedDate = dateFormatLocal.parse(date + &quot; &quot;
						+ timeZone.getDisplayName(true, TimeZone.SHORT));
			}
            
           //assigning to the java.sql.TimeStamp instace variable
            obj.setTsSchedStartTime(new java.sql.Timestamp(parsedDate.getTime()));

**Store into DB**

            if (tsSchedStartTime != null) {
                stmt.setTimestamp(11, tsSchedStartTime);
            } else {
                stmt.setNull(11, java.sql.Types.DATE);
            }
**OUTPUT**

DB (oracle) has stored the same given `dateTime: &quot;20121225 10:00:00` not in UTC.

I have confirmed from the below sql.

         select to_char(sched_start_time, &#39;yyyy/mm/dd hh24:mi:ss&#39;) from myTable

My DB server also running on the same timezone &quot;Asia/Calcutta&quot;

It gives me the below appearances 

1. `Date.getTime()` is not in UTC 
2. Or Timestamp is has timezone impact while storing into DB
What am I doing wrong here?

**One more question:**

Will `timeStamp.toString()` print in local timezone like `java.util.date` does? Not UTC?

Is java.sql.Timestamp timezone specific?

I know this has been answered to some degree with PHP and MYSQL, but I was wondering if someone could teach me the simplest approach to splitting a string (comma delimited) into multiple rows in Oracle 10g (preferably) and 11g. 

The table is as follows:

    Name | Project | Error 
    108    test      Err1, Err2, Err3
    109    test2     Err1

I want to create the following:

    Name | Project | Error
    108    Test      Err1
    108    Test      Err2 
    108    Test      Err3 
    109    Test2     Err1

I&#39;ve seen a few potential solutions around stack, however they only accounted for a single column (being the comma delimited string). Any help would be greatly appreciated. 


Splitting string into multiple rows in Oracle

I have a model like this:

    class Hop(models.Model):
        migration = models.ForeignKey(&#39;Migration&#39;)
        host = models.ForeignKey(User, related_name=&#39;host_set&#39;)

How can I have the primary key be the combination of `migration` and `host`?







How can I set two primary key fields for my models in Django?

I just think that the answer is false because the foreign key doesn&#39;t have `uniqueness` property.

But some people said that it can be in case of self joining the table.
I am new to `SQL`. If its true please explain how and why? 

    Employee table
    | e_id | e_name  | e_sala  |  d_id  |
    |----  |-------  |-----    |--------|
    |  1   |   Tom   |  50K    |    A   |
    |  2   | Billy   |  15K    |    A   |
    |  3   | Bucky   |  15K    |    B   |


    department table
    | d_id | d_name  |
    |----  |-------  |
    |  A   |   XXX   | 
    |  B   |   YYY   | 

Now, d_id is foreign key so how it can be a primary key. And explain something about `join`. What is its use?


Can a foreign key refer to a primary key in the same table?

I have a table for storing coupons/discounts, and I want to use the coupon_code column as the primary key, which is a `VARCHAR`.

My rationale is that, each coupon will have a unique code, and the only commands I will be running are `SELECT ... FROM ... WHERE coupon_code=&#39;..&#39;`

I won&#39;t be doing any joins or indexing, and I don&#39;t see there ever being more than a few hundred entries in this table.

It seems to me that this will be OK, but I don&#39;t know if there is anything I&#39;m missing/not thinking about.

Can I use VARCHAR as the PRIMARY KEY?

How to provide primary key for multiple column in a single table using PostgreSQL?   

Example:

    Create table &quot;Test&quot; 
    (
       &quot;SlNo&quot; int not null primary key,
       &quot;EmpID&quot; int not null, /* Want to become primary key */
       &quot;Empname&quot; varchar(50) null,
       &quot;EmpAddress&quot; varchar(50) null
    );

Note: I want to make `&quot;EmpID&quot;` also a primary key.

Primary key for multiple column in PostgreSQL?

I am not able to understand what Range / primary key is here in the docs on [Working with Tables and Data in DynamoDB][1]

How does it work?

What do they mean by &quot;unordered hash index on the hash attribute and a sorted range index on the range attribute&quot;?

[1]: https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/WorkingWithTables.html

What is Hash and Range Primary Key?

I don&#39;t understand what a bluetooth UUID denotes. Do UUIDs denote protocols (e.g. [RFCOMM][1])? If so, why do the `createRfcommSocketToServiceRecord()` methods require UUIDs, when they specify rfcomm right in their names? Why does the BluetoothChat sample code have a seemingly arbitrary, hardcoded UUID?

My question arises because, as per [this question][2], I&#39;m getting a null pointer exception when devices running 4.0.4 try to connect (to an external, non-android device) using reflection. However, the solution to that question doesn&#39;t work for me. `UUID muuid = device.getUuids()[0].getUuid();` raises an exception. 

**Edit**: I&#39;ve solved that problem by hardcoding the UUID for Serial port service as per [this answer][3] (using `UUID.fromString(&quot;00001101-0000-1000-8000-00805f9b34fb&quot;);`).

I&#39;m further puzzled by why I need to supply a UUID to create an unsecured rfcomm socket using `createInsecureRfcommSocketToServiceRecord(),` but not using the reflection method. 

Can anyone straighten me out?


  [1]: http://www.bluecove.org/bluecove/apidocs/javax/bluetooth/UUID.html
  [2]: https://stackoverflow.com/questions/12485785/nullptr-exception-on-socket-connect-galaxy-tab-2-running-android-4-04
  [3]: https://stackoverflow.com/a/11622794/1286571

Android: How do bluetooth UUIDs work?

I have code that looks like this:

    u := make([]byte, 16)
    _, err := rand.Read(u)
    if err != nil {
    	return
    }
    
    u[8] = (u[8] | 0x80) &amp; 0xBF // what does this do?
    u[6] = (u[6] | 0x40) &amp; 0x4F // what does this do?

    return hex.EncodeToString(u)

It returns a string with a length of 32, but I don&#39;t think it is a valid UUID. If it is a real UUID, why is it a UUID, and what is the purpose of the code that modifies the value of `u[8]` and `u[6]`.

Is there a better way of generating UUIDs?

Is there a method to generate a UUID with go language

I write websocket chat.
How to generate unique id for user?

now i use this code:

&lt;!-- language: lang-dart --&gt;

    id = new DateTime.now().millisecondsSinceEpoch;

is there any more neat solution?

How to generate unique id in Dart

I receive the data as 

       {
            &quot;name&quot;: &quot;Unknown&quot;,
            &quot;parent&quot;: &quot;Uncategorized&quot;,
            &quot;uuid&quot;: &quot;06335e84-2872-4914-8c5d-3ed07d2a2f16&quot;
        },

and I need to convert the `uuid` from `String` to `uuid`

I did not find a way on the [python docs][1], or am I missing something basic here?




  [1]: http://docs.python.org/library/uuid.html

python: how to convert a valid uuid from String to UUID?

I am running automated tests on iOS devices.  I want to not have to always have all devices connected.  So I want to find all device id&#39;s and then only start the process of building, deploying, and running tests if that device is connected.

So my question is, how can I find the device uuid&#39;s of all connected devices through a shell script?

Thanks!

Content Type	Original Author	Original Content on Stackoverflow
Question	user1753862	View Question on Stackoverflow
Solution 1 - Oracle	broofa	View Answer on Stackoverflow
Solution 2 - Oracle	apotek	View Answer on Stackoverflow
Solution 3 - Oracle	StephenS	View Answer on Stackoverflow

UUID max character length

Oracle Problem Overview

Oracle Solutions

Solution 1 - Oracle

Solution 2 - Oracle

Solution 3 - Oracle

What does "&" at the end of a linux command mean?

SQL Update with row_number()

Attributions