- Can Someone help me with the logic for this Procedure
- help inserting sequence into 5000 row table
- Primary Keys Issue on Remote Tables
- Forms within Portal
- Development to QA to PROD migration
- Sql
- doubt in exception and trigger,,, please help
- Unsatisfied symbols: sqlcx2t
- Storing Word Documents in Oracle
- Differences between Oracle 10g and 9i
- How to isolate directories in path in loop?
- query help
- Privileges on Package Body
- Select child records
- SQL q !!
- Simple RANK
- Conditional Join?
- help on query pivot...
- Error while processing Large XML File
- Do I use a Trigger here?
- Bug in Outer Join Logic, Oracle 9204?
- problem with connect by prior
- morethan 3 consecutive rows
- Advice for application development
- Max effdt in a sql statement
- To Update null columns- which is the best way
- Trigger question
- Update a running total field in table 1 from column in table 2
- Function to convert varchar to CLOB?
- Is it possible to use combination of DBMS_TRACE and Session Trace
- oracle markup drsxsopen error
- problem with "drop table"
- get data from row to columns using sql
- Ora-1406 Very Very Urgent!!
- Group By in Dynamic SQL
- Data Manipulation
- Script that adds up the value multiple rows in the same Table
- Select LONG column from remote table
- Insert as select, capture errors
- Help Enforce Data Integrity Problem In Forms Builder
- use cursor
- How to pass recordset to Oracle report 9i?
- Error while running report in 10g
- fetch all rows
- Statement parsing from stored procedures
- Problems With Execute_query
- pl/sql challenge
- works with TOAD, works with sql*plus, but NOT FROM APPLICATION!!!!!
- ORA-06531: Reference to uninitialized collection
- decode query
- Login authentication against Database user?
- use greatest function sql to get a later date.
- ERD Help
- Add a column to the Primary Key?
- XML Comparision - Urgent
- Update large table based on substring
- Union
- Default file location in SQL* Loader
- SQL -Sum function
- Materialized view source columns
- Retrieveing The Clob Fields In Oracle 10g
- lookup for a file in a specific directory
- Oracle 8i Tuning
- Reports6i
- Apportionment of value to 100
- Merging data
- Row wise data
- I really could use some help here.
- Query to check when the table was updated
- retrieving the 2nd most recent effdt
- HELP! Oracle 10g .NET ODAC driver broke microsoft's driver
- Software design pattterns
- how to see all the table names of other user
- Verifying two tables for multiple records
- Triggers and views
- How to calculate time scale difference?
- query to find second largest
- Formatting the table column
- ORA-02074: cannot SET SAVEPOINT in a distributed transaction
- Insert statement
- create table without constraints
- Unsorted Query
- PL/sql trigger code !!
- Mercury ITG....configuring execution step
- Need For COMMIT after insertion in AQ
- Select from ranges, seek faster then Between solution
- Problem Refreshing Materialized Views
- ORA-00926: missing VALUES keyword
- How to get sequence string from pattern?
- Update from select
- Question about Refcursors
- sql help
- Error creating AQ with nested tables
- Procedure Slow/ SQLPLus Fast
- Analytic Space Manager problem
- Hi, Please help to display 1-25 & calculate %
- DML through DBLink
- VB code on 8i client OO4O (2.3.2.2.0), become very slow on OO4O 10g client
- select and insert in sql?....
- Forms9 - Windows and Canvaces ?
- Plz Help
- i want to conncet to sqlplus with run sql..
- Problem with linked server to Oracle
- how do i insert a shell var into sqlplus ?
- Oracle stored proc fails without raising exception
- Incorrect and inconsistent result while grouping very large volume of data
- Problem in inserting row with merge statement
- C# Oracle-Types in SQL Developer
- Oracle 6i reports query
- views
- How to run sql script from store procedure / or ajava
- sysdate and userid
- accessing ORACLE BITMAP INDEX from c/c++/java program
- querybased on weeks
- two right outer joins
- PL/SQL help To check date already in use
- How to find last updated record of a table?
- Removing File
- getting message in form
- Problem with trigger: ORA-01722: invalid number
- Collect query results from several schemas
- sp2-0223 error unable execute the qurey from sql*plus
- Execute Immediate
- which is faster - create table select or insert table select
- FASTEST METHOD FOR HUGE TABLE UPDATES & INSERTS
- Performance issue while select from view..
- package
- Pick the Printer name in Report 6i
- Rename version-enabled table - i think i found a bug
- Multi level hierarchy Printing
- ORA-01403: no data found
- insert zeros(0) in maxtrix report
- time part of datefield
- Output under Exceptions
- Is data sorting in JDBC is less expensive than sorting in database
- How to add additiona PO approval WF Notification
- Escape character for &
- Query help
- How to obtain the OS user who modified table data
- Syntax Question for an Exception
- unable to create program unit
- query to concatenate three record in one row
- showing PDF image in forms
- i want to see table names of other user
- creating video object in D2K Forms
- spool file at server for each client login to SQL
- URGENT: How to set page length in Report 6i
- query help
- date query
- Problem on sharemem library, rset.h, (Pro*C on AIX)
- Oracle Discoverer 4i Previous date balacne
- Handling special characters in Oracle
- Trigger fails to fire
- execute immediate proc
- hierarchial tree / query
- pulling only numeric data from varchar data type field
- SQL identifier
- Large Scale Updates using C#
- create dynamic groups like; ABC, BCA, CAB, CBA...
- create a bad file while creating an external table
- ORA-00997: illegal use of a LONG datatype
- GEnerate sequence for group of rows
- display
- Forms 10g compiler crashes.
- LOV in d2k
- how to find first occurence of character ina string
- ORA-20001 on API call to APPS.PER_PEOPLE_V7_PKG.UPDATE_ROW
- problems while parsing an xml file into a tables
- Error creating customer- 'AR_NO_ROW_IN_SYSTEM_PARAMETERS'
- DBMS_CRYPTO question
- DB backup from Form
- Interpreting nulls.
- Help Me
- Oracle proc returning XML
- loading of data from XML files to Oracle database
- Mailmerge in Forms 6i
- plsqlblk to make insert to new table an exception pk violate just skip& do nxt insert
- Guidelines for using ERwin
- JDeveloper 9i UIX JSP Oracle DB
- Table contents to flat file
- Error when trying to select last 4 digits of a 9 digit #
- query using table partition
- OraOledb err when Special Characters are in Column Name
- case vs decode statement
- US Territories (Guam etc) Fail in Customer Creation
- HR Title Fails- 'Dr.'
- ODP.NET Bind Parameter in Oracle 8.16
- Update
- Sql query help
- Failed to connect to an Oracle 9i remote database from a .NET 1.1 Web application
- Performance Related Clarification.
- Namespace problem
- sql query plz (tables list with given count)
- Sql Question
- Issue with oracle analytical function
- Query To Find the no of Males and Females in a Department
- Problem building a trigger using a BLOB field in Oracle 10
- how to enter only a-z or A-Z in a field( no numerals)
- PROCEDURE help!!!
- Deleting Duplicates
- Querying/processing XML data
- Help pulling data from 2 tables
- Can I alter my own expired password after PASSWORD_GRACE_TIME is over?
- Problems with XMLQuery / XQuery in Oracle 10gR2
- problem passing parameters to oracle9i from C#.net
- how to use alter table statement in trigger
- Not able to find Pro*C Precompiler
- Setting Counters in Triggers
- Materialized View Refresh Probs in Oracle 9i
- Converting XSD to Oracle DDL
- Poor Performance Across DBLINK
- SQL Injection
- Datatype to use when applicaton Allows time to be entered
- Unique key violation in 10g
- XML db vs Relation db
- Returning the most recent record?
- Merging XML Document
- userenv function
- Help on Database design for Inventory with FIFO costing
- Shared Pool Tuning
- reporting tools
- The way to control appearance position of alert mesage in Oracle forms.
- Plz Help!!!!
- how do i return the count from a table through a procedure
- Oracle9i Job get hanged
- Bulk collecting the results
- Help on Database Design for Pet Shelter
- query show time + 3
- Send e-mail with attachment file
- This query should fail with 5 "from clause not found where expected" errors, but..
- Replace only once
- Query help
- SQL help
- remove duplicate record
- Cursors Vs. Views
- Reporting Duplicates
- Wrong result with NLS_COMP LINGUISTIC
- Pivot select Query for Report
- migrating SQL-SERVER to Oracle
- accessing object types in oracle.
- How to select specific rownums from table?
- How to read cursor SQL in SP
- Displaying PDF from Oracle Application Server
- Error in Sql Statement
- Column name for a SELECT obtained from an inner SELECT.
- How to read content from directories in Oracle
- PLSQL - detect if the client application has started a transaction?
- English being saved instead of Greek
- Query doubt
- Time Dimension Table