- Which record is utl_file reading?
- RMAN problem continued
- Oracle forms
- Oracle 10g OCA and OCP sample questions
- Viewing logs
- Creating a function produces error: PL/SQL: ORA-00947: not enough values
- optimization
- start with connect by clause
- metalink says upgrade
- Help a dummy out. Long Raw issue.
- How to refresh a 24x7 production database without inconsistency issues?
- Insertion of the Character set
- SQL*Loader Losing Records
- Where are my data files?
- Finding correlation using derived columns?
- Oracle Streams for database migration?
- £ is being reported in Oracle reports instead of £
- List all database name on server
- Calling SP inside a Sp
- SQL Warning - Data truncated
- Oracle Sequences...
- accounting_dt
- GROUP BY on DECODE
- ORA-12157 error installing Oracle 10 on CentOS 4?
- what is "warm started" in dbstart?
- who writes in control file?
- converting varchar to date
- Unexpected token...can't see problem
- parameters: configured vs running
- Can i do this in a trigger?
- How can I find the next extent size for a table in 10g?
- compilation error
- using CLOB as SP parameter fails
- partial Mview refresh
- Identifying App SQL
- Counting number of records in a form - Oracle9i
- backing out a version
- Log User Activity on Oracle 8i
- can I use two indexes in a query with an or in?
- Outputting an Oracle report 6.0 results to txt file
- Using impdp to restore entire db
- Check for existence of records
- script enquiry
- steps to activate up and down arrow keys in sql*plus
- Calling SP inside a Trigger
- Calling expdp as sysdba
- Stored procedure errors.Please help
- Code help
- Testing Oracle10gR2 RAC Installation on Windows with minimum & low price hardware
- Disable sqlforms access from users
- How to link with non database block items to the database table columns?
- prefetch rows when using ref cursors
- Oracle 10g OCA & OCP Sample Q&A (1)
- Unable to create function in Oracle
- javax.mail.MessagingException from Sqlplus
- Oracle equivalent of SQL Server's IN function
- How to select the client name from the list?
- Installing 10g client on HP-UX
- dbms_java resolvePermission?
- How to drop a data file from a table space?
- Tricky question, asked in tech review.
- crosstab query help
- One message item along five rows
- "ORA-06502:PL/SQL:numeric or value error: character string buffer too small"
- Stored Proc Help Please
- Help changing script to accept multiple parameters
- Materialized View question
- TNS-01153 error
- dropping data after decimal point
- SQL Query performace question
- restore RMAN
- Risk for NoArchieve log Mode
- Stop at "About to enable all constraints....."
- calling Functions from sqlplus
- regarding partition of table in Oracle Database
- How to check the working days using Date function
- table design question: storing both character data and numeric data in a VARCHAR2(10)
- Technician out of ideas - F45RUN32.EXE error
- set transaction isolation level serializable
- Books for OCA Exam
- TNS-12516 TNS:listener could not find instance with matching protocol stack
- Need some help with Encryption
- Unsupported datatype issue
- ORA-00001: Primary Key constraint (POP.POPSERV) violated
- replace more blanks to one blank
- SYSMAN OMS Processes
- Different row count for select versus insert
- OCI-21500: internal error code, arguments: [KGHALO2]
- Having trouble writing to a flat file
- Is this even possible or should I call it a day
- How to highlight pdf files from Oracle Text
- Problem formatting date
- Problems with JDBC:KPRB
- Oracle newbie seeks help returning resultset to crystal reports
- Decode Statement Within Where Clause?
- Oracle BI - A little confused....
- 3 updates fail, 1 does not. Why?
- Query help needed
- Oracle to Foxpro Query
- kill a user session
- Export Cyrillic from Toad 9.0.1.8 into Excel 2003
- database in fuzzy mode
- data pagination help
- ORA-28576: lost RPC connection to external procedure agent during extproc
- Wrong triggers are running
- Oracle Partitions
- order by issue between 9i and 10g
- Query optimization
- CREATE VIEW issue
- SQL Interview Questions
- procedures and PLS-00049 error
- Problem in QUICK TUNE advisor
- How to start em using dbconsole for all databases
- Removing duplicate rows
- autorun using response file
- Select user privileges
- To create nonclustered index or its equivalent in oracle
- Cleanup - releasing the memory resources from oracle DB
- Intelligent Agent - Segmentation fault core dumped
- RETURN parameter
- Error in EXECUTE IMMEDIATE
- Correlated update query help
- Help: Dealing with large tables.
- DATEDIFF Function, Need to exlude Weekends
- distinct on normalized data?
- $ORACLE_HOME/rdbms/admin/catrman.sql is missing
- export from Database B and import single schema into Database A (was "One Question")
- newbie question: how to use imp
- loading partitions
- keeping old and new tables
- Basic Questions???
- Value of db_file_multiblock_read_count
- STATSPACK Question
- oracle 4.5i
- Oracle Developer Suite 10g
- Is there a place to see 'when' a datafile autoextended?
- hey this is regarding imp from db1 to db2
- DATEDIFF function in Oracle
- SQLException
- ORA-01406 fetched column value was truncated
- databaselinks Oracle 10g
- does an increase in records cause a slowdown (with shared tablespaces)
- Problem with permissions?
- Indexes used in Data warehousing ?
- Differerence acces path linked server Oracle 9/10
- Pseudo columns in Oracle?
- PCTFREE and PCTUSED parameters?
- WYSIWYG format ?
- Best way to update huge table?
- how to rollback an updating process?
- Need help with Update query
- Global Temporary Tables
- Oracle ( 10G) giving bizarre results
- steps to create standby database
- Differnce b/n Shared and Exclusive Locks?
- Unable to start iSQL*Plus service
- Lost writing a query...
- Oracle and Active Directory
- How do I extract data from views given a port, username, password and service name?
- oracle PL/SQL Trigger
- Transferring data between Oracle 9i and Oracle lite both ways
- read from sql server in oracle
- Mview refresh error
- Any brand recommended
- Connect with SQLPlus but cant with Toad?
- set_block_property (ORA-06502 error)
- Remove character in a cell
- Tricky Question!!! Enjoy.
- 10g Client Directory File Location
- New to Hyperion -- need guidence
- Oracle clone leading to Oracle Designer connectivity error
- Simple Question
- Searching Function
- Executing statspack.snap after every 15 minutes!!!
- delete taking long time
- Developer Suite 10g
- Total payment volume per transaction per customer
- Building dynamic query
- Oracle Database Backup/recovery Software
- Raise_application_error drop the error number when displaying
- Alphanumeric Sequence
- Connect ORACLE to MSACCESS
- dates
- select the record only for the first matching condition in four where conditions
- package timestamps
- returning oracle ref cursor to java
- Syntax error in Grant execute for a package
- Making an exact copy of existing schema
- advanced replication
- deleted primary key
- Shared and Exclusive Locks?
- RMAN restore problem – test data keeps showing back up
- Trigger question
- Multiple Oracle Sessions???
- How to get a 10g Database to 9i
- 9i versus 10g
- Makefile problem for OCCI on Oracle 9i
- $ not £
- ORA-00934: group function is not allowed here
- Service started but databse is not running
- Oracle 10g on Aix
- Issue with Date format
- ResultSet with subtotals
- Newbie question: DESC <view_name>
- idiot question : How do I analyze the performance of a query/procedure
- Query Help
- SGA memory recommendations - Oracle 10g
- DBA_VIEWS question
- How to open the user locks
- Upgrade to 10g from 8i - ODBC Issue
- Copy an explain plan (Oracle 10g)
- Create 2nd Oracle Home
- PRO*C and ASM Instance...
- How to retrieve specific string when end position or string not known
- Oracle Base
- Tuning a very simple view
- Insert into multiple table
- number of rows in a cursor?
- Using sql*plus (command line) to connect Oracle Database??
- Increasing Hit Ratio for Buffer Cache
- ORA-01719 Error
- starter
- Cursor problem!
- Problem with Unions
- export table - performance issue
- Expoting data from oracle to CSV
- Does oracle create index for keys automatically?
- Restore/Recover database from RMAN backups 10g
- ORA-00936: Missing expression
- Mutating table
- Coverting columns to a row?
- Java Oracle Application and Linux TCP KeepAlive feature
- Oracle Client and Networking Components Not found error in asp.net?
- Converting DB2 to Oracle
- Performance Issue on 10.2.0.1.0
- Select Query works fine in SQL prompt but takes time in Stored Procedure
- database connection
- Select query takes time
- Assigning Perspectives to items?
- System tables
- German book for database administration of Oracle
- checking for oracle error prior to execution of code
- GNU bash version 2.04
- How to create hash clustered index in oracle?
- Virtual Memory Paging
- Using Api
- Extract attributes value from XML text
- Question regarding logical operators, and view creation.
- Oracle Stored Procedure and Datetime Parameter
- TOAD queries