- Oracle Scheduled Job
- Audit Session
- Partition Function
- trigger errors out
- Dbms_rowid
- Oracle Evaluation
- Sequence got smaller
- Common Table Expressions
- How can post data (via soap/xml) to a web services?
- SQLPLUS if then
- utl_http transfer time out issue
- How to get recent error message in sqlerrm?
- Oracle Joins Vs Not Exists
- Outer join and subquery
- Making sqlplus default to GMT timezone
- composite with using
- ora-01841 (proc error in prod but not in dev)
- SQL unique column
- about server
- Use FOR rec IN <variable>
- All Months between Start date and add_months(start_date,12)
- Regarding Batch Job to retrieve data from Client DB to our local DB
- Newbie stuck on sql query
- Query Design Question
- Compare two tables and get a new table
- Simplified Query
- Wrong results with comparision operator
- Index Space name
- Trigger to call a procedure
- need help for Converting columns to Rows SQL
- Ref_cursor issue
- Before Trigger result set.
- Truncate time using SQL Loader
- Update query - ora-01427 error
- Mutating Trigger. Advice welcomed.
- create trigger
- problems using DBMS_JOB
- outer join query problem
- Problems with INTERACTION_MODE, NON_BLOCKING
- Join with a + 0
- Help needed for Inserting chinese character in DB(Oracle)
- problem loading jar files
- ORA-00936 with Oracle script
- Documentation of Forms 6i application
- sum and mod statements
- Tracking Trigger!
- Search all tables for a certain data
- Need SQL Query
- Need SQL Query
- Saving current env in sqlplus scripts
- Select against functions or procedures
- Oracle 6 DB support
- Inserting data into table from storedprocs
- Deadlock with Inserts into Unique/Primary Key
- Package Body Please Help
- Cursor Question
- need help with write a sql query
- Run SQL Loader without inserting data
- please help sql
- How to prevent CPU's overloading while using Parallel Query
- how to pass recordset to an oracle stored procedure
- Which is Better and Why it is better?
- Connecting to MySQL from Oracle
- Data Warehouse Query Performance question
- :NEW.<column_name> getting old value when that column is not updated
- Forcing Nested Lops in "in subquery" (10g)
- problem with update
- PLS-00363: expression '0' cannot be used as an assignment target
- imposing check constraint on table
- How to find records with minutes range.
- sql loader with pdf files
- How Can I create my stored procedure?
- getting error while starting apps
- Select Query help
- Bulk Collect
- ORA-00904: "AB"."ACCDATE": invalid identifier
- Dynamix SQL based on stored data definition in a table's column!!
- Execute Immediate, with dynamic "INTO"?
- "not exists" SQL
- ORA-06533: Subscript beyond count
- NOT EXISTS replace with NOT IN
- ORA-01291: missing logfile, but not actually
- query help
- query - create columns based on max value
- BLOB to LONG RAW
- Query Rewrite to Utilize Materialized Views on a Remote Database
- FRM-40501: Kindly resolve
- lock lock
- Query Help
- Oracle equivalent of SQL Server table-valued functions
- Unable to open Oracle 10G DB
- is there any alternative solution for this??
- sql query
- operation would exceed the maximum number of opened files or LOBs
- Insert Calculated data in Table column
- Multiple Outer joins on same table
- How to change the rows in columns (in sql statment)
- Using StoredProcedure to return from a function an array of objects
- exec immediate
- How to get NULL values?
- Memory leak using 10.2.0.3 OCI client on solaris
- Error "Skipped (unsupported datatype)" with NVARCHAR2
- correlated sub query for calculated field
- problem with inline views
- display different number of rows
- Something about query - I'm not getting
- sys.dbms_system.ksdwrt syntax
- display different number of rows
- Simple Design Assistance
- display as a table
- updating records
- FRM-30050: Block with uniqueness check must have at least one key item.
- need clarification
- Count of a ID in another database
- Problem in Procedure if then else
- Reference to uninitialized collection - Help!
- Tuning a query
- Identifier is too long
- handwriting in forms 6i
- decode in order by
- Oracle joins
- return code
- How to convert row to columns
- all name in one column need separated
- SQL Tuning
- Query working Oracle 10G not working in 9i
- specifying index tablespace while enabling disabling primary key constraints
- PLS-00405: subquery not allowed in this context
- exec procedure Tuning
- Encoding Problem
- calling varying stored proc
- write a query
- Script Problem after 10g upgrade
- how to using Variables
- extract details from inner query
- ORA-01403 no data found error
- SQL - Help with Analytic function
- find minimum visitime if more purchased date
- XML issue
- Question about table name with sysdate pl/sql
- Another ORA-06502: PL/SQL: numeric or value error: character to number conversion er
- extract a part of value from column values
- datadictinoray view
- Using the DECODE function in the ORDER BY clause
- SQL query case sensitive
- insert statement with left outer join??
- eliminating two codes using <>
- SQL query question about removing characters?
- sql help(finding average of last 30days)
- need help dicifering between AM and PM
- Need Help with Date Buckets - Logic
- inserting CLOB from sqlplus
- query probelm for selecting right
- Why does EXECUTE IMMEDIATE exit a loop?
- pl/sql to gather statistics for a View
- Order of Joins Affecting Rewrite?
- quary help
- ORA-00600 Error
- Help required - need sources for end user design and implementation
- displaying weeks
- Variables in SQL Loader
- How to rewrite this sql query without using subquery??
- LIKE command
- FILE NAMING IN RUNTIME in scheduler/plsql code in 102g. please help, thankU
- Selecting the number of characters from a field?
- Deleting a row from standard table
- unable to upload photo in HRMS
- Stored procedure which is valid raises ORA-06550 error
- analytical function help
- Problem with IN operator
- ORA-01410 related to SGA change?
- Merge clause retrieves ORA-00923 FROM keyword not found where expected
- wrong number or types of arguments in call
- multiple inner join error
- dynamic library+ Linux + ORACLE 10.2
- PLS-00801: internal error [phdcsql_canonical_sql]
- List Item Problem
- Disonnecting from database
- Tool for online viewing of DB relational model
- UPDATE query with JOIN
- Delete Fille From Form6i
- Bulk insert
- utl_smtp won't send mail
- Data load through Control File
- SQL Query MAX question
- PARALLEL query with ROWNUM
- dbms_job.submit doesn't work ?
- How to load tab separated,tab delimited datafile with SQLLDR
- Maintaining data history
- sqlldr - look up on table to find column value
- UNION Query Columns
- PL/SQL Package Error Related to Oracle Version?
- Get MAX from column
- How to call a stored procedure from View
- cursor for loop using function returns PLS-302
- How to find user name or login name?
- order by
- select the highest number from 3 numbers
- cumulative sum with weight ratio
- Move data into different columns
- SQL query to merge columns into single column in another table
- [Microsoft][ODBC driver for Oracle][Oracle]ORA-00911: invalid character
- PL/SQL Help
- Problem using CTXXPATH index
- ERROR: ORA-02019: connection description for remote database not found
- DELETE Statement
- Some Basic Doubts about HAVING CLAUSE,SYSDATE,LONG datatype
- Procedure execution doubt
- HAVING CLAUSE is haunting me
- Plsql help..
- Getting PLS-00905: object APPS.APPS is Invalid
- SQL commandline commands,SQL help,practise paper, edit previous queries
- 1)ORA-00904: "E"."AVG" invalid identifier2)How 2 See Savepoints
- Oracle select statement returning huge dataset
- 10g Seeing Non-ASCII Characters as Multibyte
- Drop table does not work even after disabling constraints
- Query question
- NOT NULL constraint at table level,pseudocolumn,Grant select on selected columns
- Audsid for pooled connections
- Writing to a .xls file using UTL_FILE package
- Simple Newbie Questions about SQL and Oracle 10g
- Creating External Table DDL - Oracle 10g
- sending mail using a job and a package
- Oracle 9i Pivot ??
- convert .FMX to .FMB
- Sorting in oracle plsql tables
- How to fetch manager of Order Creator in Oracle Apps
- m
- UPDATE multiple ROWS with different Values in a single statement ?
- !Oerr ORA 00904, Career opportunities for freshers in DBA field
- Matrix Form
- pro*c problem
- help on multiple queries ( i think )
- missing key word
- not able to install the database in RAC environment
- Procedure problem
- query time
- Database SQL Query
- Storing select query result into array and using in another query.
- oc4j-island:default_island, ajp-host:-missing-, ajp-port:-missing-
- Changing column datatype
- Help with a heavy SQL with 4 table scans
- Data in different Order
- Two OEM 10.2.0.4 - One Database - Standby on other database
- when-validate-item help
- report for last 6 or 3 months
- Insert data using SQL or SQLLDR
- Workstation Log File From Server Stored Procedure
- Query Help !
- ORA-06531: Reference to uninitialized collection