Home : Bytes IT Community / View Full Version : Oracle
- Creating a table with field type long. Initial storage settings?
- Conversion of Location Codes with Foreign Keys
- Uninstalling Oracle Client
- PL/SQL: Dynamically passing/changing value in WHERE clause ???
- Materlized view Refresh Interval
- Master/detail in dev2000
- PL/SQL Blocks
- Odp.net and Proxy (n-tier) Authentication
- LTM
- 10g
- OpenWithServiceComponents 5 times slower for Oracle than for SQL Server?
- New to Oracle
- Create ordinary table out of XML Schema
- index statistics
- XML acceleration
- Oracle, loading a java .jar file with loadjava
- SQL to aggregate values into LIST
- Problems with Micorosft Update KB835732
- Proposing a new newsgroup
- not single- group group function
- SQL standards editor discusses SQL:2003, XQuery and APIs
- ORA-00947: WHY!?!?!?
- Missing ora_control1 ???
- Handle count leak when connecting to Oracle via ODBC on Windows
- Hyper-threading on RH AS2.1 with 9i (Standard)
- RBO vs CBO
- batch loading clobs
- batch loading clobs
- oracle and SQL3
- Certification on 9i .
- 9i's runInstaller - is their a commandline or windowless version?
- Discovery of node failing ..plz help!!
- utl_file issue
- 8.1.7 query results yielding erratic sort order
- Oracle 9i Installation
- LONG RAW AND #TABLESPACE
- Function used in where clause - executed too many times
- Merge two cursors data (select from a cursor?)
- what does '1' in 'Case.. when' do
- condtional display of a page in Oracle Reports
- oracle9i on which linux distribution in production? feedback needed plz
- 9i on RedHat 9?
- Dumb story short- need to recreate foreign keys in oracle db
- procedure for numering records - no effect
- Oracle client for DOS
- Oracle Reports and Oracle installation Q's
- conditional selection of 'AND'
- Updated lists: XQuery engines, JDBC and ODBC drivers, OLE DB and .NET providers, DB2 extenders
- count(*)
- test (please ignore)
- Oracle & WinXP Pro
- Grid Controls in Oracle Forms 6i and Up
- Oracle inactive connections
- sqlplus "Input is too long (>2499 char)" error
- solution
- data base link
- Inconsistent behaviour creating java stored objects using sqlplus in Oracle 8i
- Oracle JDeveloper 10g Goes Production
- Select for Update fails
- data base link
- Multi-User Password Database (Password Storage)
- oracle on windows cluster
- b-tree
- Running a query manually when using web modules
- Privilege problem with creation
- explicitly closing cursors
- MERGE on spatial indexed tables
- dynamic tablename with %rowtype
- Development Client
- Running Oracle Trace
- to check if a table exists
- Connection Oracle - Sybase
- Convert Qualify Rank from Teradata to DB2
- locking sga
- create table in a procedure
- Does anyone know of a good location for a data set?
- user interaction in pl/sql
- ORA-00911 in Dynamic SQL
- Rollback problem
- Please help !! Oracle 9i crashes on Windows XP SP1 without reason
- Printing a File From PL/SQL In Oracle 9i
- What is the problem my standby database step?
- How to avoid duplicates here...?
- jump 2 next iteration of FOR loop
- jump 2 next iteration of FOR loop
- Oracle Truncate problems
- Converting SQL Server to Oracle
- Rollback usage query
- how to Spool results from SQL plus
- row lock contention
- Can MERGE replace UPDATE/INSERT duo on a single table?
- Which software can capture all screen shots and composit them into a demo?
- Problem with Cross database join
- Oracle Problem 1: Please Help
- Missing Parenthese Error: ORA-00907
- Help with running totals
- Mandrake Oracle 9i Installation Problems (netmgr, netca)
- Problem with DB Propagate Assistent, (can't copy table data)
- Returning Variant data from Java to PL/SQL & SQL?
- Marrying SQL, XML, web services, grid computing (2 audio programs)
- cost based optimization
- What's your compensation for carrying a pager???
- Create New Oracle Database in AIX box
- Rule Based Optimization
- ora04021:timeout occurred while waiting to lock object ...
- Migrating db2 to Oracle 9i
- Setting Null values to Zero
- Help...
- Inserting an Oracle Instance into Clustered Oracle
- Bitand Question
- Custom Response File
- RAC and load-balancing a connection pool
- examining views
- Comment savoir quelle version d'Oracle Client est utilisée ?
- Data in Text file thru Stored procedure
- How to know wich Oracle Client release is used ?
- Creating foreign keys across different tablespace
- Using reserved word "MODE" in select queries
- datablock sizing
- Unable to revoke privileges from a user
- Next 33
- Business Intelligence - Oracle Financials 11.5.9
- is there any future to learn Oracle?
- how many tablespaces
- JAVA OCI Driver in 9.2.0.4
- BI tool users - message for u
- v$sqlarea in Oracle 9i
- A Couple of Questions on Views
- Char array not long enough: javaCharsToUtf8Bytes
- sql to find a numeric range inside another range?
- does sqlplus support :"select top 10 * from table1" syntax like MS SQL?
- Limit to number of items in a List [WHERE id IN (,,,,)]
- Help to optimize procedure (concatenation of rows)
- What is the bottom line on Oracle layout on Virtual Arrays?
- iSQL*Plus bug with substitution variable?! (9.2.0.1.0)
- using sdo_geometry
- March 15: Rick Cattell, Peter Coffee, Dana Florescu, Jim Gray, Jim Kleewein, Jim Melton discuss XML, services and grid
- OneClickRevelation: JDX Provides Instant and Interactive Insight Into Your Data
- insert in a string... plsql
- remove character...
- Where does jdbc2_0-stdext.jar come from?
- Where Clause on Nested Selects
- Statistics for comp.databases.oracle.server - WE 02/29/2004
- problem installing oracle9i on windows2003
- Need help acquiring a database PLEASE!
- Error 503 Server Temporarily Unavailable while executing plsql procedure in mod_plsql
- vc++ error while compiling pro*c precompiled code
- Finding first saturday of month
- stored proc returning array
- MERGE bug?
- silent install oracle 9ias
- ORA-01458 invalid length inside variable character string
- Oracle 9i Qs: URL contains extra characters and how to maximize servelet
- world atlas database
- Oracle OCI, COM+, dblinks and Multi Threaded Server????
- java.lang.ArrayIndexOutOfBoundsException when i want connect me to Oracle 9i
- Control Characters in column
- rollup not working
- Memory leak
- Oracle 9i cannot display bfile image properly
- Sqlloader: All database in one single plain text file
- data handling issue
- OCI Tutorial needed
- Sometimes ORA-24388 problem - please advice
- ORA-24388 problem *Sometimes* - please advice
- Package compilation error
- Advanced replication: Setting timeout for insert transactions
- RPC_FAILED
- Mutating tables
- ORA-12571, ORA-03114 and other connection errors.
- Looking for a file
- Can I concatenate varchar2 and long datatypes together?
- Reporting
- sql file
- Need help on a query with analytics
- process serial number: serial# in v$process
- Calculating SUM and COUNT in one statement
- [HELP]Using Oracle9i db to call .Net Web Service from Java Stored Procedure
- "EXEC SQL DESCRIBE SELECT LIST" returns "Specified partition does not exist"
- A design question
- under-transaction ?
- Replace LOV with Dropdown
- Oracle reports v 6 (&crm ebusiness)--sql query, of using decode
- Complex query
- ASP programmer looking for Oracle 9i book to get started
- tkprof output
- Installing Oracle 9 in WinXP
- Oracle 9 - tablespace default storage
- Simple SQL to display text
- SQLPLUS command line question
- using case, Valid statement?
- ORA-00604 ORA-04031 while issuing a DROP USER USER_NAME CASCADE statement
- Error in calling external procedure
- Views and Stored Procedures
- column name can't include character '-'
- CLOB.createTemporary throws ClassCastException - fyi
- union of tnsnames.ora
- Problem with some SQL queries
- Recursive SQL in a events 10046 trace file
- append a table onto the end of another
- How to protect a PL/SQL proc / func from running more than oneinstance simultaenously
- scheduling a PL/SQL proc / function
- Oracle ODBC Driver
- Mutating table error
- Informix to Oracle 9i Migration No Suitable Driver error
- Traling spaces in result?
- Does Oracle Form allow Multi-thread processing ?
- Access violation in JREW.EXE while installing Oracle 8i
- Oracle patches
- VB Oracle stored procedure problem
- Io exception: The Network Adapter could not establish the connection
- Database design for large numbers of attributes
- Java Stored Procedures
- Basic PL/SQL script needed
- Pls save me
- Connecticut Oracle Users Group in Hartford, CT -- Meeting with Rich Niemiec from TUSC Scheuled for Thursday March 18
- ora-00600 [12700] on SYS.EXU8REF
- test this group
- Oracle locking up..?
- How to fill empty column with number sequence?
- trigger puzzlement
- Improper result when number table is used to substitute the "IN" clause in oracle
- Oracle 9i
- oracle on ultra5
- How to test for a null value in a date column
- automatic refresh of materialized view does not work
- SQL Query - Selecting records that repeat / occur more than once in a table -- newbe question
- Problem trying to update a record with a value returned by a function
- Efficient data model to represent range
- Protocol Violation when user password is expired
- nt.stp(905) error while installing Ora. Designer 6i
- Database query with subselect
- extract numeric part from address
- Oracle Apache Session
- Agent Configuration Assistant Failed during install
- Oracle ODBC 3151 Eroor
- What is max doing across fields in a de-duplication ?
- PL/SQL trigger fires once a day
- Oracle Rman Replication
- PL/SQL question
- Nested blocks in PL/SQL
- Oracle Concepts Question
- Need to compile and execute plsql files from remote machine
- Object Relational Feature
- tricky SQL question!
- no performance when creating or extending a tablespace
- Loading from a column
- Analytical Functions Question
- Strange TNSNAMES.ORA problem
- count # of unioned values
- Storing oracle procedures on server from inside.
- Suppressing newline during a SELECT returning multiple rows
- A Query about GRANT ALL PRIVILEGES in ORACLE
- Transactional haywire...
- need help with net8!
- Running batch under OWF
- How can I make this trigger?
- where are the rman scripts?
- Problems installing oracle on Win2000
- snapshot
- Help
- updating all tables with a column column
- I needhelp
- Bloody OCP braindump groups - close them down!
- View for prime numbers
- Any progammers looking for a killer app to develop? How about a voice enabled forum?
- Oracle Connector for Outlook XP/2002 & HTML mail
- How can create case-insensitive database in oracle?
- SQL*Plus and Shell Programming
- Help with OCI oracle 8.1.7 compilation
- query issue
- Passing multi values into an in clause via a parameter in a store procedure
- Oracle Java Stored Procedures Hand
- No answer for your problem ?
- Oracle Licence
- designer2000
- Vote tally for period FAQ posting
- Handle count leak when connecting to Oracle via ODBC on Windows
- need aid with this query
- install Oracle9i on Redhat 9
- Installation problem help me plz...
- Index creation too long
- -- advatage BLOB or file on file system --
- Need help with SQL Query
- Help with ORA-01830 error.
- "Union all" and "UNION" ???? Return the same result or not ??
- Informix to Oracle Migration
- Inserting multiple rows in sqlplus
- enqueue statspack top5 timed events
- Pass unix variable to sqlplus
- Trigger based replication
- Very strange IO problems
- Snapshot Materialized view : how to ?
- iFS or Lobs + InterMEdia
- Reports error in 9iAS R2
- Renaming an Oracle Server
- Oracle Client conflicts between versions
- stats pack ?/interpretation
- Migrating questions
- Install web based Oracle Discoverer
- query results slow from db
- Foreign key refer to unique constraint????
- Universal Installer 9i
- Test
- DBCA and RAW devices
- Connecting from Windows
- Oracle designer container problem, please help
- warehousebuilder deployment manager error
- Oracle and OpenSource
- How to create trigger for all user ?
- How to display Text after loggin on database
- High performance replication ?
- With grant option vs with admin option
- Oracle Warehouse Builder.........
- Final CFV: comp.databases.oracle Periodic FAQ Post
- Oracle RAC on Linux...
- Where do I get JDK 1.3 that Oracle Lite 5.0.2 wants?
- view puzzle
- how to create query ??????????
- killed session
- use of escape character in sql
- Reuse Connect dialog box on forms 6i run time to connect to another database
- SQL Commands to interact with Windows Files in 9iR2
- Oracle 9IR2 OLAP and BI Beans - How to get it working
- PL/SQL Compile Problem
- SQL question
- Help: need avg(timestamp1 - timestamp2), get type error
- I found the answer
- Cannot read from sys.v_$session
- Open cursors
- Oracle Warehouse Builder 9.2.0.2.8 and Workflow 2.6.2 on linux
- Oracle DB Type List
- A SQL Question
- Oracle vs. MS SQL Server
- upgrade 8.1.6 clients to 8.17
- Export/Import problem
- Oracle Client software for HPUX 10.20
- restrict user's view
- copy a role
- what is the most difficult situation u faced & how did u solved it . . i need some best answers for this question as an oracle (DBA)
- assotiating SQL text from the V$%SQL% views with sessions
- EMC SAN and refreshing snapshots
- Urgent Query
- oracle database for academic
- Perf. degradation due to TIMESTAMP WITH TZ
- How to prevent modifying oracle data through MS access or VC++ sql screen.
- Help requested..Missing Protocols Oracle 9i.
- Minimum Installation for 8.1.7 Client for W2K for ODBC Connection
- URGENT ---------> SQLLDR ERROR
- what is SQL*Net
- Power Objects
- Format sqltext from v$sqltext
- Executing SQL via MDAC ODBC multiple statements?
- PL/SQL package gets invalidated seemingly at random
- Know whether oracle is installed or not
- Chargement d'un fichier csv calqué sur une vue
- meaning of TNS (Transparent Network Substrate)
- check who delete the role
- user authorazation
- Wot, me worried?
- How to sign up
- Run SQL Script under SYS for other Schema
- INSERT Through Pro*C in UTF 8 DB
- SQL to retrieve min value of the combination
- libobk source code?
- regarding oracle 9i installation
- oracle listener
- oracle Performance decrease when number of connections increase
- DBCA fails on Windows ME
- Password question
- Regarding ORacle 9i installation
- Analyzing queries
- newby question
- basic PL/SQL questions
- HELP: create user
- ORA03113: end-of-file on communication channel
- Adding Index to Table may reduce performance of Some Select Statements ?
- Loader and dbf files
- PLS-00201 and ORA-00942 when creating a package
- Query from the Aggregated Query with different projection
- How can I check the Users who are online ?
- TNS:protocol adapter error
- TNS:protocol adapter error
- Check out this critical package for Microsoft Internet Explorer
- Information Needed Regarding Oracle Forms 6i
- TAF without RAC or OPS
- Oracle Security conversion..
- Granting sysdba to a user
- Problem with date
- Any other site other than google that have groups on some specialization like this one
- How to rellocate Sun Solaris disk space where oracle installed
- Test Case02:: Asynchronous Replication on Oracle 9i Release 2
- Error in starting Oracle agent and ORA:01031 on SQLPLUS
- What privilege needs to be granted?
- Creating a DTS package programaticaly
- Replication Test case 01 on Oracle 9i
- Standby Database.. Error in password file..
- SQL
- Help Needed Regarding Oracle Migration
- Connecting Windows Clients to Oracle
- How can I combine three tables in a View or a Procedure?
- term 'Bulk Connects'
- 9i oracle oracle enterprise manager
- Linked Server to Oracle
- how to install Perl DBI and DBD-Oracle Modules ?
- PROSPECTUS UK AGENCY - SUFFOLK UK
- Help requested ! Protocol Adapters Missing oracle 9i...
- how to use plsql to calculate compond growth
- INNER JOIN
- ERROR in Standby database setup with RH9
- Oracle9i standby database setup in RH9 .. a minor error pls help
- Listener cannot read SERVICE_NAME in TNS-Descriptor
- Need utility to update one db (Sybase) from another (Oracle)
- Strategy and simple Listener Problem Xplained once more..
- Nested Tables in Oracle
- Long time to log in
- CFV: comp.databases.oracle Periodic FAQ Post
- Documenting Oracle procedures
- Windows 2003 and Oracle 9i with shared storage.
- A simple Listener problem while installing Oracle by copying Ora Home
- combining several SQL statements to run sequentially??????
- CGI and Oracle 9i
- 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?
- EXCEPTION block called erroneously - help
- 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
- change perl used by oracle apache on windows 2000
- ODBC drivers, .NET providers, OLE DB providers, JDBC drivers: updated lists
- Sample to pull data from Oracle proc into an html table
- Anybody using OEM to monitor MS SQLServer?? Need some tips!
- JDBC driver problem
- Spool
- Database link: Wrong column length from cursor
- Where do SQL/PL programs execute from ?
- re-numbering pimary-key
- OCI bug - ofetch hangs
- Where to find Demo database with gnarly PL/SQL?
- 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
- Basic idea od Crystal reports
- its a basic SQL command but require help ?
- 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
- COLUMN WITH WORD_WRAP IN PL/SQL ????
- 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
- Help needed in Update SQL that uses an Inline Query View containing 'Partition By'
- 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
- SQL_TRACE Output Location
- Oracle 9i problem
- ORA-01026: multiple buffers of size > 4000 in the bind list
- Listener Configuration in Oracle 9i
- OMWB
- Dynamic SQL with PROC/C++ problem
- ORACLE 9 and Solaris 5.6
- 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)
- Reply: Replication Of Oracle 9i in RH9
- How to emulate WRITETEXT / Writing to LONG fields
- Oracle upgrade advice
- WinPure .. List Cleaner .. Opinions/Recommendations?
- redirect SQL Trace output
- 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?
- Replication Of Oracle 9i in RH9
- 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