- Problem in Materialized view
- mutating
- Error (C++ does not support `long long' ) while compiling ORATYPES.H
- problem to disable a perticular item in oracle forms
- open form with parameters
- Hanging of select statements/Forms & Procedures
- Archiving the data
- SQL : nth highest salary from emp table
- 10 g Installation problem
- Normalization
- connection string
- Selecting Max Daterecord from Many Records
- Sshr-ame
- oracle10g production license
- important sites
- Adding primary constraint on a table if you have duplicated records already .
- Running two applications at the same time , having common components
- Maximum number of Columns
- SWITCH error
- DeCode in Column List
- Siebel Calendar Issue.
- Oracle Installation
- where to use ref cursor ?
- knowing jusT the lasT row
- how to do a realtimeproject
- how to connect 9i to 10g forms
- Display a field in margin of Oracle Report only on page 1
- Hi friends........
- simple SQL ELSE IF statement help
- insert into primary froeigon key relationship
- Connection String for Remote Server
- reg hyperlink in oracle report built by oracle reports builder
- Sql Plus Utility
- Parameter in Discoverer
- How to specify person type in table creation
- how to create a txt file from PL/SQL procedure
- using a join and field concatenation
- Exporting whole database from oracle 9.0 to 9.2 (windows)
- network adapter
- connect database
- Update statment with Exists and inner join, need tuning or alternative
- TNS Writter Failure
- How to increment more than one or to some othe rnumber with Oracle for loop
- Export Database tables to a dump file under windows
- Use variables in several different places in a big SELECT query
- long sql query
- Comma seperated column
- To check space in varchar2 column
- Pro*C vs Oracle Java Stored Procedure
- Query Tuning for a single select statement
- Restore the database backup in Oracle9i
- how to update columns in oracle forms
- Improper result from query
- Loading Multiple CSV Files into Oracle DB
- FRM -41039: Invalid alert ID 0
- error 00214
- oracle error
- oracle 9i reports
- how to declare a global variable in report builder?
- Call Javacode from Pl/SQL
- case when gone wrong
- Workflow
- how to change search conditions dynamically in where clause using pl/sql
- SELECT WHERE SettingKey = N'Logon' FAILS
- insert into a table with selected columns.
- Oracle does not exist and shared memory realm does not exist error
- VBA Oracle DB Connection String
- can anyone pls help me to join tis 2 query statement
- How to add a sum up column to a table
- ORA-27101 problem
- Loading Excel File into Oracle Table
- How to drop and then create a table during runtime in oracle9i
- Nested Cursor
- Sequence.nextval incrementing itself over time
- Not able to open test.fmx in oracle application server 10gR2
- oracle report 6i
- Bulk Import of Data into an Oracle Database
- Loading XML data to Oracle Database
- Joining of 2 SQL queries
- how to compare two columns and return the value which is not matched
- Mutation of triggers
- Traversing a tree - using a little recursion in SQL
- how to get colunms displacement for a table in Oracle?
- i'm trying to load data from uploaded file in php by using sql loader
- error questions
- How to connect oracle 9i database & developer suite ?
- how to use a list item in oracle forums
- rowid
- how to enter only time in the field of table and sum the time
- Query
- Equivalent to SQL Server Integration Services
- Drop by to ask for help
- how to execute query without having to declare schema all the time
- File Dis51usr.ini Of Oracle Discoverer 10g
- i'm having trouble in defining primary key... HELP ME guySSSS
- Arbitrary order in SQL query
- load data
- oracle sql
- How i can use "IN CLUASE" with block fields.
- Add Field To parameter form
- Best practice for inserting many to many records
- dynamic :NEW
- How to recreate Foreign Key constraint
- Multiple Counts in 1 query
- RecordSet inside procedure
- What is a dblink ?
- orace 6.0 designer
- like %
- Connection pooling
- import .lst files
- I got a error when i am establish the connection between oracle and sql server
- SQL Select statement as a keyword search
- Iterative function in sql
- Table Output
- Oracle XML and XPath
- REFCURSORS over dblinks
- oracle error 10034
- Sql
- Oracle reports 6i and asp.net
- Report 10g Vs Discoveror
- Query Takes time to execute
- Generate DDL of Schema
- Easy question from MS SQL to ORACLE
- Integration of two databases into one Database
- Maximum size of Linesize
- grant access to remote user
- ORA-01004: default username feature not supported; logon denied
- External Table Query runs in PL/SQL but fails in perl script
- File too large..
- question
- deleting data
- DataBase is not Connected through Application
- Oracle Parameter not getting value
- help with PL/SQL (ORA-06502 & PLS-00204)
- DLOOKUP function
- How to execute trigger instead of view while changes are done on a field in the table
- copy access tables to oracle
- Need to connect oracle database using Unix script
- Need a unix script to do match two files
- ORACLE10: Rename column that has keyword name
- ORA-03113 : end-of-file on communication channel
- Need help with append and delete duplicates
- How to run & view the out put of procedures in SQL:\>
- Oracle 9i Installation problem
- Informatica Licence Key-
- Oracle Apps
- How to bring up Enterprise Manager Oracle 10g
- Count(*) and performance
- Regarding tablespace issues
- how to change the password for sys schema?
- TOADS Explain plan
- Reg AOL
- Single sign-on configuration assistant failed during App Server install
- Update the first x of the records returned
- Encryption
- new feature in oracle 9i
- Run sql statement through batch file
- Using Collections in PL/SQL
- Refreshing or recreating a materialized view
- New to Oracle Help me out....
- Load Xml in oracle (SQL LOADER)
- Query too long
- Number Formatting
- New to Oracle
- Command hangs and doesn't end.
- SQL statement to store and retrieve 2byte letters like Japanese characters
- Oracle Reports 6i Download link
- Convert Oracle to SQL
- min function
- Timed Out Error in Oracle.
- What's the best way to load a PDF file into an oracle table?
- Top N results
- Prblems with DataSet Fill
- Duplicate Records
- E-Book
- Connection error from em oracle10g
- REG Oracle Discoverer
- trigger compilation errror
- Get Top 10 records
- decode question
- Assign field value based on date range of another variable in another table
- Regarding ORACLE
- FTP Batch file
- Data cloning in oracle 10g
- Retrieving the Nth record from a one-to-many subrelation table
- Can I commit portion of transaction in Oracle 9i?
- Back up or export Oracle Database Lite 10g syntax
- how to returning a recordset
- problem with connection
- Difference between Having & Where Clause
- How to connect to database????/
- login details
- Dates between the two given dates
- Data Dictionary Views
- Oracle transparent gateway in z/os
- Syntax error
- insert time only
- Tuning a stored procedure
- Regular expression in Oracle
- Creating Table in Oracle
- Calling Apex from Oracle Forms
- primary key
- date & time between
- Subqueries
- procedure and function
- countfunction
- Stored Procedure returning multiple values
- multiple row insert
- apps output in excel
- how to insert very large text into CLOB datafield?urgent.....
- SQL command not properly ended?
- Query Help
- Oracle 9i driver
- OrderBy question
- Oracle Reports
- Report not running in web layout
- flush shared pool
- Adding minutes to a date field
- The same signature of Stored procedure
- Failed to load the following object in oracle forms
- urgent help needed regarding arrays insertion
- Displaying specific data from the database
- Spooling more than one file
- count(*)
- no data found error in an "execute immediate" statement
- Creating Customer Address
- inser the row
- Concat used by optimizer in where clause
- Date conversion problem
- sql query tuning
- LIKE Operator
- It's urgent (Oracle running slow)
- PLS-00201 error from PHP
- Calling a Stored Procedure via a trigger
- Lookups
- report error
- PL/SQL:PLS-00410 duplicate fields in RECORDTABLE or argument list are not permitted
- Cannot avoid duplicate results
- size of image file..
- Update and Insert trigger definition
- hi amit..newbie oracle help me please!!
- In correct date format
- ORA-00907-passing blank space inside a parenthisis pair
- Tracing users by after logon trigger
- Urgent Help Needed
- PL/SQL Trigger Restrictions
- autonomous trans with EXCEPTION fails - why?
- need to know about oracle
- Use Duration and booking date to stop bookings during this time
- procedure
- merge
- current user
- import a .dmp file
- Function..help!
- need some docs regarding Sql tunning
- How do i Optimize this Query
- inserting unixtime in database
- Counting Commented lines in code
- Listener error
- Creating A Text File
- How to restore the path variable to get OracleDevSuite working?
- How to Connect Forms using VPN / DSL
- help! i need a solution pleas..cn i use subquery..
- Ora-01092 Errror
- Need help on using analytical function
- Deduplication in 11g works only in alter/modify?
- To update a record using rowid in duplicate row.
- correlated subquery in oracle
- Problem in wirting data in Excel sheet using owa_util package
- Stored Procedure Coding Problem
- Rewrite query using bulk collect to improve performance
- how to write a query to make its execution time better .And the standards.
- latest row inserted
- how to see all the inserted rows of a particular date
- function
- Use Serial Port In Oracle
- Problem with inserting dates
- Access violation at address 00000364. Read of address 00000364
- trigger types
- Composite primary key
- Table type parameter to a procedure
- hetrogenious database connectivity error from oracle to sql server
- pl/sql coding problem
- Calling a Package
- resolve this sql query urgent
- hi for all
- RMAN Duplicate
- which oracle version and forms can install on xp2
- Copy all values of a column from one table to another
- Isnull Problem
- Connecting Oracle Forms and DB using VPN connection
- Current Opening Balance from the table AR_PAYMENT_SCHEDULES
- sql temt table error
- Updating a column based on value in another table
- Query to find all transactions for a particular user
- database is giving data block corruption
- Reliability & Efficiency of Database links for far located remote databases
- OWS-05101: Execution failed due to Oracle error -6564
- Basic oracle quries
- Select query for Ageing Report 30,60,90 days
- Data limit of Oracle for DataWarehouse application
- what is this exactly FND_CLIENT_INFO
- problem regarding retrieving image from database
- Dynamic sql generation using oracle 10g stored procedures
- select query is taking some time to return values
- Procedure Return two values
- My Stored proc is not able to fetch output in crystal reports
- Issue in invoking procedure
- B* tree
- Use a specific database & find it's tables.
- REG PO- INTERFACE in apps
- PL/SQL Trying to update a table through trigger on the same table
- change in sysdate
- how to run this coding
- converting Date to Date or Char
- Dependent CASE function of another CASE function in a SELECT statement
- Trapping system exceptions
- how to manipulate indexes?
- Oracle 10g r2 setup required
- ORA-00922 Missing or Invalid Option
- Inserting a record for every value from a query
- PL/SQL to Dynamic Method 2 conversion of 3 files (Convert.zip) Pro*COBOL Oracle 10g
- Loading unloading data oracle 10g tables
- Sizing Of Table
- join
- REG Conversions
- Dynamic Report parameter
- Unknown Query Engine error
- Oracle Dba
- Creating a TAPI Dial button in Oracle
- help optimizing transpose query
- problem with mutiple row insert in a table using pl/sql
- Proecdure/Function with conditional inputs
- how to insert data into tables from flat files.
- Looping over broken range
- Writing data to file using UTL_FILE package
- comparing string values
- Newbie Question about dynamic table name references
- Bulk Data insert excluding the duplicates
- Oracle 10g error
- Query required to display a row from table
- How to update column with data from other tables?
- Indexes not being used when using bind variables
- importing .dmp oracle 9i file in the database using Forms Developer
- basic doubt
- I need help below this Query Urgent Please help me..
- DBMS.OUTPUT Group Functions from a Cursor?
- project consultation
- oracle
- oracle jsp connectivity
- Oracle Report In Word ?
- replication: fails to replicate automatically have to manually refresh
- ORA:00933 sql command not properly ended
- ODBC to Oracle Question
- Create a flat file from a repeating table
- oracle payables
- account payables
- oracle financials
- Query to return single record from multiple like records
- Setting up Oracle ODBC Link
- Help
- non-duplicate data from 2 seperate tables help
- query
- in report formula trigger how we use the nvl function with date
- time conversion
- pro*c information
- how to connect vb and orcle database
- ASP.NET and Oracle
- Running asynchronous processes in Oracle
- Urgent Help Needed!
- problem with string concatenation in auto-incremented field
- Create database error.
- ORA-01843: not a valid month
- using clob
- Help with Complex Query
- Mutuation Trigger
- Can't Edit inithsodbc.ora in Notepad
- Stored procedure input...
- bulk collect and for all..........
- Creating trigger
- Why people recommend oracle rather access?
- Oracle Update Statement using Concatenate
- Oracle 10g and ASP under Encryption mode
- SQL query not using index and explain plan gives very high cost
- Difference in Time in SQL
- Report Error
- Data Import
- IN condition and variable
- specifying storage parameters
- How to transfer data from oracle dump file to Excel Sheet
- ORA-02068: severe error from ORAMVS
- a doubt in sql please help me
- port in linux
- problem regarding database and jsp
- Number of Weekends in a month
- Query to get number of saturdays in any month
- retieve the data
- Execution plan
- Regarding Forms Parameters
- CSV to Oracle table
- Oracle reports 6i blank lines in output
- [C#] Import data from one server to another
- Stroing xls in oracle
- Range by Partition
- DBlink to DBLink
- reg apps
- How to handle "select a,b where c=' 1 & 2' in a 'hard coded' odbc query
- SQL command not properly ended?
- Help Needed
- selecting records with "%"
- ORA-03113: end-of-file on communication channel
- Trigger with insert
- ORA-12560: TNS:protocol adapter error
- Query to get Primary and Foreing Key
- How to extract data from oracle using C??
- how to specify package body in toad
- SQL Query with Self Join
- Isnull Problem
- How to remove primary key from table ?
- Result set is forward array.but iwant reverse array
- Oracle Application Server
- Select a random time
- Logical and physical Structure
- Microsot Linked Server & Oracle10 Performance Issues
- Database Instance
- How to retrive value for 12 hours
- PLS-00306 .Getting Problems with OUT parameter
- Explanation needed
- Query in teradata taking long time
- materializd view
- How to retrinve the first top salary hoder
- script by last analyzed database
- Sub : Query to be tuned which uses a table hint /*+ USE_CONCAT */ in Oracle 10g.
- Frm-10095
- Selecting the Same Coloumn Twice
- how can select
- Using Oracle 10g with Oracle 8 drivers
- Difference
- Show in one line
- I Want Know How I Can Attach Bar Code Device With Oracle Form Bulider Using Developer
- Tuning SQL statements
- how to use join query
- How to insert an image into DataBase? and also retrieving
- Change Number
- Space constant
- send report by email
- Help with Trigger Updating same row?
- Problem with INT when creating a table.
- how to create running clock in oracle forms 6i
- Get weired table row reflections. How do I get rid of it?
- How to retrive odd number of rows in my table
- I want to learn Oracle
- Modification of the length of a field in a database
- oracle upgradation
- selecting duplicate record with one different field
- How to get business days between two dates?
- how to create control files
- let i am using varray in procedure .then how to call it.
- oracle reports
- Getting the table name which is using a sequence
- exceptional handling
- procedure????????
- how to display the retrieved data from database in a dropdown menu
- convert number to float
- Stored Procedure processing
- GUI tool for Oracle
- Connection Problem Oracle7.3 to Oracle8i
- convert from 0 to 1
- Illegal datatype equivalencing operation using Pro C compiler
- problem in writing a Query
- Need Help for the error "SQL command not properly ended"
- Top 10 salaries
- How to add $ sign to number data type?
- how do you display the name of a SQLPLUS script that is running
- connection with .net
- Import
- Credentially retrieval failed
- is it possible
- ORA-12500: error
- ORACLE FORMS 9i WITH MDI
- collection as out prameter
- help with pl/sql
- i am not getting correct return values :cp_4,plz help me
- data transfer
- connecting to oracle
- finding Difference in pl/sql
- upload text file to a database
- Plzzz help regarding this......
- SQLPlus SELECT Headers
- problem installing WITH ORACLE
- Read-only DBLink !
- Python and calling Oracle Procedures
- cursor error1
- ORA-00933:SQL command not properly ended
- SQL Math Function Help
- Heterogeneous Database connections - Oracle to SQL Server
- connect Oracle9i on Unix to MS Sql Server
- Updating Multile rows in a table
- Getting wrong error message when running a command
- Clarify Me
- error while creating database
- A trigger to output to a text file
- Concat variable to form Table name inside Select statement
- need explainantion about sql quries..
- Ora-01795
- recently inserted rows
- Looking for DBA who knows DATABASE XML
- Need help to start learning oracle
- ORA-07445: exception encountered: core dump
- Pipe delimitating function
- configuration for *isql
- calling Java from Oracle
- Oracle DBA
- Utl file
- Difference between PL/SQL table and Record Type
- problem installation
- can't install Oracle 8i Client
- Insert email into Oracle
- FRM-92100 on refresh data in a screen
- How to understand this query??
- How VB script will retrive the data from Oracle Database
- Getting Invalid user ID and Password before the applications starts
- Oracle Translation Hub - Using the Trados Glossary
- update two columns at time
- How to call oracle tables from MSDOS?
- How to move backwards
- oracle download
- otn for oracle 9i...
- server problem
- PS/SQL script needed to update and prompt user to commit or rollback
- Insert into a table with sequence and a value from other table
- help with dates
- Count of table column
- Finding the database culture
- Needed DB Query optomized?
- How can I use variable value as a table name?
- performance tuning in 10g
- Random Number Based on another Cell in Row
- import to oracle 9i
- Reference a package in a script
- schema designing
- finding a day that had maximum total amount..using sql
- regarding dynamic SQL
- regarding sql query
- reg Oracle Apps
- I want formatted output
- problem in importing a .dmp file
- Storing images in Oracle
- REG Layout In Report
- help with Perl code to insert a long string (> 32512 chars) via stored procedure