MySQL Store Procedure to Loop with Table Cursor and Update with UUID()
This is a sample MySQL store procedure where I loop in all rows in a table and then I update each row with a UUID().
This is a sample MySQL store procedure where I loop in all rows in a table and then I update each row with a UUID().
Sample: Results: OR
This article shows about how to configure the environment variable when SqlPlus – SqlPlus Command start up in order to have always a good behavior in the formatting of the result. You have to setup the Windows – Environment Variable (SQL Plus|SQL Developer)- SQLPATH with a directory. Copy then the file login.sql described below in it. This file is execute each time that you connect to a database with SQLPlus. SQLPATH in Windows environment (Windows Oracle server): HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0\ SQLPATH in…