Top "Oracle" questions

How can I change the SID of an Oracle XE instance

I needed to change the SID of an Oracle XE database (not the Service Name) to match a production database. …

oracle oracle-xe sid service-name

Create a Sequence with START WITH from Query

How can I create a Sequence where my START WITH value comes from a query? I'm trying this way: CREATE …

oracle plsql sequence oracle9i ora-01722

ORA-04063: view has errors

I have 3 users (schemas) in my database. User A holds table X I created a view Y for user B …

sql oracle ddl sql-view

Procedure Buffer overflow

I have following procedure which is filling up null values in a column. The procedure works fine if i have …

oracle logging plsql dbms-output

Creating a CTE in Oracle

I am trying to create a CTE in Oracle that doesn't select from an existing table but instead has data …

sql oracle insert common-table-expression

oracle SQL plus how to end command in SQL file?

I have SQL file with few commands. What it the correct way to end lines in the script? Is it …

oracle sqlplus

Datatype of ROWID in Oracle/SQL

What is the data type of ROWID in Oracle/SQL? How is this value stored?

sql oracle rowid

Timezone conversion in PLSQL

I need to convert the sysdate and time to a particular timezone like EST. I can't assume my current time …

sql oracle plsql plsqldeveloper

How to retain block position after a query -oracle forms

I have an oracle form with a data_block which displays 25 items. On the form I have a scrollbar and …

oracle forms oracle10g oracleforms

how do oracle stored procedures (w/ cursors) work?

I have a following oracle stored procedure CREATE OR REPLACE PROCEDURE getRejectedReasons ( p_cursor IN OUT SYS_REFCURSOR) AS BEGIN …

oracle stored-procedures cursors fetch