Top "Oracle" questions

Oracle SQL: Pivot on multiple columns/fields

I want to create a table where the entries of various columns are 'pivoted' to column headers. The table is …

sql oracle microsoft-query

How to add offset in a "select" query in Oracle 11g?

How to add an offset in a "select" query in Oracle 11g. I only know how to add the limit …

sql oracle oracle11g pagination rownum

How to get driver class name (not driver name) from jdbc connection

I have a context.xml file in the below format <Context shallowOutput="true" path="/"> <WatchedResource>WEB-INF/…

java oracle jdbc jndi

Fast Refresh on commit of materialized view

I just created tables DEPT and EMP like follow : create table DEPT ( dept_no number , dept_name varchar(32) , dept_desc …

oracle materialized-views

difference between NLS_NCHAR_CHARACTERSET and NLS_CHARACTERSET for Oracle

i have a quick question here, that i would like to know the difference between NLS_NCHAR_CHARACTERSET and NLS_…

oracle character-encoding ascii utf varchar2

ODP.NET Managed - Unable to find requested .Net Framework Data Provider

Using Visual Studio 2013, I've added the latest version of ODP.NET Managed to a project using Nuget: Install-Package odp.net.…

c# .net oracle odp.net

Insert into from CTE

WITH DTL AS (SELECT CMPI_CODE, CMN_CDTY_MTRL, CMI_WT_FACTOR, CMI_CNTRCT_RATE, 'PL', PRESENT_PRICE, TRM_CODE, …

sql oracle oracle11g common-table-expression

what is the difference between left join and left outer join?

I have created 2 tables as CREATE TABLE table1(customerName VARCHAR(20),custid NUMBER ,order_id NUMBER ,price NUMBER ); CREATE TABLE table2(…

sql oracle join left-join outer-join

How do i execute oracle Query using shell Scripting and send the results in the email

I am new to Unix scripting.. I have an oracle DB which has a username, password, hostname, port and servicename. …

sql oracle shell email spool

How to UPDATE one column using another column in another table? SQL Error: ORA-00933: SQL command not properly ended

I have tried everything I can think of but couldn't solve this SQL error: SQL Error: ORA-00933: SQL command not …

sql oracle ora-01427