- PDF Printing in APEX
- Prb with dbms_output.put_line - urgent
- Struggling in DB desgign schema
- Time Table Management Database design
- File system for cluster files on AIX 6.1
- SQL Query Help !!
- Help with procedure to escalate emails
- How do I check multiple table for empitness/ empty
- How to import dbf file to a Oracle table?
- Data compare on insert problem
- Union select or subselect
- procedure not compiling
- PL/SQL help with loops, method and explanation for Pl/SQL loops
- Use Regular Expression to allow specific characters
- PL/SQL VARRAY help
- Tech support for Ref Cursors
- code to check the password at least one upper case letter
- Querying from 2 databases
- how to free and used space in a table
- Problem writing query
- oracle data modeling and plsql code generation tool
- shedule dbms_job ar not working
- ORA-06550 error at irregular intervals
- join problems
- Update statement with inner join
- Disable Trigger - Procedure
- How to insert records into the RESULT of a query?
- what are the encoding technique used in bitmaps indexes
- Distinct on CLOB
- I am a webdeveloper in php and mysql I want to change my domain to Oracle DBA?
- HELP on How Create a STORED PROCEDURE
- generate random number
- If/then
- type Exception report
- Date Query
- Joining 2 tables & reporting values
- want to add image to oracle 6i form
- order a query by days of week starting with monday
- query to get partial data in a column
- Problem with Varray( Collection Types)
- Passing parameters to control file
- I wonder if this can be done with SQL...
- Need help with an update statment
- how to Sort subtotals
- SQL query problem- group by
- unicode support in D2K and oracle database
- Error while using sql loader
- Error in To_char
- compilation unit analysis terminated error when compiling a trigger
- SQL Update Issue
- display multiple rows into one value
- PL/SQL block to populate a table
- date query for previous months
- SQL Control file
- Need help to write the Query
- Help in Query
- ORA-04091: table is mutating, trigger/function may not see it error
- Group by
- Data from 2 tables
- could not find program unit being called
- How do I count number of characters?
- Another Question
- select in a view that returns constant value
- Heiarchal Retrieval W/Cursors
- update
- Problem with date format
- I m creating a form
- XML validation against XSD using pl/sql
- sort data with max value and in group of addids
- Problem with aggragating data in groups
- Use associative array in SQL
- query to change column values
- integrity constraints
- Fetch dates between from months and years
- Global Package Variable Issue
- cannot process using witth data
- mismatch in number of columns in table definition and csv file.
- values into columns
- refrential Integrity
- OWB Output File Format Problem
- OWB Output File not getting created
- playing with months
- query help
- database function
- Problem with invalid timestamp
- rollback data from the tables
- oracle join to include all rows
- procedure to delete several records from several tables
- foreign key and primary key
- PSL-00103 error could not resolve this
- help
- ENV TECH = winxp Dev9iAS Oracle9i Dev2000 R 2.1 Graphics Builder
- Help calculating the percentage of jobs
- Pk
- sql loader - how to ignore inserting duplicate records
- convert to oracle sql
- help dev9i icons
- HELP:loadjava,ORA-29534,referenced object could not be resolved.
- UPDATE null/empty into date
- oracle full outer join
- Trigger to Concatenate
- Function to get the path using the parent-child relationship
- execute immediate
- Query execution
- ora-00911 - invalid character
- rows with largest date
- nested query using in clause not returning expected results
- Searching PRODUCT column based upon user's input
- convert db2 query to oracle
- FSG Report Writing Question
- sql loader how to ignore error due to quotes
- question on tunning an SQL
- Oracle work in process
- Can We Format Number Output in SQLD?
- PL/SQL Bind variables - Strange results
- Oracle Software Requirments
- PLS-00306: wrong number or types of arguments in call to <<proc name>>
- estimate database size
- selecting data based on the length of data in a field
- Error in createing trigger
- Fetch data
- problem in UTL_FILE writing??
- mutliple query on same table
- Most Common Value
- Sql compare tables and insert missing data
- How to format output on pl sql
- Delete trigger
- Execute SQL Script from Stored Proc
- FYI, Regarding SQL Developer
- how to search a column containg alphabets?
- query help
- Conversion question
- date datatype
- Select Statement Results
- SQL Loader limitation to varchar or char ?
- Date with timestamp
- how to insert data from XML file to a table
- Help regarding the UPDATE statement
- truncate the column length
- loading of data using comma delimited file with double quotes & multiple files
- Oracle Text
- Calculate the Outage time for each day
- package oracle.jdbc.driver does not exist
- reg paging concept for plsql xml required...
- Challenging query
- help with the where clause of an update
- Alter Session Not working in Oracle job and procedure
- SQL*Loader-951: Error calling once/load initialization
- Control size of oracle forms Alert dialog
- Load the data file name in the column of table using sqlloader
- string processing help
- Pro C/C++ error: multiple definition of oraca
- query help
- Newbie:Quick route to Oracle DBA
- Database Table Design and Approach
- SubQuery Performance
- How to avoid ORA-29470 when bindin variables to a Cursor on Oracle 11g
- merge statement problem (ora - 30926)
- left outer join
- Strange Procedural record count over db_link
- Extreamly difficult SQL query
- Create View
- Oracle performance issue with "UNION ALL" in 10g
- Materialized View performance
- pls 00103: encountered the symbol exception
- Help with setting a cursor to be used for a loop
- how to get cumulative totals??
- Join to one row
- sql to update the table
- Row Locking
- Procedure help
- How to find what changes is done in Procedure through TOAD
- Securing from SQL Injection
- some_design_issues
- ORA-00984: column not allowed here
- Recursive Sub Query
- Display a rows horizontaly dynamically
- how to set automatic referesh for materialized view?
- Horizontal Row
- Date problem
- Create trigger on table, populate with data from additional tables?
- version control software allowing me to compare different version of Oracle Reports?
- Need help with stored proc...driving me nuts
- Can we optimize this further?
- script to remove a character from the data in a field
- help combining text and data in a trigger
- 123
- count the size of array variable
- Convert date from MMDDCCYY to YYYYMMDD
- single row subquery returns more then one row
- Error comming while installing oracle form 6i
- Sql Developer
- Utl_FIle
- creating a text file using utl_file
- copy txt file from oracle server to sql server
- Help with Transpose Query
- how to target records with most recent date.
- need help migrating 10g Oracle Forms to 11g
- could this have been done better using pl/sql
- SGA size shows 115280E+10
- using cursor with "WITH CLAUSE" in pro*c program
- how to find summary value by range
- how to find previous rows
- List of Tables used in Forms
- report builder not printing properly
- query i am not able to
- DBEngine.RegisterDatabase failing
- Query does not return what it should(?)
- Oracle Procedure vs SQL Server Procedure
- CONTAINS with special symbols
- PL/SQL Procedure issues
- Previous Work Date Issue in SLECT
- How to use collection in WHERE clause
- SQL error
- BadImageFormatException
- problem in calling a report from forms 9i plz - help
- Access file from server via static ip at outside lan
- Job not running and db link failure
- Need help with a loop
- Before trigger processing multiple rows and just the current one
- merge columns to rows
- Picking Order data not for the year 2011
- Difference between two join queries.
- stream pdf to web
- Deleting duplicate rows from a table in oracle
- Passing array as parameter to stored procedure in Oracle
- Split a column/field
- Trigger calling a stored procedure
- Using hints with Insert Statement in PLSQL
- Running total query
- putting a select statement in a trigger
- Help with a trigger
- to connect DB2 and oracle in coldfusion
- ORA-01476 Divisor equal to 0
- Problem on running os command from pl/sql
- Question on tunning while INSERT SELECT
- Calling UNIX from PLSQL package
- Use of Oracle FLASH_CACHE
- query involving time stamp
- I am trying to use the decode function on oracle within a but get an error any ideas?
- problem showing all dates in current month of last year
- Question on Partition SWAP
- help for code to search tables for something not download in a certain country?
- Adding INSERT statement to SELECT statement changes execution plan
- 9i to 10g query performance
- update of table using records from another table
- creating Excel file form 10G
- How do I protect my password when using SQLPLUS from a DOS command line
- Update another table from oracle forms
- PL/SQL script to delete millions of rows from a table based on date