I just installed a new Oracle 19c single instance database and I cannot connect to it, and I'm not sure how to debug the problem. I defined the SID to be "globa
I have a SQL Plus script, with a code containing: host if not exist &&mksubdir (mkdir &&mksubdir) where &&mksubdir is a string in double
I followed the instructions mentioned to install SQL*Plus from Oracle Instant Client and How to Install SQLPlus. SQL*Plus is successfully installed on my syste
When I run the following query, I get ORA-00934: group function is not allowed here what is the problem ? select c.Numcom,c.Nompr,c.salaire_fix from com
I ran the simple select query in the command prompt,but the output rows are not coming in a single line. See below: SQL> set pagesize 2000 SQL> select *
I am executing a SQL script which has spaces, semicolons, single-quotes, special characters etc. in of the column called prod_desc. I need to execute the script