Top "Oracle" questions

Oracle Database is a Multi-Model Database Management System created by Oracle Corporation.

Oracle SQL query with CASE WHEN EXISTS subquery optimization

I'm using the following query to create a view in Oracle 11g (11.2.0.3.0). CREATE OR REPLACE FORCE VIEW V_DOCUMENTS_LIST ( …

oracle subquery query-optimization select-case
Using 'case expression column' in where clause

SELECT ename , job , CASE deptno WHEN 10 THEN 'ACCOUNTS' WHEN 20 THEN 'SALES' ELSE 'UNKNOWN' END AS department FROM emp /* !!! */ WHERE department = …

sql oracle oracle10g ora-00904
Clear the heading in Oracle spool

I have spooled a file before running the below command and got the output like this, I have set heading …

oracle sqlplus spool
Does ODP.NET require Oracle Client installation

I have to connect Oracle 11g DB from .NET code. For that purpose I installed ODP.NET bur after reading …

.net oracle odp.net oracleclient
How to create cursor inside procedure body in plsql

I want create cursor inside procedure body dynamically also i have to use for loop instead of below code. i …

sql oracle plsql plsqldeveloper
How to create copy of full schema on same database in oracle

I want to create full copy of the schema on the same database. What is the best technique to do …

oracle oracle11g oracle10g database-administration
How to get SID, Service Name and Port for Oracle database?

I have oracle database running on address xx.xx.xx.xx I know login, password and initial catalog I am …

oracle database-connection connection-string tnsping
Sqlplus oracle : How can I run sql command on bash in 1 line?

Can I convert this into 1 command line on bash in sqlplus? cause i want to automate it. sqlplus / as sysdba …

oracle sqlplus
ORA-02085: database link DBLINK_NAME connects to ORACLE

I m having a database by name 'HBHAWANI' on my domain server name 'HBHAWANI' (version Oracle 8i). Whenever I try …

oracle dblink
Change password in SQL Developer after ORA-28001 the password has expired

When trying to connect to my database with Oracle SQL Developer, I am getting the error: ORA-28001 the password has …

oracle oracle-sqldeveloper