View Full Version : Oracle
- connecting to ORACLE
- Help using bulk collect and rownum.
- rman
- Need Help for database issue..Super Urgent and Super headache..
- update with a join in oracle sql
- substr and instr help (simple?)
- How to always have a subquery column even on empty resultset?
- problem with loading file to table
- Plzz help....with this wierd problem in stored procedure
- Help with relatively basic query
- update query from select in same table.. help!
- guidline about oracle certification..
- SQL 9i
- Candidate/Primary Key
- Create Materialized "Object views" from relational tables
- find the average balance
- Smon
- export backup help
- updating course tables
- cannot see result in dbms output
- Replacing the blob
- quick guide oracle 11g for AIX.
- Trigger Help
- How to escape ® and ™ characters to its character and numeric entity
- rman
- view help
- Error when trying to create a procedure in pl/sql
- when should I separate a field into a table of itself
- Oracle slows down my system
- Creating view in oracle
- Variable sizing problem, using Java in Oracle
- Installing Oracle 10.2 on Solaris using dbca get Hagged
- can't connect as sysdba
- Substituting RPMs on install
- RAC Install Steps
- Object Statistics
- ZHS32GB18030 Char Set
- Case statement Help
- Forms 6i
- help on 'order by decode'
- My connection keeps getting disconnected
- SQL Experts need help - oracle SQL
- Sql help: Inner joins
- Create function
- potential conflict of oracle installs
- Error at line 1 ORA-06550: line 1, column 7: PLS-00306:
- Returning a rowid into a select after an insert
- Will this work in Oracle Procedure
- database agnostic
- PLS-00402: alias required in SELECT list of cursor to avoid duplicate column names
- Corrupt redo logfile
- **EASY** Oracle 11g Question!
- Error at line 14: PLS-00103: Encountered the symbol "PROCEDURE"
- ORA-01704: string literal too long when updating a record
- Problem with a login function
- Query with in clause
- block developer tools
- shell query
- Question about constructor methods
- Can I replicate data from Oracle 11g to MS SQL Server 2008 R2 ?
- Scipt to check the listeners status
- ORA-00942: table or view does not exist
- Need help with Catesian catastrophe...
- Procedure to update a column
- Newbie question:
- Oracle Datawarehousing Advantages/Disadvantages
- Installing Oracle drivers on Windows IIS 5 server
- ORA-14099: all rows in table do not qualify for specified partition
- reports 6i : lines affected by number of records
- How to retrieve the IP for Oracle databse?
- ora-01401
- ORA-27100: Shared memory realm already exists
- Barcode data into oracle Database.
- Forms 4.5 to 6i
- using cursor with "WITH CLAUSE" in pro*c program
- procedure in a trigger
- Need help with Trigger compilation errors
- Alternate solution of Autonomous transaction
- order by clause performance
- XML Clob or another table?
- Script (status of DB from OEM)
- ora-01401
- Find db and last refesh time.
- cant insert records using cursor
- Java sealing violation on emca -upgrade db
- Same query Same database Different Explain Plans
- Procedure to send notifications to users in pl/sql
- Data Validation in ctl file for SQL Loader
- How to Create storeProc With Agument like This
- oracle query Tunning
- Websphere/Oracle 11 - much more Heap Usage than with Oracle 10
- =ALL or =ANY Problems
- tree creation in OF
- problem with Tar ..
- Procedure with cursors
- Report help!
- A video for anyone who's spent too much time in a data center
- SQL Loader using Escape Character.
- Help with query
- replacing numbers in a string
- Oracle HTTP Access
- Large database dump example
- Help - Newby using Oracle
- Rman Configuration
- Data Guard
- Creating roles
- Oracle <-> DB2 Bi-Directional Sync, Master-Master DB setup with differing vendors
- ORA-01458: invalid length inside variable character string
- Trigger fun... Well, not really.
- cannot access rows from a non-nested table
- run time error ORA-06512,ORA-00922
- Setting up a training system (revert changes daily)
- Problem whit delimited files in reports builder 6i oracle
- Loading NCLOB with SQL Loader.
- Website database (torrent database)
- Date Convertion
- Using like in sql to compare 2 columns
- error in installing d2k 6i
- SQL Loader (Multiple Files)
- Calculation problem
- Error during restoration of snapshot in OWB using OMB Plus
- Searching MEMO fields for specific terms
- Query Scheduling Apps
- Finding Matched String With Blank Spaces
- Syncing sequences between prod and test
- DROP or DISABLE Constraints?
- Finding value between two cursors
- Help with Select statement
- Insert failing / arguments failing in procedure
- Oracle object err: ORA-06530: Reference to uninitialized composite
- Procedures
- How to declare and call in forms 6i
- INITIAL and NEXT parameters
- SQL Loader and Partition Tables.
- Differences between v$ and gv$
- sfile,pfile and init.ora and control file
- Connection string in VB.net help
- NLS date, 8.1.7 client and 10g backend
- Moving the database from Dev to Prod
- Session inactive?
- Tuning OLTP and OLAP
- Report
- Automate Clean Startup / Shutdown Services
- connect to outside
- DBIO_EXPECTED current value
- Getting ORA-00932 inconsistent data type error
- spliting column values based on space
- backup
- Using comma separator in oracle
- Urgent query - How to pass an array of strings to, and return a table set from a proc
- Oracle sql performance issue
- ORA-0314: Not connected to Oracle error
- update long string cell in table by SQL command
- datetime 9i
- Recursive Validation
- Zipping up files in windows filesystem from Oracle 11g r2
- Enterprise manager in Oracle 11g
- format the file by command spool
- month sorting
- Tuning Select on nested table column
- Extract a BLOB > 32k from 11g r2 to filesystem
- spfile is visible, in Vi ? why ?
- PL/SQL 'FOR' Loop Exception handling
- dba
- NVL Function problem
- Repalce the column value
- HELP: How to declare NVL datatype?
- LOB Segment Shrinking
- Identify missing sequential numbers
- The hellhole called 'pivot'
- Get ids from affected rows
- Most efficient way to update an integer
- Is there a easier way to clone a record.
- Help me understand the sql
- SQL query
- Requesting for dba live scenarios?
- Using Update with Group By
- Importing data from files.
- Urgent:Help to use REF CURSOR
- writing sql.....9i
- Indexing
- Getting error ORA-22285: non-existent directory or file for FILEOPEN operation
- OPatch failed with error code = 115
- Connection pools
- what is better
- Autonumber.
- Help Me please I can not do ....
- help writing a script
- Automating Queries and Reports
- database replication?
- Getting the Distinct Records
- System terminate session while applying nested round
- using BETWEEN keyword on dates can sometimes be slow
- Column type
- Dates
- Distinct NAMES
- ORacle Database Creation.
- nested selects and indentifier scope
- Publish oracle forms and report online
- Oracle Forms
- SSRS with ORACLE
- 'localconfig' is not recognized as an internal or external command,
- Is It Enough Give Me Idea
- Distict order by
- Date error
- Data import from Access to Oracle
- Oracle9i installation
- Select Statement
- Logic to find the combination
- trigger
- Oracle XE - Autocommit problem
- new to oracle
- performance of indexes
- ERD Guidline
- before delete trigger
- dates
- ORA-06520: PL/SQL: Error loading external library on 11g, worked on 10g
- Select Statement
- Oracle Load Data File
- Total length
- Imp-00034
- Database Design and Storage Question
- Indexes become unusable
- how to find current financial year
- SGA advice
- shifting textbox data to table
- execute query
- simple pl/sql program in sqlplus
- lab scripts for "Oracle 9i performance tuning" exam
- Need help with bulk collect into database table type
- sql assignment
- Question about locks and 'skip locked'
- TNSPING giving TNS-12538 error
- ORA-00907: missing right parenthesis
- Historical data
- Restricting Login at the Table Level
- SQL question If SELECT
- Bull Collect : ORA-00932: inconsistent datatypes:
- forms
- database tuning
- cannot fix dump area alert
- migration
- Deleting duplicates -Updates running long
- Building XML file from table
- Procedure to update double subcategory sequence
- Oracle and Classic ASP Error
- Object Relational
- Oracle SQL Error: ORA-02291: integrity constraint
- Oracle user connection failing
- Adding rows
vBulletin® v3.8.6, Copyright ©2000-2012, Jelsoft Enterprises Ltd.