Top "Oracle10g" questions

How do I use CREATE OR REPLACE?

Am I correct in understanding that CREATE OR REPLACE basically means "if the object exists, drop it, then create it …

oracle oracle10g ddl

How to use BOOLEAN type in SELECT statement

I have a PL/SQL function with BOOLEAN in parameter: function get_something(name in varchar2, ignore_notfound in boolean); …

sql oracle plsql oracle10g ora-00904

ORA-01652 Unable to extend temp segment by in tablespace

I am creating a table like create table tablename as select * for table2 I am getting the error ORA-01652 Unable …

oracle10g tablespace

ORA-28000: the account is locked error getting frequently

I am getting the error : ORA-28000: the account is locked Is this a DB Issue? When I unlock user account …

oracle oracle11g oracle10g

check if "it's a number" function in Oracle

I'm trying to check if a value from a column in an oracle (10g) query is a number in order …

oracle plsql oracle10g

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

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

extract date only from given timestamp in oracle sql

The following query: select cdate from rprt where cdate <= TO_CHAR(sysdate, 'YYYY/MM/DD-HH24-MI-SS-SSSSS') and ryg='R' …

sql oracle10g database-administration

Resolving ORA-4031 "unable to allocate x bytes of shared memory"

I need some pointers on how to diagnose and fix this problem. I don't know if this is a simple …

oracle memory-management oracle10g

Oracle DB : java.sql.SQLException: Closed Connection

Reasons for java.sql.SQLException: Closed Connection from Oracle?? java.sql.SQLException: Closed Connection at oracle.jdbc.driver.DatabaseError.throwSqlException(…

java sql jdbc oracle10g