- Problem with XMLQuery
- Menu calling Report in 10g how can i do using RUN_REPORT_OBJECT
- How to Override SYSDATE function in Oracle9i
- Please kindly help me in this UPDATE command
- XML SQL extract
- Distinct Count on Fact Table
- Oracle Payables API: how to update flexfield from PL/SQL code?
- Sql help
- Returning latest row
- LOB's & DBLINK
- Average getting calculated incorrectly using group by grouping sets
- Timestamp format
- Materialized Views, Self Joins, Refresh on Commit
- Dynamic SQL - referencing table name dynamically
- Many-Many Relationship Problems
- How to simplify this query?
- Error: Statment ignored - xml db
- What do/did devs use in 8i to mimic Oracle streams?
- Drop user
- Script Files...
- locks
- Desperately need help with compare algorithm related to flat file import!
- Query help
- Nested Aggregate function help
- Using dynamic SQL - priv related
- Starting with Data Warehousing
- ORA-01036: illegal variable name/number when creating external table
- Bulk Collect
- pls, anyone help me with this problem....
- Data Extraction
- Disabling Unicode in Oracle 9i client
- Low Buffer hit ratio
- How to view a Package as a synonym
- building view help
- Warehouse Builder 10g: Specify PCTFREE for tables
- Using ARRAYs in SQL
- Unique Index
- Error message
- Logical Delete
- forms troubles
- Bitmap Indexes
- save my last run SQL command
- Single quote
- Need help with script...
- Need help with tricky inner select on SQL
- Relation between sequence and column (not the autoincrement problem)
- A few questions (Array, Lastval, Siblings)
- SQL*Loader memory Fault
- Why update takes time much more than insert
- Execution count for a PL/SQL Procedure
- Open Forms from database trigger?
- amazing problem
- jdbc access to 8.0.4 via thin driver
- Never ending query
- PLS-00382: expression is of wrong type
- RunTime LOV
- How to unbind the definition by OCIDefineByPos?
- sum of the range
- retrieve records in disperse way
- retrieve records in disperse way
- Calling overloaded functions
- Query Performance
- Is this right..I tried all kind of ways...frustrated..due in 12hrs.
- A Query that list selected dates within a given date range
- Query hangs using db link and nested table collection
- selecting text only
- Optimizer doesnt recognize a partitioned view with UNION ALL to eleminate tables
- FRM-92130: Registry is either missing, or contain invalid, entry for Dispat
- Performance issue
- creating non-editable table
- Calling Report From Oracle FormsDS9i
- Creating DBLINK's dynamically
- Unicode support in Oracle 10g on HP-UX 11.11
- Multi date column report using range
- Question 9 is the only one correct, rest of them syntax errors..Can anyone help me
- ora-00054????
- Identify and replace \n (hard return) in record column
- problem related SQL*Plus
- Total call Date report using increment date
- ORDER BY data entered
- Developer sites
- Pls-00103:
- Two different execution plan for the same sql
- Export table statistic
- sysdate value
- logic help
- help needed in this SQL
- Report by month
- 8I questions
- Materialized views or Views??? confused...
- multiple entries for one form
- Passing different tables as a input parameter
- Uploading Budget information from GL into OFA
- procedure call from SQL*Plus in Korn Shell Script
- Stored proc to create file
- triggers
- object classes.....
- forms object navigator
- append record when file already exists
- Query Trouble
- oracle 9i function to perform data manipulation
- I need Help
- Need a sample distributed query in oracle.
- special character
- Need Help with Date Conversion to Session Timezone
- About DBMS_XMLSTORE
- graphics object
- ORA-00402 error 9i
- Decimal to Packed format
- Good ER Tool
- oracle dev suite instalation disk 1
- Rep-0501 / Ora-12154
- Oracle 9i - Return Code from Procedure to UNIX
- Movign Files into a directory and overwriting existing files..
- How To Call Java Program from PL/SQL or Trigger
- "Covering" Index
- rows to column
- Varchar data type
- to_char(timestamp) returns 0 day?!
- How to determine last modifiet of view
- Stopping constraints?
- free book,tutorial,material, report,pl/sql
- credit card system
- barcode reader
- error ORA-06502
- PL/SQL Client, Access to Local Files
- transpose columns into rows
- SQLPLUS Spool - Truncating Data
- Query return data between two fixed points in time.
- PL/SQL date calculation
- portal
- Store image as well as scanned documents
- problem with record groups.........
- [MV] - Oracle 8.1.7.4 (Needs_compile)
- passing paramets to oracle from unix
- error while reading cursor value
- max position of a char in string
- Limit to No of External Tables
- Second Issue need to be solved.
- Problem while Oracle Import
- Why Doesn't this query work in a PL/SQL Procedure?
- Tell me where is goning wrong????
- XMLCONCAT error
- Updating a Sequence
- dbms_job interval
- display total number of rows with function and criteria
- FGA Policy query
- DBMS_JOB errors: PLS-00201: identifier 'package.proc_name' must be declared
- Connecting to Oracle Reports (9i or higher) to a DB2 database
- CTXCAT index problem: SUBSTRING_INDEX parameter doesn't work
- Function returning recordset
- SQLServer--->Oracle: Is this possible??
- New to PL/SQL, Please Give examples
- databse design,urgent
- crosstab query help
- SQL Statement Question
- Pro*C generating garbage files
- Database design - how to?
- TRansaction IDentification
- Advance Queueing and Transaction tracking
- Supportin BATCH programs in PL/SQL stored procedures
- any way to create PERMANENT (301) url redirects in pl/sql?
- REF CURSOR declaration
- Connect By Level clause provokes...problem
- Function sequence Error - MicrosoftODBC
- Replacing a range in a string
- Combinations
- inserting rows from another table
- how do i connect oracle 6i to oracle 8 database
- regarding the scripts and batch file plz help
- Using variable in SQL WHERE statement
- Quotes in a SQL Statement
- spooling from sqlplus
- variable column names
- Package question
- Date Range Arithmetic
- populating data from temp tables
- is form fmb file cross plate form?
- Best SQL Program Code Practices
- Trigger on table with LONG column
- Update CLOB from LONG
- audit on table
- error: ORA-00936: missing expression
- Oracle Dev6i Comport Support
- hello am very new in DB(pasket cart)
- Oracle Function to create .CSV file
- LONG column
- how to write this procedure in pl/sql
- Analytical Function
- ROWID in Where clause
- Help need to tune the procedure
- sending multiple email using apps.gcl_email_handler in Oracle
- counting the number of records from multiple tables
- Help with Analytical Function
- Hierarchial Query is not displaying the rows in a hierarchial manner
- NEED HELP to SPEED UP QUERY
- selecting the second highest average value.
- matrix query - problem
- Printing reports in Different Trays
- mass delete records
- How i could install 6i developed application in Clients PC
- Replacing a string within a CLOB - Oracle 9i
- Frm-30187
- searching two tables at once
- How to write a procedure not in a package, that has a cursor as an OUT parameter?
- APEX Install
- SQL Query Issue?
- How to create a flat file?
- Modifying Form Behaviour Oracle Applications
- where and How use of Builting-in Packages:
- Timezone
- email validation
- MERGE inside triggers
- initial extent and minextent
- insufficient privileges
- insert locks aplication
- Changing table statistics
- explain plan
- insert into mutiple cols from single col.
- Escape Character PL/SQL Developer
- Migration of Oracle Forms & reports from 4.5 to 10g
- What is better?
- many to one recordset return
- Table Design Suggestions
- PHP Oracle Errors with Double quotes?
- DDL Trigger
- proceduer returning error "ORA-01406: fetched column value was truncated"
- Report Query & Designing
- procedures call error
- "ORA-00054: resource busy ..table not inserted into db
- Using user defined function inside package
- need help with date field
- how to run procedure based on day
- Round a decimal value
- help in joining tables plz
- joining three tables problem
- Sql help
- Tnsnames.ora
- Backup Database and Transport
- Big Problem!
- help on sql statment
- tuning stored procedure - help
- How to varify ???
- Any advice for a future dba, about getting started.
- numeric overflow error
- $Universe and uprocscon oracle database
- turning columns into rows
- Will creating another help
- How to copy LONG or LOB data from one table to another table?
- Tricky query.