View Full Version : answers
Pages : 1 2 3
[
4]
5 6 7 8 9 10 11 12 13 14
- How to improve the deletion rate.
- Disable Rollback
- windows 2003 and oracle
- WTD: Oracle DBA Cert classes w/ Cert pass guarantee - OCP test prep class?
- Numeric overflow
- bulk execute procedure using odbc
- Oracle workaround to the STUFF() MSSQL Function?
- Bulk-bind input and output host arrays to index-by tables
- Oracle Help System
- Will copying Oracle home directory install Oracle 9i on RH linux 9 system ?
- Installation of Oraclewarehouse Builder
- Shared Physical Storage .. in Windows Server systems
- ODBC produces logoff event?
- Index and foreign key
- Loading xerces parser in oracle 9i
- get default funtion of a column
- ODBC drivers, .NET providers, OLE DB providers, JDBC drivers: updated lists
- Sample to pull data from Oracle proc into an html table
- NullPointerException freeing temporary CLOB
- Anybody using OEM to monitor MS SQLServer?? Need some tips!
- JDBC driver problem
- Help me, i m unable to install oracle 9i on redhat 9.0
- Spool
- Database link: Wrong column length from cursor
- Where do SQL/PL programs execute from ?
- re-numbering pimary-key
- Where to find Demo database with gnarly PL/SQL?
- OCI bug - ofetch hangs
- EXECUTE IMMEDIATE help
- SQL Batch Script from MSSQL to Oracle 8i
- Moving a table from one tablespace to another tablespace
- Bulk Inserts
- Oracle 9i OEM login NullPointerException to OMS
- How to create a descending index on the primary key.
- SQL Loader
- its a basic SQL command but require help ?
- Basic idea od Crystal reports
- 9.2 init.ora file on XP
- validate password within PL/SQL?
- External Tables binding to Access?
- changing date format in update statement
- procedures and table scope... PLS-00201
- XSU insert into view with object type
- Update Problem
- UTF-8 and Pro*C
- Bulk Updates in Oracle from XML File
- RAID
- Oracle 9i personal on Windows ME
- running utl_file
- running utl_file
- Storing/retrieving BLOBs with JSPs
- /usr/lib/dld.sl: Unresolved symbol error
- Solaris expert needs to break into as entry-level Oracle dba
- SQL statement monitor/logger
- oo40 - number type and ODynaset
- dbms_alert_info table access from a schema
- How to know in a unix script if oracle procedure executed or failed?
- help needed to write a oracle function that can do this...
- Pass variable to Oracle Query form Crystal Reports
- CREATE TRIGGER odditiy
- Oracle 8.1.7 hsodbc agent on Tru64 UNIX 5.1B
- Where is OUI
- need help with PL/SQL Procedure
- TNSLSNR.exe - Application Error
- how to write a function to call this VB script
- case, nvl and datetime fields
- Strange TNS problem
- LDAP attribute list
- XMLType insert
- Full Time Database Consultants Needed
- can I remove jdk directory from C:\orant?
- Try on these security package
- Oracle Query
- DiskSuite RAID5 performace
- Loading from XML to Database
- Install this corrective update from the Microsoft
- Oracle's Mission Statement
- Designer Forms: Linking update module component / stand-alone list of values
- JDBC driver setup in UNIX
- Looking for OAS 4.0.8.2 SW
- 9ias, fully qualified host name?
- Cursor, Fetch, and while...
- Need help to understand difference, and contrast between Relational database model and the Object-Oriented model
- 2nd CFV: comp.databases.etl
- Oracle 9i problem
- SQL_TRACE Output Location
- ORA-01026: multiple buffers of size > 4000 in the bind list
- OMWB
- Listener Configuration in Oracle 9i
- ORACLE 9 and Solaris 5.6
- Dynamic SQL with PROC/C++ problem
- Lock table only allow INSERT
- Max number of records can be fetched in oracle in one call
- 8i and SuSE 9 Pro
- More Help Required.. in Replication of Oracle 9i in Rh9 (if the query is repeated by me sorry)
- How to emulate WRITETEXT / Writing to LONG fields
- Oracle upgrade advice
- WinPure .. List Cleaner .. Opinions/Recommendations?
- redirect SQL Trace output
- Index on Number & Varchar2
- Index on Number & Varchar2
- SYSRESV Utilitity for Windohs??
- select next highest salary or last login date ...
- Standby database on Standard Edition
- keyword override
- Install problem on Redhat
- how to install oracle 9iR2 on windows 2003?
- Question on debugging TNS-12560
- Beginners problem with assigning object methods.
- ORA-06530 - Uninitialized composite on dbms_fetch for pipelined table function
- No Data found error
- establish oracle connectiviy with oracle
- will Oracle 8i run on Novell Netware 5.0
- Addition of constraint during creation of table
- RFD: Periodic FAQ & Charter post
- Static to Dynamic linking
- Passing Java object as parameter to the java stored procedure
- Bug of function-based index
- new to reports 6i
- How to say it in SQL?
- Monitor SQL queries
- Fatal NI connect error 12560, connecting to:
- 816 proC on debian linux; mathcalls.h issue?
- Error changing Character Set
- ODBC for 8i Single user version
- TNS 12545 urgent !!
- [beginner] sequence
- IMPORTANT DEPENDENCIES QUESTION IN ORACLE.
- US - NJ - NY -- Urgent Requirement for Oracle OLAP developer(s) / consultant(s)
- Statistics information
- cursor problem
- Q: Oracle Forms on WinCE
- Help: Forms 6 Template
- trigger problem
- Oracle 9i Database Server on Windows 2003 Server
- how to use select clause in assignment
- migration from oracle 8i to 9i
- CLOB/NCLOB help needed please.
- Connecting to default oracle instance
- Hot Backup Question
- VARCHAR variable in where clause
- Sql select question
- thanks
- Help with returning XML from Oracle function to JSP
- regarding some databse design rules
- sql*loader utillity for importing text file into oracle
- Remote Function Call: Internal Error
- MERGE over db-links
- OFFSET function in oracle
- WTB: Oracle 8i CBT training CDS
- PLS-00201: identifier 'P_TEST_DEL_VAL_ERR' must be declared
- How to backup a 2 Tb Oracle data warehouse ?
- automatic shutdown/startup
- Updating LONG columns
- Using Veritas Netbackup with Oracle Export/Import
- OCI LOBS and AQ, help needed
- MINUS operator - How it works.!!??
- Complex Searches
- RE: Upgrade from 8i to 9204
- ORA-01840: input value not long enough for date format
- Oracle9i Forms Class
- Oracle Java Certification
- Error: ORA-01704: string literal too long
- Fast retrieval and display of results to web browser
- Migrating Oracle 7.3.2 to 9.0.1
- Refcursor value is invalid
- Session Defaults
- Traversing, while keeping a constant
- Conceptual modeling like in the book
- Reading flat files from pl/sql
- XML DB Repository Update Contents
- Take a look at that important package from the MS Corp.
- SQL Formatter
- minus and intersect functionality
- recomendations for web-based application functional design & project tracking tool?
- insert and select in one statement
- Seeking rhel3_pre_install.sh or p3006854_9204_LINUX.zip
- Oracle Financials - security
- Ora-942 in stored procedure
- oracle designer
- Re: Check that important patch from the MS Corp.
- Oracle 7, Indexes
- Can sqlldr append to bad file?
- Libcltsh.so not available for install on Oracle 9i Client for openVMS
- idle time
- variable datatype returning
- Materialized views are not getting refreshed
- Newbie Question: CLOBs, LONG and text fields
- Extract the beginning of a string
- Client 8.0.6 doesn't work on win XP
- where is tkprof in 9.1
- connectivity - integration Oracle - SQL server
- How to prevent "Oracle8 ODBC Driver Connect" dialog from appearing?
- Take a look at that corrective update
- connecting c,c++ to oracle in windows or dos
- Re: Oracle 9i software- for DBA exam
- How to use index
- SQL question / Multiple rows output in one line
- Privileges On Procedures/Functions/Packages
- Seeking Patch 3006854 (p3006854_9204_LINUX.zip) to install Oracle 9i under Red Hat Enterprise Linux 3 ES/AS
- ODP.Net vs OO4O
- Citrix Metaframe and Oracle 7 Client
- can't login to oracle dba studio as sysdba
- Oracle and Windows Server 2003
- Red Hat personal roadmap on the skids. Whither my dev box?
- Limit the levels for a query with CONNECT BY
- Stored Procedure Syntax to Copy data from Server to Server
- New Oracle monitoring tool ... Sorry :-) here is the webpage
- New Oracle monitoring tool ...
- discontinued XCOFF64 file
- SQLMENU50 :: user not authorized to use SQLMENU
- Procedure builder 1.5.8 (forms 6.0.8)
- Data mining/Data Warehouse on Web services
- moving items between databases
- Re: error opening oracle*terminal file frmweb
- Choosing DBMS and architecture for ecommerce website
- Transaction hangs
- After a few minutes of querying the database my session disconnects abruptly. Can som
- What is the maximum number of tablespaces that contain data for a table containing tw
- To use C sort routines in the server side packages which file must contain support fo
- Which clause in a create user statement restricts the number of tables a user can add
- Into which file do records rejected by Oracle due to primary key constraint violation
- How can I improve performance of queries on tables containing all words in the dictio
- In which database memory areas is SQL and PL/SQL parse information is stored?
- I am attempting to take tablespace offline and receiving the following error: ORA-
- In which table is Oracle database audit information stored?
- 1. Do you know in which tablespace the tables that store information about the Oracle
- Why length()/dump() return different substring length values ??
- Open twice (or more) the same cursor
- Newbie could use some help on a simple(?) recursive query.
- Third party utility for encryption and full text search
- oracle on OS X 10.2.8
- Newbie question on ORA-12560
- query tuning
- Boss doesn't understand Oracle ...
- Re: oracle JDBC - how to detect uncommitted work on an open Connection?
- sql using full table scan instead of an index
- Removing Leading Zeros Using SQL
- Oracle JMS problem
- Enterprise Manager 2.2 on NT4 gathering from HP/UX11 and 8.1.7.4
- procedure compilable over db link?
- Re: Uploading file
- Oracle Sql Optimalization
- Errors after creating FBI
- Oracle Visual Basic Connectivity
- bdp or odbc?
- Oracle 8i Cursors via JDBC
- OODB References
- count (1) and count (*)
- Parsing form fields using pl/sql - not a newbie, but this one has me stumped.
- Re: utl_file.fopen and Oracle v9
- DBA role
- UTL_FILE.OPEN problems
- Looking for a Gig Consulting or Full-Time
- Passing a space as an argument to SQL*Plus
- Keyword delimiters
- Re: ORA-06508 on Citrix Metaframe XP with Oracle 8.1.7
- load file to clob using loadfromfile(oracle8.1.7),but the length of file and clob is not equal
- Refer to block item using string
- how to select all rows where a colums has null
- reg oracle 9ids report printing
- Remove Duplicate Rows without a Primary Key
- Re: CLOB.createTemporary throws ClassCastException...
- optimum datatype for primary key column O9i
- problem with dbca on Oracle 9i R2 9.2.0.1.0 Linux
- How to implement 'search' similar to Google
- My attempt to read the view creation code stored in the Oracle data dictionary has en
- Which Oracle dictionary view gives information about the position of a column in a pr
- Does PL/SQL allow cursors to contain subqueries?
- What are two components of the Oracle database security model?
- Having problems running query in Oracle
- [Q] oracle spatial functions
- Check this correction patch
- TEMP Tablespace Question
- sql comparison and flag
- "HAVING" problems with query and using 'having' with group by
- What is the efficient way to select data from huge database?
- Take a look at this pack for Windows
- simple question about sql*plus
- simple question about indexes
- db2 vs oracle
- Wich newsgroup ?
- FWD: Watch the corrective pack
- Install this update from the M$ Corp.
- troubles with oracle on a 2k controller domain
- Re: ORA-06508 on Citrix Metaframe XP with Oracle 8.1.7
- Oracle 8.1.7 on Windows 2003 Cluster??
- Secure JDBC connection to Oracle 9i
- Unable to enlist in a distributed transaction Error in COM+ with Oracle DB
- Export dump files and stripe-sets
- Forms 9i - LOV icon doesn't show up. Does anyone know why?
- How to assign a value to a variable
- Oracle Tools - Auto Commit Feature
- ISQL*PLUS SESSION TIMEOUT PROBLEM
- updating table with two images
- Oracle 9i and Connectivity
- trouble shooting oracle instance
- Re: Oracle on Solaris-Intelx86?
- Page Processing Efficiency
- **HELP** Calling Oracle Stored Procedure from vbs script
- d2k installation
- oracle 8.1.7 + linux .trc dump
- How to start an oracle instance
- Re: Oracle on Solaris-Intelx86?
- Looking for scenario simulation tools for Oracle
- OWB gives ora-00942: table or view does not exist EVEN if the table exist
- Are there any contentions in Latchs?
- Oracle8i Client 8.1.7 Installation
- Oracle vs. SAS numerics - any ideas?
- Snapshot from DB2
- Re: issue of connecting oracle forms with sql2000
- Oracle Forms XML DTD available?
- Query tuning help, please
- Oracle 8.1.7 Client Install On Windows 2000 Working
- Oracle 8.1.7 Client Install Problem On Windows 2000 - Download, No CDs.
- blob dispaly using psp
- How to do Media Recovery for System01.dbf????
- install orcale 9i in red hat 9
- Can Crystal Report access Oracle on Linux ?
- does ORACLE support WMI?
- Oracle9ias SSO/Infrastructure installation error.
- Difference execute immediate within PL SQL
- ARCH is FULL
- Problems with "IN"
- what is the meaning "latch" in the shared pool and library cache?
- index stats
- stats on indexes
- loss of performance when using anonymous pl/sql blocks?!
- How to read UNCOMMITED data in Oracle?
- Help with sqlplus in Oracle.
- Slow Crystal Reports with Oracle
- Use SET ROLE in Oracle Forms Builder
- Does Oracle + VB is a good combination
- Oracle 9i client connectivity to Oracle 7.1.4
- remote server access - ORA-01034:
- On the subject of Data Warehouses, Data Cubes & OLAP....
- what is the meaning of creating database link but omit using clause;
- after set db_domain parameter,but can not resolve database link problem.
- Re: Error While changing the session parameter NLS_LANG
- JDBC with mulitple instances of database
- lenth of SQL statement
- Re: Error While changing the session parameter NLS_LANG
- Integrating crystal reports with oracle forms
- Oracle 9i database for Solaris 8 intel
- How to enable TNS trace
- Why does Windows XP not support Oracle 8i?
- Star Transform condition?
- "database not open" - Rookie
- Oracle Upgrade problem : from 8.1.6 to 8.1.7
- Install these package that comes from MS Corp.
- sql question
- Oracle Applications - Activity Based Management
- How to fix? ORA-22990: LOB locators cannot span transactions
- oracle plsql & cvs
- OG-00637 Unhandled PL/SQL exception 102098
- Oracle 9i Installation on RH Linux 9
- Oracle takes the wraps off SME database
- Create Primary Key on View
- REF Cursor returned across db link?
- DBMS_DEBUG
- I cannot install Oracle8i client on WindowXP, please help.
- sql*loader - partitions - domain index
- ORA-01503: Create controlfile failed
- Help with DECODE function and crosstab query
- oracle applications 11i installation on Linux 9
- Check out these security package from the MS Corp.
- Basic Sql performance question
- Oracle 9i does not install (with a Mandrake 9.1)
- Inserting old value into a column
- Raw on Linux
- Oracle Failsafe Question
- Starting database up...
- Installing Ora9i on Windows XP
- Running Oracle database on Unisys OS2200
- [WEIRD] Merge date and char
- How to retrieve temporary BLOB value from PLSQL to Java?
- Grant Previleges to Objects and Varrays
- restore Issue
- update using an alternative to correlated subquery
- stored procedure, cusor help
- Unsigned integer to IP address?
- How do I get an array into a resultset
- table name substitution in pl/sql
- Oracle readies CRM and supply chain upgrades
- Seeing double output in SELECT SYSDATE FROM DUAL
- Seeing double output in SELECT SYSDATE FROM DUAL
- Seeing double output in SELECT SYSDATE FROM DUAL;
- Oracle Database 10g. When ?
- Importing specific tables from a full export ?
- Oracle 8.0 Copy long from 1 table to another
- MINISOFT
- Database Integration Question
- RAC - rebuild 2nd Node
- global temporary table --> invalid ROWID?
- Changing table size
- Oracle XML
- Re: Taste this critical pack
- Move BLOB partitions to a different tablespace
- Books on Oracle Insall / Configurations
- selecting ROWNUM causes query to take forever
- Difficulty to interpret a TKPROF output
- parameters.add in .NET (Bind problems?)
- Question about Partitions and Indexes
- puzzling deadlock
- Instant legal US University Bachelors & Masters in Database $100. Accredited and Verifiable
- SIGBUS and SIGSEGV Errors in HP-UX 11 and Oracle 9i
- Who spawns a dedicated server process?
- Oracle login error from the web
- Can I delete some statisitcs table(s) from Oracle to tune it?
- Oracle DBA Opportunity
- Help installing Oracle 9i after installing Discoverer
- Oracle home selector
- Errors per user session!
- Oracle export table to ascii
- how to change this query, so that it will not use the correlation?
- Re: Import Error Code IMP-00069, Please help.
- How to imp from oracle 8.1.7 to 8.1.6 in Unix?
- Oracle 8.0 - Can't use function index
- Oracle certification exam preparation
- Help with MIN field value
- Third party indexing solutions
- OCI DirPath
- trim(' ') problem & ORA-03113
- Forms 4.5 login -- cannot type username or password
- 9.2.0 migration now cant log into Apps
- PUBS Database
- Question about deleting table duplicates
- Oracle stored proc. from VB in ADO
- Need an algorithm to process nodes in a tree recursively
- How to find PINNED tables/indexes etc?
- query oracle_home in sqlplus
- combining rows from 2 tables
- one code for two tables
- case question
- Distributed database question
- Partitioning and Tablespaces
- Best practices: commit by database layer vs. commit by caller
- Unistall Oracle with Faulty Uninstaller
- How to display a BLOB/CLOB in Oracle Forms?
- OCP is not enough, need extensive experience
- Re: Company thought DB2 will be better than Oracle.
- Linked Servers
- Isolation level on Ora 9i
- ORACLE 9.2.0.4.0 + LINUX SLACKWARE 9.0 = SUCCESS
- Oracle DBA: Where do I start?
- Oracle Long mapped as CString
- 8i to 9i upgrade
- Please help: Oracle9i/AIX5.2/Veritas vxvm raw devices Problem
- Oracle Real Aplication Cluster
- Oracle Real Aplication Cluster
- Help needed in SQL Query for Hierarchy
- saving files as LOB to Db
- Oracle JDeveloper 10g Preview is out - includes many PL/SQL features
- Oracle 8i on WinXP?
- Getting structure of a table in query format
- How to create a SIMPLE distributed database in Oracle??
- what is the difference to use the password file and normal account to login?
- Problem with MERGE and database link
- ora-01031 insufficent privileges
- She doesn't want the ODBC users to see system views/tables via M$ Access.
- How tough can I be for the user PUBLIC?
- Diagnosing Transaction Enqueue (TX) Locking Issue
- Company thought DB2 will be better than Oracle.
- Re: XML problem on appendChild
- Prcedural replication issue
- external table
- RMAN restore with Windows
- Oracle vs. Informix
- question about password file
- number defined being truncated in select (sorry double posting ;-( )
- ORA-04030 with PGA_AGGREGATE_TARGET
- control file not created at the time of installation
- SS7 to Oracle 9i Migration Problems
- How to query a string containing an apostrophe ?
- Default User on Windows
- Contract Opportunity - Ottawa
- Conditional printing depending on number of returned rows
- Cannot connect as Internal....?
- How to write the select query on self referencing table.
- Integrity constraints with type inheritance
- Oracle Recover/Restore
- How to disabled all constraints when importing data (urgent)
- How to disabled all constraints when importing data (urgent)
- ORA-01000 maximum open cursors exceeded
- ora-01033.oracle initialized or shutdown in progress
- Oracle x SQL
- Help query
- MS Word to Blob
- Newbie basic SQL question.
- re:restricted built-ins
- About Error : ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
- About Error : ORA-01034 and ORA-27101 ( on Windows XP and Oracle 8.1.7 )
- SYSTEM Tablespace is FULL
- which SCHEMAS are actually needed?
- CHECK Constraint
- How fix ORA-01000: maximum open cursors exceeded with out closing Statement.
- Anybody Having STUDENT INFO SYSTEM Docomentation
- Get the date time from Oracle date time stamp?????
- Re: Generic Connectivity
- Re: SQLPROMPT in Sql*Plus
- Re: generate index ddl
- Cursor Value to Delimited String Variable??
- oracle on linux and windows on the computer
- How to unload data
- Teradata DBA in Chantilly, VA
- Formatting BRIO Reports
- mail merge with Oracle forms and Word
- viewing Stored Procedure Definition in SQL prompt
- table record distribution query.
- SSO error
- Oracle , Jdbc & Long Raw field
- how to view sample schema
- URGENT: VARRAY as Input/Output variable
- URGENT: VARRAY as Input/Output variable
- SQL*Loader - Commit point reached - logical record count 27
- controlled population of 1 million "generated" rows?
- How to insert BLOB?
- libclntsh.so Help!
- Commit transaction
- Slow slow Pro*C compilation with sqlcheck=semantic
- 1
- Re: books
- SAMPLE DATA NEEDS
- Big problem with Oracle Portal Migration
- Need Query without Union and minus.
- 8i to 9i changes
- Re: Indexing with interMedia
- Pfile Question
- Cursor parameters - problems with 'FROM [inTablename]' statement
- Discoverer inactivity timeout
- Oracle Backup
- oracle in solaris consume lot of memory
- oracle collabration suite experiences
- Show long number in Toad 7.5.2.0
- OCA & OCP Certification Books
- RTF to Text conversion
- Escape sequence
- moving a database
- Re: Chronological row-update procedure
- Blank line Inserted - I don't like it
- Oracle Reports 6 recompilation
- Right password -> ORA-12154: TNS:Could not resolve service name
- Problem configurating Apache
- Re: Enterprise Manager Question..
- Re: LNK2001: unresolved external symbol
- How do I rename null values found in GROUP BY column?
- Oracle/ASP hanging
- Updating LOB fields through ODBC, invalid LOB locator
- Input mask question
- migrate from sql server to oracle