- Function call accross chained dblinks using synonyms fails
- Daily Change in price
- ORA-12154: TNS:could not resolve the connect identifier specified
- error message when running SQL
- Writing a Case Statement
- ORA-01034 Oralce Not Available" errors.
- Without giving condition how to retrieve the unmatched records from table
- invalid userid/password
- Insert taking more time
- Efficient SQL for retreiving latest row
- Removing last character from a string
- any wrong on this DELETE procedure. can we write like this or is there any better way
- Query to find status with different values for a combination of data
- What is the best way to add new field to an existing Primary Key
- Displaying Data in certain format - pl sql
- Oracle 11g OEM configuration error
- Performance Issue on 1 Particular Schema
- To write Bangla Language in Oracle 10gR1 , 10gR2 and Express
- Issue with resultsset getBigDecimal scale
- home page not loading in oracle XE-port error
- e-mail notifications
- Calculate exp(avg(ln(value) as GEOMETRIC_MEAN based on Description column condition!
- mac and forms
- How to write a pl/sql program that will run irrespective of any exceptions
- Oracle Developer 6i Patch 3
- Running Total
- Help with Query 9i
- Removing Leading Charactes
- Short question about creating indexes
- Query not working with between condition
- Error handling in unix
- dependecy case
- Data in ext file dir notreflecting in db - 10g
- Data in ext file dir notreflecting in db - 10g
- Need help in converting rows into columns
- uninstalling oracle
- Query with Oracle date column!
- Advanced Queueing - Callback routine doesn't execute
- CONNECT BY LEVEL in a query?
- Oracle 11g r2 EM Memory utilization
- Oracle Export Import Utility Different Versions
- Oracle IMP running so slow
- Cannot start listener (/tmp related)
- Group by and Total
- Restoring and Recovering steps
- Need help with Query...
- Select Case Columns
- ORA-00604: error occurred at recursive SQL
- Problem with PLSQL Developer
- Query running slow. pls Optimize
- Using Handheld Device
- Oracle EBS cloning
- Which server to buy?
- which oracle client
- which oracle client
- sql * plus environment variables
- loading txt file from sql loader to oracle database
- UTL_FILE with parameters
- UTL_FILE with parameters
- How to use a cursor...????
- Problem during report running queries
- Please help convert to Oracle
- t+1
- Convert verticle table to horizontal
- Create new column with column name as varibale value.
- Performance Issue for join function
- Two LAN Cards for Network Traffic Control Advantage
- What is the Oracle specific format of this timestamp?
- Split string with a special character
- Data Export oracle query
- Error in Create table command help
- Can anyone tell me what is wrong with
- Foreign Key question
- Email script
- input from file
- Installation of Oracle Database for AIX 6.1
- DB and OracleAS upgrade
- Oracle 11g Certification Query
- View help
- Trigger update help
- PHP and Oracle
- Trigger Help!!
- Aggregating Data
- Oracle 11gR2 support in a cross subnet environment.
- Calculate AVG(columnA) based on columnB condition.
- I have a Problem with Bfile
- Find List of affected tables
- WHEN-BUTTON-PRESSED trigger
- procedures and statistical functions
- no matching unique or primary key
- Oracle View
- XML DB - Insert / Update / Delete Items
- Variables V$SQLAREA
- How to remove comma in column
- Decomposing this relation to 3NF
- Blob/clob issue
- datetime mis-match - 9i
- datetime mis-match - 9i
- How to add columns in decode statement
- Dynamic List of Params in Stored Procedure
- Kerner patch upgrade in solaris
- Oracle 11gR2 ASM database configuration on RHEL 6.x
- I want to learn oracle
- Validating excel sheet with an oracle table data
- unable to remap_data varray type in expdp
- PL/SQL scripting help !!!
- Out Of Place Upgrade on Production Server?
- Exists inside Decode function
- How can I make sure that only one instance of a stored proc is running
- Remove few rows in a result ref cursor
- Reason and Solutions for "Ora-01033 Oracle initialization or Shutdown process"
- Upgrade problem
- Natural Joins
- Problem Passing value to LIKE in SQl query
- PL/SQL Exception - duplicated data
- Need an urgent help
- Agent Unreachable
- Sub query
- Issue in passing Oracle User Defined Types to PLSQL from Websphere Application server
- How to design a table for a database?
- Date Index working partially in Oracle table -Urgent
- SELECT FROM tbl WHERE field1 IN (storedproc.field2)
- retrieving dynamic informaiton from tables
- PL/SQL Split string into two column
- Update Query Optimization
- Left join sub query as view
- Issue with DBUA - Trying to upgrade from 10g to 11g EE
- partial distinct
- Oracle DB Server Migration Checklist
- RAC - Listener Dont take the remote vip
- Restoring an oracle database
- Insert into select AND values
- Query based on values in another table
- Calling a function from within a trigger
- Audit Destination Problem
- procedure using bind variable
- Select..........9i
- insert data into multiple tables using pl/sql procedure
- Help With Triggers And Funcions In oracle Sql developer
- Oracle enterprise manager console 10g
- Illegal use of LONG datatype,When Use Distinct in Select Statement.
- exception handling for column not found
- oracle10g
- Oracle 11g Case Insensitive Issue
- Error: ORA-01830: date format picture ends before converting entire input string
- How to stored the result query based on parameters into temp table or view
- Data migration
- Passing parameter from Unix to Oracle SQL
- Add new column in table for convert Celsius to Fahrenheit at run time
- PL/SQL for calculate the Geometric Mean of data column!
- Data Comparability!
- Sum of two table values and values from both the tables
- [Help] Varchar2 parameter as condition in Proc
- Sql procedure cursor loops
- A question regarding Oracle license
- Search Table on the basis of value
- earch the history for the all tables that are created by a user
- Oracle Transparent Gateway Problem
- Ambiguous joins in Oracle
- Convert a SUM to Time Format
- Always experiencing disabled accessbility mode in Oracle Enterprise Manager
- comment for column of all tables. ("insufficient privileges")
- Rman Clone Failure
- genrate xml from oracle 9i
- pl/sql package
- Hi
- Performance Issue
- Reg mail triggering issue
- Guarantee unique access on row
- Better way of calculating RunningSum,MonthlySumAvg and YearlySumAvg
- How to insert in to DB
- while mapping 3 tables data getting twised - help
- Oracle installation
- Ora-12505
- Sql Loader issues.
- Join clause with resultset return by procedure in oracle
- Help Me pls!
- Kindly help with rewriting the foll. query in a better way
- Not getting the DB alerts for one application whenever application goes down
- Error(1,28): PLS-00103: Encountered the symbol ")" when expecting one of the followin
- Help with Student Database Schema Queries
- Altering the Nullability of a View
- Wash Sale Query Help
- logical design in tables with keys
- Problem in formulating query to retrieve data
- Creating a procedure
- calculating the difference between days along with timestamp
- ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
- fedora and oracle 10g
- creating user through command prompt
- Forecast using sql
- whats wrong??
- Extracting first names
- sqlldr in shell script - without clear text password in script
- Need only certain information from a table
- Sync and Append Oracle Schema Data
- Help with Update Statement Please?
- Finding missing records.
- i need help with 11g toturials
- Replcing Invalid dates with null
- ORA-00907: missing right parenthesis variable substition
- Inserting records in only one column
- NEED SMTP return code or error code for invalid email address
- question for upgrade for 10.2.0.5
- ora-02270 no matching unique or primary key for this column-list
- Update with joins
- stored procedure out char string
- Error handling???
- Best OS for an Oracle DBA
- **New to database* Creating sql file
- Odd Date Calculation
- Oracle EE to SE downgrade?
- Converting MSSQL to Oracle SP
- SQL help
- Viewing data from a tree problem
- Joins - Can I add text to where clause
- Archivelog Every 30 Seconds
- No response when fetching the data using sys_refcursors as OUT param
- delete ... where not exists ... performance
- The time difference between Concatenated fields
- Concatenate with a space in between fields
- please improve SQL script (without subselects and inline views)
- Export to Excel via oracle storedprocedure
- copy datafile between instances
- inserting data into table 9i
- DB locking and data corruption problem
- Object Relationship help
- Analytic functions
- Multiple calculation
- Installation of Oracle problem
- How to loop through values of one table as input for 2nd table
- New to this..
- Can you combine the TO_Char and MIN FUnctions
- SQL: Include Name, ID that are not group by elements?
- help me to create view
- data types
- SQL: Regexp_Like - matching individual letters?
- Help with create function and create operator-Starter
- Two SQL approaches - which is better?
- Aggregate, Group and DateDiff function required.
- *Urgent help needed**
- SQL+: Deleted a row, but it is still alive?
- How does oracle handle high NUM_DISTINCT/NUM_ROWS ratios?
- day-to-day activity of database maintenance
- Help with this query please..
- Help needed in a query
- Calling a Stored Procedure from ProC that takes a "Table" input argument
- Oracle Interval partitioning view
- Error(53,3): PL/SQL: ORA-00928: missing SELECT keyword
- how can resolve the listner issue