Top "Oracle" questions

Change Oracle port from port 8080

How do I change Oracle from port 8080? My Eclipse is using 8080, so I can't use that.

oracle port

How to kill a running SELECT statement

How can I stop a running SELECT statement by killing the session? The command is continuously giving me output based …

sql oracle select oracle10g sqlplus

Taking the record with the max date

Let's assume I extract some set of data. i.e. SELECT A, date FROM table I want just the record …

oracle date max analytic-functions

Faster alternative in Oracle to SELECT COUNT(*) FROM sometable

I've notice that in Oracle, the query SELECT COUNT(*) FROM sometable; is very slow for large tables. It seems like …

oracle count

Convert comma separated string to array in PL/SQL

How do I convert a comma separated string to a array? I have the input '1,2,3' , and I need …

oracle plsql tokenize

What is the default Precision and Scale for a Number in Oracle?

When creating a column of type NUMBER in Oracle, you have the option of not specifying a precision or scale. …

database oracle number-formatting

set serveroutput on in oracle procedure

I've created a simple procedure. In this procedure i want to output some data. However where ever i put set …

oracle procedure

Creating new table with SELECT INTO in SQL

Possible Duplicate: SELECT INTO using Oracle I have came across SQL SELECT INTO statement for creating new table and also …

sql oracle select create-table

How to connect to remote Oracle DB with PL/SQL Developer?

I have a database "TEST", to which I connect at address 123.45.67.89:1521. How do I connect to it using PL/SQL …

database oracle plsqldeveloper authentication

How to find Current open Cursors in Oracle

What is the query to find the no. of current open cursors in an Oracle Instance? Also, what is the …

oracle oracle10g cursor