Thursday, September 3, 2020

IBM Watson New project or upload python script

IBM Watson new project 

open  https://cloud.ibm.com/

then from navigator select Watson 


then services 



open Watson Studio 



select your service plan and we will use free service for now


and create it as a first step and for your info service create for free once if u will create again needs upgrade your account


next page click on get started and the previous step u will create it Once

create New Project 

- by click on new Project or there is a recent projects you can find it in Overview 



create Empty Project and storgare selection is disable because we are already select in the beginning the free service  so its default selected 




then project name 



then select add to prject and the tab of asset will be for data files



asset tab


after add to project click select the note book




then create the note book 

add name testx2 then create


or you can select already created python note book file 




now write your python code ;) 




Sunday, June 9, 2019

All The Dates Query

-- ----------------------------------------------------------------------------- -- Query of 79 languages for the 12 Gregorian calendar months, adapted from -- Mattias Rogel's query -- -- https://marogel.wordpress.com/2012/03/23/learning-foreign-languages-with-oracle-sql/ -- ----------------------------------------------------------------------------- with list_of_months AS ( SELECT add_months(date'2012-01-01', level-1) monn, to_char(add_months(date'2012-01-01', level-1), 'MONTH') mon FROM dual CONNECT BY LEVEL<=12 ) -- END OF list_of_months CTE , langs ( language_nm ) AS ( SELECT 'ALBANIAN' FROM DUAL UNION ALL SELECT 'AMERICAN' FROM DUAL UNION ALL SELECT 'AMHARIC' FROM DUAL UNION ALL SELECT 'ARABIC' FROM DUAL UNION ALL SELECT 'ARMENIAN' FROM DUAL UNION ALL SELECT 'ASSAMESE' FROM DUAL UNION ALL SELECT 'AZERBAIJANI' FROM DUAL UNION ALL SELECT 'BANGLA' FROM DUAL UNION ALL SELECT 'BELARUSIAN' FROM DUAL UNION ALL SELECT 'BENGALI' FROM DUAL UNION ALL SELECT 'BRAZILIAN PORTUGUESE' FROM DUAL UNION ALL SELECT 'BULGARIAN' FROM DUAL UNION ALL SELECT 'CANADIAN FRENCH' FROM DUAL UNION ALL SELECT 'CATALAN' FROM DUAL UNION ALL SELECT 'CROATIAN' FROM DUAL UNION ALL SELECT 'CYRILLIC KAZAKH' FROM DUAL UNION ALL SELECT 'CYRILLIC SERBIAN' FROM DUAL UNION ALL SELECT 'CYRILLIC UZBEK' FROM DUAL UNION ALL SELECT 'CZECH' FROM DUAL UNION ALL SELECT 'DANISH' FROM DUAL UNION ALL SELECT 'DARI' FROM DUAL UNION ALL SELECT 'DIVEHI' FROM DUAL UNION ALL SELECT 'DUTCH' FROM DUAL UNION ALL SELECT 'EGYPTIAN' FROM DUAL UNION ALL SELECT 'ENGLISH' FROM DUAL UNION ALL SELECT 'ESTONIAN' FROM DUAL UNION ALL SELECT 'FINNISH' FROM DUAL UNION ALL SELECT 'FRENCH' FROM DUAL UNION ALL SELECT 'GERMAN DIN' FROM DUAL UNION ALL SELECT 'GERMAN' FROM DUAL UNION ALL SELECT 'GREEK' FROM DUAL UNION ALL SELECT 'GUJARATI' FROM DUAL UNION ALL SELECT 'HEBREW' FROM DUAL UNION ALL SELECT 'HINDI' FROM DUAL UNION ALL SELECT 'HUNGARIAN' FROM DUAL UNION ALL SELECT 'ICELANDIC' FROM DUAL UNION ALL SELECT 'INDONESIAN' FROM DUAL UNION ALL SELECT 'IRISH' FROM DUAL UNION ALL SELECT 'ITALIAN' FROM DUAL UNION ALL SELECT 'JAPANESE' FROM DUAL UNION ALL SELECT 'KANNADA' FROM DUAL UNION ALL SELECT 'KHMER' FROM DUAL UNION ALL SELECT 'KOREAN' FROM DUAL UNION ALL SELECT 'LAO' FROM DUAL UNION ALL SELECT 'LATIN AMERICAN SPANISH' FROM DUAL UNION ALL SELECT 'LATIN BOSNIAN' FROM DUAL UNION ALL SELECT 'LATIN SERBIAN' FROM DUAL UNION ALL SELECT 'LATIN UZBEK' FROM DUAL UNION ALL SELECT 'LATVIAN' FROM DUAL UNION ALL SELECT 'LITHUANIAN' FROM DUAL UNION ALL SELECT 'MACEDONIAN' FROM DUAL UNION ALL SELECT 'MALAY' FROM DUAL UNION ALL SELECT 'MALAYALAM' FROM DUAL UNION ALL SELECT 'MALTESE' FROM DUAL UNION ALL SELECT 'MARATHI' FROM DUAL UNION ALL SELECT 'MEXICAN SPANISH' FROM DUAL UNION ALL SELECT 'NEPALI' FROM DUAL UNION ALL SELECT 'NORWEGIAN' FROM DUAL UNION ALL SELECT 'ORIYA' FROM DUAL UNION ALL SELECT 'PERSIAN' FROM DUAL UNION ALL SELECT 'POLISH' FROM DUAL UNION ALL SELECT 'PORTUGUESE' FROM DUAL UNION ALL SELECT 'PUNJABI' FROM DUAL UNION ALL SELECT 'ROMANIAN' FROM DUAL UNION ALL SELECT 'RUSSIAN' FROM DUAL UNION ALL SELECT 'SIMPLIFIED CHINESE' FROM DUAL UNION ALL SELECT 'SINHALA' FROM DUAL UNION ALL SELECT 'SLOVAK' FROM DUAL UNION ALL SELECT 'SLOVENIAN' FROM DUAL UNION ALL SELECT 'SPANISH' FROM DUAL UNION ALL SELECT 'SWAHILI' FROM DUAL UNION ALL SELECT 'SWEDISH' FROM DUAL UNION ALL SELECT 'TAMIL' FROM DUAL UNION ALL SELECT 'TELUGU' FROM DUAL UNION ALL SELECT 'THAI' FROM DUAL UNION ALL SELECT 'TRADITIONAL CHINESE' FROM DUAL UNION ALL SELECT 'TURKISH' FROM DUAL UNION ALL SELECT 'UKRAINIAN' FROM DUAL UNION ALL SELECT 'VIETNAMESE' FROM DUAL ) -- END OF lang CTE SELECT n.language_nm , y.monn , to_char(y.monn, 'MONTH', q'|nls_date_language='|' || language_nm || q'|'|') "month" , to_char(y.monn, 'MON', q'|nls_date_language='|' || language_nm || q'|'|') "month short)" FROM langs n, list_of_months y ORDER BY 1,2

SQL Query to Convert number into Words for Money

SELECT INITCAP ( DECODE ( FLOOR (TO_NUMBER ( :amount)), 0, '', TO_CHAR (TO_DATE...