I'm forced to use Oracle Form Builder 10.1.2.3.0. An ideal control I can use in the form for a particular item is a List Item using a List Style called Combo Bo
I've a strange behavior with oracle and it's seems it causes problem with Security Policies. When I look the V$Session table, some connection "MACHINE" are only
I have just installed a oracle 12c 12.1.0 DB on a linux machine. after completing the installation i tried to login to database as sysdba [oracle@bjorn adump]
I'm trying to solve the Hackerrank problem Weather Observation Station 3 which is stated below: I came up with the following solution: SELECT CITY FROM STAT
I have following incrementing id: create table PATIENT ( PATIENTID INTEGER generated by default on null as identity ( start wit
Query: Query the 2 cities contained in STATION table with the shortest and longest CITY names, as well as their respective lengths (i.e.: numb
I have a table in database with this structure: Username Password Age email Address Phone Number I want to store this table's data manually(not by an input
I have a table in database with this structure: Username Password Age email Address Phone Number I want to store this table's data manually(not by an input
I have been trying for 4 days to: Deploy Oracle Instant Client with Docker. I can give you the Dockerfile but it is 96 lines To use Oracle Instant Client on my
I have a job that runs periodically , and I am not interested in the response ?? is there anyway to make the calling convention , request without waiting for t
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