- join of group of joins
- Correlated Subquery vs Nested query
- Commiting only a part of transaction in remote db
- How can I update the area automatically?
- ORA-01031 error executing stored procedure
- triggers
- Remove duplicates from selection output
- how to use concat and group by at the same time?
- case in pl/sql block.....
- SQL - Problem
- Trigger QUestion
- How change Column Data Type from Number to Varchar 2 with out deleting data
- Im not able to run the form in the web browser
- SQL Prompt
- Problems running sql script
- Oracle SP in ASP.NET
- how to make sure 2 apps dont get the same row
- a BIG problem with a select statement
- Question on Wild Character
- Sql - Join
- bind variables
- Passing XML file as parameter
- SQL query to weed out old duplicate entries
- No duplicates
- union+order by
- compare clob and varchar2
- Make two fields Unique?
- insert superscript in oracle!!!!
- Full table scan
- Bit Wise Operator
- Oracle 8.1.7 SQL Correlated Subqueries
- little confused on query
- Run From without asking username & Password
- Problem:Reading from a Port using form 6i/Dev 2000
- OCI 9 - Describing INSERT,UPDATE,DELTE Statements
- Please Help!... How can i gen english Oracle Error Messages?
- outer joins to more than one table
- dbms_utility.name_resolver
- How to call stored from another stored procedure..?
- SQL Prompt
- Rtrim
- union query
- IP Address
- decode in plsql
- Adding new column for Transaction counter from SQL query
- Error Message
- 24 hour date/ time?
- select does not exclude records as expected
- Compare two records
- Defining Referential Constraints
- Internal heap ERROR 17177 addr=0x0
- Text index(InterMedia Text)?
- Trigger
- Function
- temporary tables in stored procedures
- GMT and daylight saving times?
- Query help
- exporting table with selected columns
- Inserting data
- Loop one time takes more time than loop 200 times ...
- Using ESC key to close Forms at Runtime
- Developer 4 vs 6
- Indexes
- query question
- New datatypes in 9i
- ORA-01438: value larger than specified precision allows
- put forth your views/inputs on this
- Diference between 8 and 8i
- copying table
- Suggestions to easy my headaches on a bad data load?
- few questions
- SQL: Ordering a result set
- update statement problem
- Problems with DLLs moving from 8i to 9i
- The first and last record in a cursor for loop
- Decode function
- Access Oracle Datastore thru Virtual Driveletter
- which schema a procedure runs in
- How to use ' in single quotes in a update statement
- Rep-3300 & UI-4409
- Constraints and error messages !!!!!!
- PL/SQL performance tuning
- Function to calculate hours
- report printed though USB port
- Most recently inserted records
- Orageneric8.dll
- Help - I'm mutating....
- Archiving OLTP
- ORA-00911 error occurs using ExecuteSQL to make calls to multiple procedures
- Cursor current of??????
- TRIM() in PL/SQL Code
- Error Loading Apache with PHP and Oracle
- How to net send from Oracle db?
- Validate field
- Performance Problem with SQL query
- Calling Reports from Oracle Forms problem !!
- How best to calculate a persons age?
- Acessing XML docs through Oracle tables
- Please help...........urgent.
- ORA-12571 TNS error, on PC with 9i client as well as 8i client
- Private Rolback Segment
- mutation problem with trigger
- Trigger
- SQL Help
- DOS based commands from Developer 6i
- performance with INSERT/EXCEPTION/UPDATE pattern
- Sum by week?
- v$session values after database logon triggers
- Making an ODBC call from an ORACLE Stored Procedure
- Want to know about set command
- How to convert fmx to fmb
- mview doubt
- Oracle ebook, please help me
- SQL conditions - use of NOT
- Help need in Using oracle as backend with visual basic.
- How to reduce the time taken for LOV to come up in forms 4.5?
- sql help with grant script
- unable to create Repositary in Designer 9i
- Tracking changes in Oracle Designer 6i
- select stmt
- How to reduce the size of a referenced horizontal toolbar in a form
- PL/SQL compiling problem...
- sites for informatica
- SQL help with || and WHERE
- Help with using values in oracle statement from list
- pl/sql quizzy...
- pl/sql quizzy 2...
- Frm-10142
- Displaying Multiple Row Value from BackEnd Store Proc to Form's Text Item!!!
- FULL SCRIPT of PREVIOUS PROBLEM (DISPLAING Store Proc's VALUE FROM Front End)
- Context Query: Possbile to use from Front End (ORA Form 6i)
- explain plan for select
- Truncate Table
- script to change numeric data
- oracle load data
- SOLVED!!Here's Code:Returning Multiple Row from Backend SP to Form's Text Item
- emove spaces in phone number
- Raise_application_error
- dbms_job.submit giving me error
- materialized view & user defined data types
- Newby: How to execute an stored Procedure in SQL Plus
- Using clob/blob data types
- PL/SQL Tables and Blobs
- Passing pound(#) value in parameter list(For PSP page)
- Partition count
- write on file
- Calling a stored procedure from C++ using ADO-OraOLEDB
- What do I need from the Oracle side to connect to php via ODBC?
- Error - FRM-10043
- %ROWCOUNT vs. COUNT(*)
- count(1)
- utl_smtp package with a table
- Urgent help needed!!
- Frm-10256
- if else statement
- Dynamic sql (select) and binding IN lists
- ORA-12057: materialized view ... INVALID and must complete refresh
- How to Change Data Blocks
- saving problem from D2K Form
- SQL Help
- Accessing REFCURSOR in another PL/SQL program
- materilized view
- Query problem
- Comparing 2 charater fields
- user_jobs column NEXT_SEC
- instrb
- shell script question for dict dbase
- Binding variables using ODBC
- Designer 6i/9i under Linux?
- Performance Tuning
- Can anyone reccommend a good book for learning Pro C
- Bind Variables
- Error running procedure using SYS.UTIL_FILE
- Help w/ select statement
- Leaving a cursor open, should I?
- Decline in query performance after partition
- check if object pre exists before creation
- Update Help
- Materialized View - Interview Questions
- Help regarding this query !!
- Mview with GROUPING SET
- This SQL is for hierarchical Trees but I dont understand it
- What is A MVIEW?
- Analytical Function in MV
- Best Approach for Data Cleanup Project
- Materialized Views
- Ordering hierarchical queries in Oracle 8i
- Help with DECODE statement
- data manipulation
- Designer 6i generation of PL/SQL code?
- problem in form..
- "Oracle Error: -22275/ORA-22275:invalid LOB locator specified" /dbms_lob.freetemporar
- ORA-06502: PL/SQL: numeric or value error
- Help needed with Simple Query!
- disabling the default form functions
- execute immediate...to create table
- max size of characters in pl/sql
- Optimization of query, version 8.0.5 of Oracle
- Read into regedit witch Forms6i
- Jdbc
- Frm-92060
- Help with this Query Pls
- how can I get address from a table?
- last_day Equivalent in DB2
- How to get the time in asc order ?
- Forms 9i
- inserting values into REF datatypes
- Forms 6i and Oracle 9i DB Server
- ora-00904 and merge
- insert date and ime stamp in table
- REP-1212 - reports 2.5/apps 11.0.3.
- Need help in using ref cursor for this function
- rep-1108 error
- cannot create a fast refresh materialized view from a complex query
- materialized view
- Differences
- Indexes
- querys
- Optimization
- table space size and buffer pool size
- executes
- Help on web Development
- procedure HELP
- Some tipical problem
- Query!!!
- Can I trigger on the end of a transaction (upon commit)?
- Qry to find no. of occurance of a character in a string
- Memory Leak
- Web deployment problem
- Help with Sequence Numbers
- How to do this in report
- running a forms 9i application
- Report display problem
- problem with trigger mutation
- retriving values from a radio group
- problem?
- insert a specific time into my date column
- remove first 3 characters from table name
- Retrieving rows of a table in a tree format
- problem in report with number and varchar2
- Outer joining
- Migration problem
- increase font size in the report
- Binary search in oracle 9i
- Stored Procedure Compilation Error
- exception in procedure
- Why using this kind of "Insert Statement" ?
- query subsutution
- A way to pass :NEW to proc in a trigger?
- javaw.exe file not found error !!!