Using PL/SQL (Oracle 11gR2) I want an IF statement that tests if a string contains 1 or more lower-case letters. PL/SQL pseudo-code: declare v_string varchar2
I have installed oracle 10G XE but in the time of installation i may have not enabled the partion option.now when i am running the command select * from v$opt
When using TOAD on Windows 7, it pops up an error: ORA-06413 : Connection Not Open I have Windows 7 64-bit and i can ping to the db ip .
Can any one see what's wrong with this: User ABC: create table def.something ( id number, ref number references def.anotherTable(id) ); create role ROUse
i have an issue with the environment variables for oracle 11g enterprise edition on ubuntu. I tried this, but didn't work Add the following lines to /etc/profi
I started to use Datagrip for my PL/SQL (school) projects that need the use of DBMS_OUTPUT.PUT_LINE. Before this I was using Oracle SQL developer and I was able
I'm trying to log in to: https://localhost:5500/em/login First, I entered my credentials at the bottom right area. Then, I clicked the button. After that, a po
I am running the following in the Scott schema: SET serveroutput ON; BEGIN FOR c_Emp IN (SELECT * FROM emp) LOOP dbms_output.put_line('The record processed by
When I'm trying to import data from excel to Oracle SQL. I keep getting an error Data is not compatible with column definition or is not available for a not n
Query the name of any student in STUDENTS who scored higher than 75 marks. Order your output by the last three characters of each name. If two or more students
I want to select only one row from a table. This row holds the maximum number in the table. I have tried to use MAX Fun but it didn't work for me. I use two ta
We have a new database server on RHEL 7 and Oracle 12c. The old database server is RHEL 4 and Oracle 10g. I need to dump the data using the 12c client from the
I have one requirement START_DATE : 03/01/2018 END_DATE : 31/01/2018 I need a query which will list all the weeks starting date and end date between these two
I am really curious why this happen: Oracle cloud instances cannot communicate by default with each other via private ip within the same VCN subnet. Is it again
In an Oracle database there's a big PL/SQL procedure being executed periodically that copies data from one DB to another one through a database link and it is f
I'm getting this error on vb6 when trying to connect to an oracle database, debugging puts me in this line, oracon.Open, here's my connection string. Provider=
I'm trying to parameterize a raw SQL query for an Oracle synonym (non-entity) in EF 4 and I am having some problems. Currently I am doing something like the co
I have a problem with returning a json object from a REST method in Oracle Apex. Apex puts an escape character in front of every quotation mark and hence the js
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 *
How can we convert a string of any length into a comma separated string with comma after every n characters. I am using Oracle 10g and above. I tried with REGEX