I share solution next error.
Edit file from path:
sudo nano /etc/apt/sources.list.d/vscode.list
Comment or change next line on file.
Original line comment or update:
deb [arch=amd64,arm64,armhf] http://packages.microsoft.com/repos/vscode stable main
To:
deb [arch=amd64] http://packages.microsoft.com/repos/vscode stable main
That it is.
References: https://stackoverflow.com/questions/65306968/vs-code-n-skipping-acquire-of-configured-file-main-binary-arm64-packages/65310278#65310278
I share query to get working days monday to friday and saturday 1/2, for example if you hire an employee start to work on (mm/dd/yyyy) 10/15/2020 then you to pay until 10/31/2020, the working day to pay is 13.5, because to omit sunday and sum 1/2 for saturday.
Query:
SELECT
(SELECT (( TRUNC( to_date('10/31/2020', 'mm/dd/yyyy'), 'IW' ) - TRUNC( to_date('10/15/2020', 'mm/dd/yyyy'), 'IW' ) ) * 5 / 7
+ LEAST( to_date('10/31/2020', 'mm/dd/yyyy') - TRUNC( to_date('10/31/2020', 'mm/dd/yyyy'), 'IW' ) + 1, 5 )
- LEAST( to_date('10/15/2020', 'mm/dd/yyyy') - TRUNC( to_date('10/15/2020', 'mm/dd/yyyy'), 'IW' ) + 1, 5 )) + 1
AS WeekDaysDifference
FROM dual)
+(
WITH t
AS (SELECT to_date('10/15/2020', 'mm/dd/yyyy') start_date,
to_date('10/31/2020', 'mm/dd/yyyy') end_date
FROM dual)
SELECT (Count(*)/2) numSaturday
FROM (SELECT To_char(start_date + ( LEVEL - 1 ), 'fmday') dt
FROM t
CONNECT BY LEVEL <= end_date - start_date + 1)
WHERE dt IN ( 'saturday' )) workingDays FROM DUAL;
I share example how to consuming RESTful Web Services from Oracle, methods GET and POST with PL/SQL Anonymous Block, for this example i use http://jsonplaceholder.typicode.com/ json.
I share example how to execute Multi-Threading in parallel on Kotlin, is very useful if you want send a lot process simultaneously, In java you can use parallel stream and exist a lot examples, but it's almost the same.
I use an ExecutorService to manage pools of threads.
import java.util.concurrent.Executors
import java.util.concurrent.TimeUnit
fun main(args: Array<String>) {
println("Started.....!")
var listStr = arrayOf("test1", "test2", "test3",
"test4", "test5", "test6", "test7", "test8", "test9", "test10")
var es = Executors.newCachedThreadPool()
for (item in listStr) {
es.execute {
println("item -> $item")
}
}
es.shutdown()
var finished = es.awaitTermination(1, TimeUnit.MINUTES)
println("\\nFinished all threads $finished")
}
Run test: check test 3 execute after test 4 and test 2 execute after test 3.
import org.springframework.data.jpa.repository.Query
import org.springframework.data.repository.CrudRepository
import org.springframework.data.repository.query.Param
interface MyRepository: CrudRepository<YOUR_MODEL, YOUR_ID_MODEL>{
@Query(nativeQuery = true, value = "SELECT myfunction(:value) FROM dual")
fun myfunction(@Param("value") value: String?): Int?
}
interface MyRepositoryCustom {
fun myFunction(param1: String?): Int?
}
import org.springframework.beans.factory.annotation.Autowired
import org.springframework.jdbc.core.JdbcTemplate
import org.springframework.jdbc.core.namedparam.MapSqlParameterSource
import org.springframework.jdbc.core.namedparam.SqlParameterSource
import org.springframework.jdbc.core.simple.SimpleJdbcCall
class MyRespositoryImpl : MyRepositoryCustom {
@Autowired
lateinit var jdbcTemplate: JdbcTemplate
override fun myFunction(param1: String?): Int? {
val jdbcCall = SimpleJdbcCall(jdbcTemplate).withFunctionName("myfunction")
val paramMap: SqlParameterSource = MapSqlParameterSource()
.addValue("value", param1)
return jdbcCall.executeFunction(Int::class.java, paramMap)
}
}
interface MyRepository: CrudRepository<YOUR_MODEL, YOUR_ID_MODEL>, MyRepositoryCustom {
There are two ways to connect Oracle from shell script.
1. You need to install SQL Plus Client on your server
2. You'll have install ORACLE on your server.
I share example for both.
sudo nano Oracle-ShellScript.sh
sh Oracle-ShellScript.sh YOUR_USER_DB YOUR_PASSWORD_DB YOUR_IP YOUR_SID
With Java 21, Virtual Threads have redefined how we approach concurrency, offering a lightweight and efficient way to handle parallel and ...
