Categories
Database Development

Is it bad practice to calculate within the insert query?

I am trying to do a web application for time sheets. I have three options to calculate the value of hours (AFAIK): In the form In the backend In the query Is it smart or bad practice to do this calculation in the SQL query? with list as (select code_id,code_ppu from code) insert into hr […]

Categories
Development

Performance issue on 19c

Recently we have updated our database from 11g to 19c. While testing the application in new database version, we have encountered an performance issue for a particular view, which is working absolutely fine, but causing performance issue in 19c. While analysis the plan, we have seen there is a massive change in execution plan that’s […]

Categories
Development

Trouble with a pipe in a bash loop

I have the following problem: temp.txt aaa aab aac aad … I would like to use the data in temp.txt to call a command1 and pipe that to command2, so that the command would look like that: command1 -id aaa | command2 I thought about a bash loop might work: for bla in `cat temp.txt`; […]

Categories
Development

How to segregate the value of a JavaScript objects into Array efficiently?

I have this following JSON data; data=[ { _id: “5b377db0c97f730014b6eb12”, title: “Integrated Compute Platform – Operations Lead”, applylink: “https://www.techgig.com/jobs/Integrated-Compute-Platform-Operations-Lead/60221”, jd: “”, companyname: “JP Morgan Chase Bank”, location: “Hyderabad/Secunderabad”, experience: “5-7 yrs”, salary: “”, type: “”, skills: “Cisco”, startdate: “”, enddate: “”, created: “”, source: “techgig”, timestamp: 1530363306.1030896, __v: 0 }, { _id: “5b377db0c97f730014b6eb13”, title: “angular-ui/ux”, […]