Categories
Database Development

alternative IN condition on SQL

i have query like this select name, time_attandance from "VIEW_GO_EMP" "viewGoEmp" left join "VIEW_ATTENDANCE" "viewAttendance" on "viewAttendance"."EMP_ID" = "viewGoEmp"."EMP_ID" and "viewAttendance"."SHIFTSTARTTIME" <= (sysdate + nvl("viewAttendance"."GRACE_EAI", 240)/(60 * 24)) and ("viewAttendance"."SHIFTENDTIME" + nvl("viewAttendance"."GRACE_LTO", 660)/(60 * 24)) >= ‘2020-10-26 08:04:12.000’ left join "TTADATTSTATUSDETAIL" "ttdttsttsdtls" on "ttdttsttsdtls"."ATTEND_ID" = "viewAttendance"."ATTEND_ID" and "ttdttsttsdtls"."ATTEND_CODE" in (‘ANL’,’FCM’,’LOL’,’MAT’,’OFF’,’PFP’,’PIL’,’PL’,’PNI’,’SDC’,’SWC’,’TRANSPORT_LEMBUR’,’OVT_MEAL_HD’,’VLD’,’TOTAL_MENIT_LTI’,’OVT_MEAL_WD’,’CAP_DDR’,’CAP_KIM’,’CAP_KISK’,’CAP_MSC’,’CAP_MP’,’CAP_KBA’) and "ttdttsttsdtls"."COMPANY_ID" = 18898 left […]

Categories
Mastering Development

jq display key names and their child element lengths together

I would like to display an arbitrary object’s key names and the lengths of their constituent parts. I think that my trouble appears to be with ‘length’ requiring a filter, which mutes other output. Given foo.json contains: { "lol": 1, "wtf": [1, 2, 3, 4], "bbq": { "omg": "yes", "afk": "always" } } I can: […]

Categories
Ask Bitcoin Gambling Promo Codes eSports Promo Codes

CSGOPositive Promo Code

CSGOPositive.com – Modern eSports betting platform. “CSGOPositive is modern service for betting on eSports using skins or money. CSGO, DOTA2, LOL, Artifact. Cashback, team statistics, fast support and much more.” CSGO Positive Referral Code CSGOPositive.com Promo Code: limit

Categories
Ask Cooking & Recipes

Wombsday Prepping

I do love me a good, funny euphemism. Okay, so before I go any further, as you can see from the above pic, today’s conversation is going to be about mother nature’s curse upon all women, so male readers probably won’t want to tune in for this particular post. And no, you won’t be berated […]

Categories
Ask Bitcoin Gambling Promo Codes eSports Promo Codes

Thunderpick Betting Promo Code

Bet on Esports with Thunderpick Promo Code: limityt or use this link. “Bet on CS:GO, Dota 2 and LoL eSports matches with Thunderpick. Betting platform offering Best Odds & Fast Withdrawals. Get up to 500€ bonus on your first deposit” Thunderpick Referral Code Thunderpick.com Promo Code: limityt

Categories
Mastering Development

Write a code for the following program.to find the solution to it

Secret Word Problem Description A computer scientist has developed an encryption algorithm. This algorithm takes two inputs – one plain word and another, a key. Characteristics of inputs are as below. Plain word: It is a string consisting of lowercase alphabets only. Key: It is a set of pairs of strings consisting of lowercase alphabets […]

Categories
Mastering Development

Removing required field from JSON schemas

I have a JSON and need to generate a schema. I am using GenSON for the same. JSON file { “Management”:{ “Name”:”Not Available”, “Address”:”192.168.102.117″ }, “Tag”:”23″, “host”:”192.168.102.117″, “ware”:{ “BOSSS”:{ “id”:”BOSSS1″, “Version”:”13.3022″ } }, “lock”:””, “quarantine”:0, “Faces”:[ { “NICK”:[ { “Description”:”Integrated N”, “LOL”:”NICk.Integrated.1-1-1″, “Something”:”something” }, { “Description”:”Integrated 1″, “LOL”:”NICk.Integrated.1-1-1″, “Something”:”something” }, { “Description”:”P”, “LOL”:”NICk.Integrated.1-1-1″, “Something”:”something” } […]

Categories
Mastering Development

Java config, need return function7

I have a config.yml file like this below: How do I write a function that returns spawn, lol, xd, Warpa, Warphei? I know that for example if I want to get X inside spawn I can do this plugin.getConfig().getString(“spawn.X”); I just don’t know how to list all of the names. spawn: World: world X: 80.96770114181192 […]

Categories
Linux Mastering Development Ubuntu

Thinkpad T480 not taking a charge anymore

Update And, now with no explanation, it’s working… Update Now I don’t get a charge at all: Any help would be incredible. I’ve got through the power reset, remove battery, check connections and all that. Doesn’t seem to help. Tried different outlets, lol, and lots of other random things. No luck. I’ve got Ubuntu 18.04 […]

Categories
Linux Mastering Development Ubuntu

Thinkpad T480 not taking a charge anymore

Update Now I don’t get a charge at all: Any help would be incredible. I’ve got through the power reset, remove battery, check connections and all that. Doesn’t seem to help. Tried different outlets, lol, and lots of other random things. No luck. I’ve got Ubuntu 18.04 on a Thinkpad T480, but some time ago […]