Top "Oracle" questions

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

How can I connect to Oracle Database 11g server through ssh tunnel chain (double tunnel, server in company network)?

I have SSH access to 'public' server, which is also the gateway to company network. There is another server in …

oracle ssh database-connection ssh-tunnel
Split comma separated values of a column in row, through Oracle SQL query

I have a table like below: ------------- ID | NAME ------------- 1001 | A,B,C 1002 | D,E,F 1003 | C,E,G ------------- …

sql oracle split comma
ORA-01219: database not open: queries allowed on fixed tables/views only

I Am using oracle 11g and SQL developer tool. When i tried to retrieve rows from db i am getting …

database sql oracle database-administration
Oracle equivalent to SQL Server DATEPART

We need to get the HOUR out of a DATETIME column (expecting values from 0 to 23 to be returned). Is there …

sql oracle date datepart
How to prettify the output coming from the SELECT query in command prompt?

I ran the simple select query in the command prompt,but the output rows are not coming in a single …

oracle sqlplus
Escaping single quote in PLSQL

I want PLSQL to generate strings like: COMMENT ON COLUMN TABLE.COLUMN IS 'comment from database'; My solution is: declare …

oracle plsql
SQL multiple SELECT query with xmlagg function- Data not pulled in the required fashion

My data in Oracle is something like this NAME | DEP_VALUE | ID_DEP Amy 1 AA1234 Bob 2 BB4321 Clara 1 CC5678 Clara 2 …

sql oracle select grouping sqlxml
Calling a stored PROCEDURE in Toad

I have a defined a new stored procedure but get a error while calling it, CREATE OR REPLACE PROCEDURE SCOTT.…

oracle stored-procedures toad
How do I do a manual uninstall of Oracle?

Sometimes my Oracle database on Windows gets hosed. How do I do a manual uninstall of Oracle?

database oracle oracle10g uninstallation oracle9i
Selecting the second row of a table using rownum

I have tried the below query: select empno from ( select empno from emp order by sal desc ) where rownum = 2 This …

sql oracle oracle10g rownum