Top "Oracle" questions

What is the dual table in Oracle?

I've heard people referring to this table and was not sure what it was about.

oracle dual-table

Split String by delimiter position using oracle SQL

I have a string and I would like to split that string by delimiter at a certain position. For example, …

sql oracle split substring delimiter

Oracle "(+)" Operator

I am checking some old SQL Statements for the purpose of documenting them and probably enhancing them. The DBMS is …

sql oracle join outer-join

Granting DBA privileges to user in Oracle

How do I grant a user DBA rights in Oracle? I guess something like: CREATE USER NewDBA IDENTIFIED BY passwd; …

oracle oracle11g

How to add 'ON DELETE CASCADE' in ALTER TABLE statement

I have a foreign key constraint in my table, I want to add ON DELETE CASCADE to it. I have …

sql oracle

PLS-00201 - identifier must be declared

I executed a PL/SQL script that created the following table TABLE_NAME VARCHAR2(30) := 'B2BOWNER.SSC_Page_Map'; I …

oracle function plsql

Force index use in Oracle

I encountered this question in an interview and had no clue how to answer: There is a table which has …

sql oracle indexing sqlplus

Oracle - What TNS Names file am I using?

Sometimes I get Oracle connection problems because I can't figure out which tnsnames.ora file my database client is using. …

oracle connection tnsnames tns

How to Query Database Name in Oracle SQL Developer?

How do I query the database name in Oracle SQL Developer? I have tried the following and they all fail: …

sql oracle oracle-sqldeveloper

How to SELECT in Oracle using a DBLINK located in a different schema?

We have an Oracle DBMS (11g) and the following configuration: A DB user "MYUSER" Two schemas "MYUSER" and "SCHEMA_B" …

database oracle database-schema dblink