Top "Oracle" questions

HOW TO get records with given rowid list IN STRING from a table (Oracle)?

Any one can help me to resolve the FIXME ? -- Task: Get records with given rowid IN STRING from a …

sql oracle rowid

How to exclude certain tables from Oracle datapump export

I have a large number of user schemas in my Oracle database. I wish to export the table data for …

oracle oracle11g datapump expdp

connect by clause in regex_substr

I cant get the understanding of this statement - not eveN after googling around pv_no_list :='23,34,45,56'; SELECT …

sql oracle oracle10g

Get the LENGTH of a LONG RAW

I have a table with a column of data type LONG RAW. How do I determine the size (in bytes) …

oracle ora-00932 ora-00997

Best solution for migration from Oracle Forms 6i to the web?

I work in an Oracle shop. There's a toolset that consists of roughly 1000 Oracle Forms (using the Forms builder from 6…

java oracle migration oracleforms

LOBSEGMENT objects filling up my tablespace in Oracle

I'm using a Oracle 10gR2 DB, and was taking a look in one of my tablespaces when I noticed something …

oracle view blob tablespace

Migrating Oracle Database with expdp and impdp

Does the target database need to be prepared with tablespace and/or user (schema) in order to successfully migrate a …

oracle oracle11g database-migration impdp

Export from Oracle 10g database with 11g client

Database Version : 10g Enterprise Edition Release 10.2.0.4.0 Client Version: 11g Enterprise Edition Release 11.2.0.1.0 (windows 7 64bit) When I try to export (exp) …

oracle oracle10g oracle11gr2 datapump

ways to avoid global temp tables in oracle

We just converted our sql server stored procedures to oracle procedures. Sql Server SP's were highly dependent on session tables (…

oracle plsql temp-tables

How to use SELECT... INTO with a JOIN?

I have the following example code DECLARE myRow table%rowtype myVar table2.column%type BEGIN SELECT table.col1, table.col3, …

sql oracle join plsql select-into