View Full Version : answers
Pages :
[
1]
2 3 4 5 6 7 8 9 10 11 12 13 14
- ERROR: You do not have SELECT priviledges on sys.V_$PARAMETER view.
- How do I create a Data Dictionary using Oracle Designer
- loading xml file into oracle with dtd validation on,
- portint database from oracle to postgres
- convert number to date
- oracle error. Ora 01033 orcle instalation or sutdown in progress
- jasper and IReport against Oracle
- Discoverer Query
- Form 5 and db10g
- update based on subqueries
- Scheduling concurrent Program
- usage of AFTER LOGON DATABASE trigger
- Oracle Report 6i and Oracle 11g database
- Oracle exp tool
- Potential regression with Oracle 11g in Select Sum
- Oracle 8i express edition work in windows Xp sp2?
- Sequences
- pls anybody tell me wether oracle 8i can be installed in windows xp sevice pack 2?
- System.Data.OracleClient requires Oracle client software version 8.1.7 or greater in
- which command is used to grant all the privileges to hr user......
- data manipulation operation not legal on this view - in a cursor
- need query hw to select last 3month,3 week, only friday only sysdate using dual table
- Call a package function from C#: PLS-00306
- Compute Time Difference in Teradata
- ORA-31001: Invalid Resource-Handle or Path name
- oracle to pg
- Can I create an online application that feeds into PeopleSoft Financials 7.5?
- Filters in Teradata
- what happens when a sql query get executed containing joins in it.explain in details
- mail server with oracle
- invalid file operation
- how to create a view inside a stored procedure
- Materialized view Refresh
- Count Results for multiple choice
- Oracle query help urgent !!
- Apache Installation (https service) issue
- how to create .mtw file in oracle transalationhub.
- can u help me plz
- Joining 2 Queries in Teradata
- joining 3 tables-using oracle 10g
- How to reduce and avoid spool space error in Teradata
- Deleting BG_ABSENCE_DURATION
- Count in teradata
- trigger error
- add constrain in exsiting table
- Hyperlink in Oracle Reports6i
- TERADATA Equivalent of ROWCOUNT
- Scheduled Concurrent Programs
- Grants asssigned via roles not works in PL/SQL
- Help need in Encryption/Decryption Concepts
- How to find the clear text data in an encrypted column?
- What kind of a code is this?
- Need Table's Alter History
- Need logic
- to join two tables which has records in columns format
- where table is stored in oracle
- Oracle Query problem...
- Need help with basic sql oracle queries?
- Adding Adjustment element
- Oracle Application Server Portal Forms
- Help in this SQL
- Discoverer, Detailed aggregate data warning
- oc4j-island:default_island, ajp-host:-missing-, ajp-port:-missing-
- date wise report by using oracle form?
- Using PL/SQL code in Excel Macro
- convert access sql to oracle sql
- capturing user id
- Excel to oracle
- Need dumps for IZO-146
- Discoverer Problem
- adding a menu to responsibility
- Schema level session idle time out in oracle
- Business days calc
- Getting error 'Root transaction falied to Commit'
- Help with a query to copy files (new to oracle)
- registering a function in discoverer
- between operator in oracle
- check constraint
- Create chart
- set number of decimal in avg() query
- oracle help
- Oracle 9i
- Ora-01403
- Fourth,Fifth Normal Form
- newb question about sql+ script for appending to end of table
- Replication Issue in Oracle 10G
- how can we display particular record by using oracle report
- oracle - program around ora-02068 error ??
- Limit on the length of query
- How to get rid of duplicate value
- Oracle Error: Unable to cast object of type
- Performance Issue with Alphanumeric Column
- Create Procedure Oracle Errors
- Oracle error returning value from database
- Update table with multiple joins
- CREATE Table gives ORA-00904 error
- Character Set Question?
- php and oracle
- Oracle Forms: Disable invoking buttton
- oracle sub query issue
- Returning an Oracle generated GUID through an out parameter
- display dates in a month
- User parameters and links -Oracle Portal:discoverer
- Registering a disceverer report
- iSQL *PLUS variable
- Oracle Forms or Java/JSP
- I fail to understand this..!!!
- File Cabinet
- wrong number or types of arguments in call to 'GET_DNAME_FOR_ID1.
- Rows To Columns--urgent!!
- Organizing Categories
- Calender in Disoverer Report
- sql with regex
- submit request with parameters
- Disconnecting from database automatically
- Oracle text procedure?
- Variables in SQL Loader
- Converting report to excel or pdf format
- How to design a report
- Generate SQL from SQL
- Display paremeter in the report
- case statements in oracle
- HRMS Photo upload
- Killing a process and a session
- Execute Immediate VS Dynamic SQL (DBMS_SQL)
- Triggers commit and rollback through a proc.
- Concurrent request from procedure
- Paramter Form Builder in Oracle Report Builder 6i
- Partitioned Index on a non partitioned table ?
- Which cursor to use to execute a DML ?
- How to PIVOT in Oracle 8i
- what is the error in following query
- what is the error in query
- Why do I have to manually make sequences and triggers for primary keys?
- Reg Reports Builder
- Procedure or Function terminates with failure without being handled
- problem to find record between perticular value
- Mutating Error in Triggers
- Oracle Cursor Creation in Reporting Services
- Tns name Not Found
- Wf_routing_rules
- Update Query with a JOIN
- Discoverer Automatic Refresh ?
- How to load CLOB using sqlloader
- How to disable trigger as soon as it got triggered.
- Delegation of Responsibility
- Insert Statement Within A Case Statement
- SQL Loader
- OCILogon Fails But OCIError Returns False.
- delete and truncate
- Problem to use FOR loop to fetch record from a ref cursor
- Discoverer Parameter
- Implementing Manager Self Service
- Problem with the varray...
- Error message comming during import the file in oracle.
- Access Denied to create view in disoverer
- Slow return in Oracle stored procedure
- Oracle 9i installation failed
- Passing large value to Oracle stored procedure
- Getting a MAX() with an upper boundary
- Idenfying LOGS in Oracle - Please Reply
- Offline Database management
- Perl Database SQL query variable passing
- How to avoid DeadLock ORA-04020 error (on views)
- can u tell me this sql querry
- host string
- Apps Scripts
- Oracle apps Fast formula error
- Looking for Trados Multiterm's Glossary
- How to implement log file concept in oracle
- Discoverer Error
- Application that I can paste a query into & extract column/table names
- how to join 2 tables
- How to export/import the excel file in oracle database using sql promt
- Work Flow installation
- Loading images into Oracle
- Parameterized query for schema name?
- Problem with REFCURSOR
- Multiple INTO in stored procedure
- slipt a string into 2 word in Oracle PL?SQL
- How will data of schema will reflect in another schema of same network
- How Fast is ULT_SMTP
- Installing PHP Oracle Extension on SUSE linux
- Date Between Problem
- Cursor that is supposed to return one value Returns duplicated values of same row
- How to search all columns of all tables in a database for a keyword?
- max(orderdate)not working in subquery
- seed data base
- free ebooks
- fetched results not separating
- view constraints on table
- Return first occurance of record
- VB Oracle Connection Data Retrieval
- How to implement LIKE Clause in Query?
- Sqlplus ora-12154
- Long datatype
- group by works, order by gives error msg
- 'java.sql.SQLException: ORA-01401: inserted value to large for column' in Oracle 9i
- top-n queries
- oracle and c++
- help with "execute immediate" in oracle
- Help!!!
- For sql and pl/sql
- How do you call an external script using DBI
- Numeric field in desired format.
- UTL_SMTP PAckage problem
- How do you spool to txt file?
- what is "(+)" in pl/sql
- Need help writing sql to check for records that invalidate a foreign key
- Nested Sum in Multiple groups
- some tips to become an Oracle Proffessional
- how to update few records thru join
- Does an "IF Exists" clause exist in Oracle?
- Is Oracle dead or is everyone talking somewhere else? [eom]
- Microsoft .NET vs Open Source (vs Oracle) - when to use each of them ?
- To find no of records in a particular time span
- pasted sqlplus script no longer running
- Counting Parent Child Level
- subquery
- Oracle question.
- I want a query to find all entries on table1 without a corresponding entry on table2
- how i select columns names from any table
- Linking of Schemas
- Set Nocount On/OFF equivalent in Oracle
- from informix Database to Oracle
- ERROR [STDERR] java.sql.SQLException: Data size bigger than max size forthis type: 40
- how can run PL/SQL from oracle FORMS trigger or procedure/funcktion.
- Sql
- Sql
- run executable program from oracle trigger ( or procedure)
- Database Administrator question
- select query
- query slow intesting
- Oracle Discoverer Query
- Load balancer not working properly Oracle Rac environment 10g
- Tables not seen
- Oracle Query
- PLSQL related query
- sqlplus copy
- CSV file enclosed by "
- Column Settings
- How to get the report name before running ?
- Query to fetch name with mixed case
- database path in oracle8i
- Simple update Table query based on 2 tables joined
- Oracle - Input Buffer
- Error in report
- Different answer sql*plus and oracle forms
- doubt in query
- Error invoking target install of makefile - installing Oracle 9.2.0.1.0 on AIX 5.3
- Creating a new Database and New Schema
- External Table with only one column
- sql command error
- Oracle Vs Teradata
- exporting data from oracle to excel
- Deleting large amounts of data
- how to change the column name to an already existing table
- rows of consecutive dates if the value is same everyday
- Oracle 10 g Client with perl Help
- Uploading JPEG images to Oracle
- Group consecutive records
- How to access new value Statement Level Trigger
- Why Rollback?
- Decoding a date & time format
- Setting Tab Accessibility
- Help with creating a SQL Query
- Cursor update
- How to delete constant no. of records
- Inserting XML into Oracle Table
- oracle batch file
- hours,minutes,seconds not showing in the database
- Simple Update Query using select statement....but why isn't it working??
- Oracle crashes on ESX server
- selecting tables
- how can i get time only in date data type
- Archive Logs
- Pl/sql
- What is a Mutating Trigger and How To OverCome To It
- How to find the total number of records updated in a table when a procedure is run.
- concatination of data in a column into a single row
- like operator for digits
- Multiple Join Query
- DBMS Jobs V's user scheduler Job
- how i can select the latest order for a customer in oracle forms
- site map
- changing line in display
- how to loop in oracle forms
- 'Not Connected Message'
- Storing image in table.
- Sql/oracle format
- How to put IF conditions on COLUMN NAMES...
- Dynamic Sql
- Data Being Populated
- Retrieving org id through unix shell
- Discoverer Apps Registration
- reading text using client_text_io utility
- Search for tablename and column name for one value across 1 database
- oracle functions
- Auto Increment
- concatenation of rows
- oracle versions
- difference
- New Member
- Procedure - Dates Between
- Oracle 10g on Windows Server 2003 (32-bit)
- performance issue on report
- Subtraction of dates
- Oracle Forms Migration 2.4 to 10g
- how to change the initialization parameters in oracle 10g
- Need to download Oracle 7.3
- Oracle Connection String
- group by total breaks in sqlplus
- Executing API with a Select?
- need output without using dbms_output package
- Any oracle formatter or beautifier?
- sample projects
- reg Oracle reports builder
- Performance bottleneck in bulk updates/inserts
- Where clause problem
- how to find the seventh largest number in a column
- oracle 10g installation
- Delete Duplicate rows without using ROWID
- purging data in mviews not in mview logs
- Package used in the oracle form
- How to find who is eldest from date of birth
- how to count no of times a letter occurs in oracle
- oracle
- Reg Oracle reports builder passing parameters
- Er Model
- spool old and new values in SQL
- Mviews
- what does count(1) do?
- Oracle query.
- reg oracle reports builder bar graph
- Comparison of character and number
- Stored procedure
- Problems with outer joint
- Will I able to get a job in software testing industry
- Listener/tnsnames.ora issue ORA-12514
- PSB ORA error DE_id and Position_id
- Reg Database
- Total Number of Employees hired in a certain year
- What is bitmap and
- SQL Plus
- Sql%rowcount
- calculate business days in a year(excluding holidays and weekends)
- Update
- creating materlized view in another schema using dblinks
- Semi Join with 3 tables
- Reg AFTER INSERT
- Book or online documentation?
- How to sort columns and rows in oracle
- number of records
- how to sort days in oracle
- Schema Files
- How to check an jdbc version in classes12.jar ??
- ORA-00604 when connect to database
- Oracle error: ORA-01401:inserted value too large for column
- Deleting large number of tuples from Oracle 10g Db.
- PSQUery with conditional rows
- on_commit trigger
- discoverer installation
- using visual source safe for oracle 10 g database
- Oracle vs MySQL vs DB2 please help decide
- Oracle Internal Error Code(Oracle Version:10.2)
- System freezes
- spilit one column into two columns
- Migration from DB2 database to Oracle 10g.
- Converting a DATE with time stamp to a DATE without timestamp
- Delete Duplicate Records from a large table
- Please help to achieve this output
- open form with parameters
- Linking MS Access to Oracle
- Can I select from a dual table ?
- What is B-Tree is index ?
- what are the variables used in sql & pl/sql ?
- Query to get the output horizontally?
- dba exams
- updating using SubQuery Problen
- 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
- fmcus.msb
- Archiving the data
- SQL : nth highest salary from emp table
- 10 g Installation problem
- Normalization
- connection string
- Copy schema without data
- Copy schema without data
- 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
- Recover deleted rows from a table from archive logs?
- Error in writing to directory /tmp/Orainstall .....
- Finding all tables with a particular field?
- Views and performance
- Installing on Mac Os
- How to diagnose inaproppriate Oracle SGA component size?
- server configuration
- RAC nodes regularly freezes for about 10 seconds
- How 2 split priority, reports low, transactions fast
- 7.3 on 03 server
- SELECT ... WHERE column LIKE parameter||'%'
- Re: Installing Oracle 11.5.8 on Mandrake
- ENOVIA/ MULTIPLE OPENINGS/ NO RELO REQUIRED
- history
- Oracle CBT
- Which database design tool
- Oracle Schema
- SQL 3 or 4 trial key needed
- UNIQUE CONSTRAINT ERROR
- Basic Questions
- Catching "ORU-10027: buffer overflow" exceptions in PL/SQL
- OLEDB and Oracle XE ?
- Patience for a Oracle Noobie
- Slow query on date field via views
- Crystal report db problem
- current sql running
- .NET Reporting against and Orcale Database
- <REQ> oracle lite info
- S: Biomega Mark Newson MN03
- Obtaining a Column Which has MAX in Another
- writing records while doing select.
- Multi Master Databases
- spool file: saing to non default location
- Mercury ITG developer wanted (nashville, tn)
- Request for Resume's - Siebel Production Engineer IV
- deducing ranges in SQL
- Oracle OLEDb
- What is it like to work with Oracle?
- Great Job Board
- A great onestop spot
- Generating CREATE TABLE statements
- Instantclient 10 on Solaris 10