cloudshell_sqlcl.sh

#
# Print current instances for autonomous db
# Uses $OCI_TENANCY  for compartment id since that is the "root"
#
cat > db.jq <<EOF
.data[] |
    ."db-name" + "\tocid:" + .id ,
    "\t" + ."db-name" + "_low" ,
    "\tORDS Version: " + ."apex-details"."ords-version",
    "\tAPEX Version: " + ."apex-details"."apex-version",
    "\tSDW: " + ."connection-urls"."sql-dev-web-url",
    "\tAPEX: " + ."connection-urls"."apex-url",
    "\n\toci db autonomous-database generate-wallet \\\n\t\t--autonomous-database-id " +  .id + " \\\n\t\t--file mywallet.zip --password <YOURPASSWORD>",
    "\n\toci db autonomous-database generate-wallet--region --file mywallet.zip --password <YOURPASSWORD>",
    "\n\t sql -cloudconfig mywallet.zip admin@" +."db-name" + "_low\n"  
EOF


oci db autonomous-database list --compartment-id $OCI_TENANCY | jq  -r -f db.jq