Difference between revisions of "Thomas GUILLARD"
Jump to navigation
Jump to search
Line 65: | Line 65: | ||
=== ORACLE SQL === | === ORACLE SQL === | ||
* [http://thomasguillard.fr/wiki/index.php?title=SQL_-_Check_with_regex_if_the_string_text_is_only_composed_of_numbers SQL - Check with regex if the string text is only composed of numbers] | * [http://thomasguillard.fr/wiki/index.php?title=SQL_-_Check_with_regex_if_the_string_text_is_only_composed_of_numbers SQL - Check with regex if the string text is only composed of numbers] | ||
* [http://thomasguillard.fr/wiki/index.php?title=SQL_-_Create_table SQL - Create table] | * ✅ [http://thomasguillard.fr/wiki/index.php?title=SQL_-_Create_table SQL - Create table] | ||
* ✅ [http://thomasguillard.fr/wiki/index.php?title=SQL_-_Date_format_yyyy/mm SQL - Date format yyyy/mm] | * ✅ [http://thomasguillard.fr/wiki/index.php?title=SQL_-_Date_format_yyyy/mm SQL - Date format yyyy/mm] | ||
* [http://thomasguillard.fr/wiki/index.php?title=SQL_-_Date_get_'_first_day_month-1_/_last_day_month-1_/_first_day_current_month_' SQL - Date get ' first day month-1 / last day month-1 / first day current month '] | * [http://thomasguillard.fr/wiki/index.php?title=SQL_-_Date_get_'_first_day_month-1_/_last_day_month-1_/_first_day_current_month_' SQL - Date get ' first day month-1 / last day month-1 / first day current month '] |
Revision as of 11:06, 15 April 2022
💼Linkedin profile
🎁Github profile
👀StackOverflow activity
ACTIVE PROJECTS
ADMIN & SETUP INSTALLATION
LINUX
- LINUX - Install Apache + PHP + Oracle on RedHat7 server
- ✅ LINUX - Find and kill process locking port on Mac
MAC
- ✅ MAC - Format and set up a clean install of OS X
- MAC - Dual boot Windows10+MacOs (on older Mac 2011)
OPEN SSL
DRONE
DOMOTIC & ELECTRONICS
PHOTOS & VIDEOS
IMOVIE
SYNDICATED LOAN'S KNOWLEDGE
LOAN IQ Functional
LOAN IQ Technical
- ✅ LOAN IQ Technical - Start empush (push xml notifier)
- ✅ LOAN IQ Technical - Start accruals
- ✅ LOAN IQ Technical - Start prmtrx
- ✅ LOAN IQ Technical - Logdump
- ✅ LOAN IQ Technical - Shortcuts (into GUI client)
- ✅ LOAN IQ Technical - Add new menu item (into GUI client)
- 🚧 LOAN IQ Technical - XQuery syntaxes
CODING & CMD SAMPLES
IONIC 3
- IONIC3 - Assign content from jquery to typescrypt #hack
- IONIC3 - Solve cordova build android issue (unable to find attribute android:fontVariationSettings and android:ttcIndex)
- IONIC3 - Solve cordova build android issue (Error: spawn EACCES of gradle)
- IONIC3 - Cors issues AccessAllowOrigin
HTML 5
JAVASCRIPT
MEDIA WIKI
OPEN FACE
ORACLE SQL
- SQL - Check with regex if the string text is only composed of numbers
- ✅ SQL - Create table
- ✅ SQL - Date format yyyy/mm
- SQL - Date get ' first day month-1 / last day month-1 / first day current month '
- SQL - Encode/decode function (base64)
- SQL - Get difference between two dates (by year/month/day)
- SQL - Issue with special char like $
- SQL - Group several lines in the same column with LIST TAG