I can't create a DBLink from Oracle XE 18c to SQL Server 2017 Express! I have an instance of Oracle XE 18c on my server centos 7.6 and an instance of SQL Server 2017 Express, both working properly. I'd like…
With Oracle SQL-Developer I'm able to connect to my VMware CentOS 7 Oracle database ORCL. if I try to connect with SQLPlus I'm told the realm doesn't exist. Any idea as to why I can connect with Oracle SQL-Developer and…
I am struggling to connect my PHP application to an Oracle database. I have tried multiple options over the last week with no success. I have managed to install oci8 extension but the oci_connect function is not recognised. Please assist.…
so i have an ORDS endpoint (Oracle Rest Data Services) that receives a JSON payload from Facebook API, and a variable, X-Hub-Signature, which comes in the header of the request. i have to validate the request i receive, so i…
Good evening everyone, I'm working on a assignment and can't figure out the following, I have two tables: CREATE TABLE Rental ( rental_id DECIMAL(12) PRIMARY KEY, customer_id DECIMAL(12), movie_id DECIMAL(12), delivery_status VARCHAR(64), return_status VARCHAR(64)); and CREATE TABLE Movie ( movie_id…
I am new to SQL and am practicing on the HR schema available on Oracle 10g XE. This is the question: Write a query to select the name, job, and salary and department number of all employees except Sales Rep…
I have a table software (id_software, software_name, category) What SQL query to show only 2 software for each category ? For example I want to get : |id_software | software_name | category| -+------------+---------------+---------+- | 1 | Photoshop | 5 |…