View Full Version : oracle answers
Pages :
[
1]
2 3 4 5 6 7 8 9 10 11 12 13 14 15
- how to changing number to word in oracle forms
- SQL query to display the Ename of employees in EMP table in lower and uppercase
- I am getting Bad bind variable error when i try to create a trigger before insert, up
- connection description for remote database not found FROM SAP ORA-02019
- How can I get list of all tables underlying in a MATERIALIZED VIEW
- How to create KEY for hyperlink Rpeort in Oracle 11g
- Oracle Critical Patche Updates and Security Measures
- display pdf file into ole field using forms 6i
- Case Statement in Oracle with multiple like conditions and one single column as resul
- create a schema for existing database
- Unable to call the Procedure inside Trigger
- Reports problem:I am submitted this code but reports not run.
- how do i start printing after previous line printed on page using oracle report devel
- integerated heterogeneous database(Mysql and oracle)
- how to update some value in different rows
- Oracle Sql query having error ORA-00933
- Oracle Select Destinct Dups?
- Disable\enabled Constraint
- How to delete a row with all foreign keys
- Need to dynamically select columns in a table which are not null
- Hi, I am getting error to execute a pkg.
- I need help. I am trying to run this in SQL devoper and Im getting an error ORA-0900
- How to combine the three SQL statements in a single statement
- Searching multiple columns for a single word.
- How to load different language data into oracle database?
- How to run multiple queries in SQL Navigator?
- ORA-01002: fetch out of sequence occasional exception while running business process
- how to get minimum item in a block- oracle form? what's wrong?
- how to add primary key constraint at the table level what is the syntax for that expa
- Retain and Swap characters in String
- ORA-06519: active autonomous transaction detected and rolled back
- The specified store provider cannot be found in the configuration or is not valid
- Different results for Date range
- how to set in r12fnd_client_info.set_currency_context(reporting_ sob_id_char);
- Removing semicolon data containing in 3 columns arrange in 3 row data
- How can convert column have html data to text with same design in crystal report
- Deleting Duplicate Records from the production table
- error (ORA-01704:String literal too long)
- get min_value, max_value from Table_Name/Column_Name in a table
- ORA-00922: missing or invalid option
- How to sum two fields value in third field in oracle apex
- To know user default tablespace size
- PL/SQL Cursor - Reading records row by row and ignoring values
- Is being DBA Good for me?
- How can I find out the min/max value form multiple tables?
- Update multiple rows of a column by same value in Oracle
- ORA-01467: sort key too long error on oracle 10g
- Convert ms sql query to oracle query
- count number of grants in a role
- How to handle null columns while using minus
- RMAN bkp through oracle scheduler for noarchivelog mode db
- Getting SP2-0640 Not connected error on Sql Cmd Line
- Which db is good for 64bit cygwin on windows7
- Oracle Forms 10.1.2.0.2 ( Custom Form development Issues on Oracle ERP 12.1.3
- export data from oracle 8i and import it in oracle 11gR!
- in and out oracle parameters in vb.net result in null errors
- GIS for Oracle
- TNS Listner is not started
- fetching rows one by one and inserting rows in another table to cursor
- ORA-00933:SQL command not properly ended
- how to check the dob is less than the curent date
- Min value with all other columns from the table
- How to use a db from other system?
- Do we cab to create two ASM instances in the same server for allocating disk groups b
- remote database connection via SQL Plus
- ORA-02291: integrity constraint (STARTUP.SUPER_SSN_FK) violated - parent key not foun
- trunc(hiredate) = trunc(sysdate) or trunc(hiredate) = to_date('2012/02/12','yyyy/mm/d
- Count of Consecutive Values in Oracle
- before delete trigger to confirm
- How to store Arabic Characters in ORACLE database?
- How to combine DECODE and SUM with a calculation
- consult about procedure insert clob into db
- ORA-06508 PL/SQL: could not find program unit being called
- How Oracle9i Form Builder interact with Html waebpage??
- result coming twice , no conversion
- load pdf in oracle 11g database
- View pdf files in Canvas Oracle form 6
- Update Query working on SQl server not on Oracle
- ORA - 12541 Message "NO TNS LISTENER"
- How to find fourth Saturday of month?
- How to collect Oracle performance counter values by using query?
- Now to prevent cycle creating in hierarchical data
- Compare two tables field by field
- Instr function seems to be vague
- ORA-01427: single-row subquery returns more than one row
- Hoq to DROP and Re Create the parent table P1 which has child tables C1,C2,C3?
- CAN Python,Ruby and Perl be used as front end for oracle SQL???
- Need help creating PL/SQL procedure using function
- career shift.
- last modifications in column in table oracle 10g
- oracle database problems
- date format
- second highest salary use the subquery
- Sql query - orcale database.. Need to retrieve a row with generic condition
- Regarding Source - code of Oracle Database
- Datediff
- comments need to add in one row
- how to convert varchar into integer type in sql
- Query to return multiple minimum rows of each value
- For each month show count - multiple count
- cross tabulation query related to pivot operator
- read value from exe
- Toad download link
- Issue with Cursor in the Stored Procedure. Please help as soon as possible!
- Oracle11 G database partitioning
- how to find server-class of a database
- What materials should use to prepare for OCA certification exams
- Oracle 8i release 8.1.5 installation in windows XP sp-2 or in Windows7
- Query to get IST(Indian standard time) time
- how to delete archivelog automaticly
- report error
- Group Employees without Table using PL/SQL
- ORA-01830: date format picture ends before converting entire input string
- how to insert nclob data into a table
- Least rate in 6 months bought item base on item name
- Retrieving data by using live parameters....
- Copy (Import) Data from Oracle Database To Another
- first time- query is running fine, then executing the same query is failing.
- how to pick mail data from any mail server and store it in oracle database
- Update a table column with data from other table
- how to convert date of birth in (dd-mon_yyyy) this format?
- What kind of Oracle certification have you got?
- Sql instant client giving error during installation
- created PL/SQL procedure and get error PLS-00306
- Excel/CSV data to Oracle Tables and compare data
- Need SQL Query: produce output of 100s, 1000s, etc. based on table data
- Where Are Transaction logs saved in Oracle Db
- Using exception handling in a Loop w/ Cursor
- Execute triggers in order wise in PLSQL
- embed image into html body using oracle it is not working in gmail and yahoo
- check user is catalog user
- How to load a specific row alone using SQLLDR ??
- How to do this query?
- Help me in searching the link, for downloading SQL * PLUS in windows.
- how can i insert 3 list box data in one column in database
- Datatype cannot be changed in table
- passing values from unix to stored procedure
- In PL/SQL what is a difference between a cursor and a reference cursor?
- How to execute a small piece of code in Toad?
- Executing a procedure
- Difference between a stored procedure and a procedure?
- Why are we going for cursor, can't we use procedure instead?
- Find table Name based on column name
- List out data from database if data status not equal to yes with joint table
- Oracle 8.1.6 on Windows XP - database not starting
- insufficient privileges when i create a tablespace in user flshop
- How to get data for a particular date till Today
- oracle error ORA-02449: unique/primary keys in table referenced by foreign keys
- error run_product(reports no longer use inestted (run_report_object)
- Search a string in entire schema
- ORA-01735 : invalid alter table option
- Inner Join with similar tables bring different results
- change window color on pressing push button
- Importing data from JDE char 3 via datalink into Oracle; "0xC14040... display in rows
- Select with AND OR clause
- Difference between In and Out parameters in Oracle functions
- find total row
- count row after select statement
- Primary Key duplication in the primary key column
- how find total row of count(1)
- Invalid symbol displayed in select query result
- how to code for data mining
- column type incompatible with reference column type
- what is the difference between inner join and equi join?
- CONNECTIVITY of oracle table to vb
- How to make indexed or linked table
- error in code UTL_FILE
- problem in spool command
- toad login
- how to move one schema db to another schema db using toad 9.5?
- Aggregate function, count or max, on >2 joined tables where pk is composite
- how to insert video into oracle database?
- Inserting date (mmyy) into table
- Help with Order By AND ROWNUM by a student
- Fatal pl/sql error after submiting report im getting this error
- 1Z0-820 exam training
- Problem: Importing .csv file into oracle database 11g
- examples of non-printable characters.
- How to restore the Oracle 10g XE database.
- Error: ORA-01427:single-row subquery returns more than 1 row?
- How to return records where the value in column is less than 4 digits using cursor
- PLS-00049 bad bind variables??!!!!
- ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved
- Split field that has multiple Carriage returns as field delimiters
- Equals Ignore case query
- How do I Create a Comma-Separated List using a PL/SQL Query?
- how to take full database backup using toad
- how to execute this PL/SQL procedure?
- how to change sessions_highwater value of v$license
- Connecting to Oracle Database from Unix?
- how to grant sysdba privileges to user
- what is the best datatype to store a file in oracle database
- Performance Issue when substr used in where clause
- Oracle Forms Problem in virtual box using ubuntu
- datediff
- Dynamic SQL in PL/SQL, DBMS problem
- how to insert values into a table
- how to display only those data which is specified in a given year
- How to update a specific column using trigger
- Oracle express 11g? Constraints
- Writing to Windows using Oracle concurrent process to a defined mount point on Window
- Oracle BI Publisher
- to solve trigger
- How to Exclude Sat and sun in APEX 4.1
- How to write the trigger to update 2 tables
- How to find the difference between two timestamp column
- Nested statements using Update
- i want to export data from oracle to excel using the command line
- Maximum open cursor
- Table Partitioning over 2 computers
- How to update the table during the runtime
- Search query by date
- retrieve a value from database
- How to Get the Column Value in Newline in Oracle 10g
- Connecting to Oracle in Unix shell
- how to check item sold ? date
- connection failure
- Inserting a column from two concatenated columns
- How to copy the tables of ORACLE 10g from my home pc to other system?
- Oracle 10g and 11i SQL command difference
- I have to find the primary key of a table in oracle
- error conectivity problem
- database
- Internal and Fatal Plsql Error in Oracle Report 10g
- Primary key and foreign constraint in oracle
- how To check table exists in Oracle?..
- how to update multiple columns of a table from another table?.
- How to insert and update in single query?..
- Oracle .dmp import problem
- Oracle Rows to Column Transformation
- meaning
- Create new Database Link Problem
- Need Function help
- How to change the table name during the runtime
- indexing varchar2(200)
- Oracle 10g client - Please help
- How to wrap a package
- how to change directory in oracle
- How to select whole column from SQL table
- How to execute stored procedure in oracle with cursor as a out parameter
- command that will tell the table size and available space
- about database
- Max of three different tables
- java using plsql
- I really need help with this subquery
- synonyms
- how to create table in procedure?..
- Calculating percentages
- How to get username and password for oracle 9i database?
- How to generate the report from oracle forms
- COUNT AND display and Column Name in ORACLE 10G
- how to get schema corresponding database name
- regular expressions in oracle
- storing images
- Highest value from a column
- Oracle RDB ODBC with .net web service
- ocj4 configuration issue
- Toad for oracle - error
- Problem with ALL_CONSTRAINTS
- ora00932 inconsistent data types: expected date got number when i update a date
- oracle,sql
- oracal
- Hot to get most used table in databse
- Script to delete rows in a table and partition of the table
- Script to delete rows from a table
- Question about query
- upload a file by oracle store procedure using utl_file package.
- how to call a function in oracle
- how to make oracle table names case insensitive
- plsql procedure
- Every 5 minutes query
- ORA-04071 error
- Connection Error to the database
- how to find column detials
- Getting Syntax Error When trying to use input variables to populate where clause
- please resolve this problem i am getting this error after running this procedure
- Help! Sqlplus error: PLS-00201: The identifier 'ALTA_PREU' must be declared
- what is the use of decode function in sql and how to use decode function
- how to call select statement in trigger
- Can I add another PK to the existed table?
- Passing Object type to a remote database procedure input
- how to fetch all relational tables from oracle ?
- Case Query
- Accessing two Databases using a single SQL query
- EXP-00056 ORACLE error 12154 encountered
- Function not returning values ( Sometimes??)
- Using Reg Ex
- missing set keyword
- missing set keyword
- Help with duplicate rows due to date/time in query
- Ora-04092
- Time datatype in Oracle Database
- Creating a schema
- Right parenthesis error
- How to display chinese characters in output file of a concurrent program in oracle ?
- defineColumnType
- Difference between HAVING and WHERE?
- Enable Parallel Execution
- Automatic Refresh Materialized View
- Need help in understanding the query technically
- Time and date in sql
- Oracle Time Conversion from EST to UTC and Back is 1 hour off?
- performance is poor in this query where this table has got millions of records
- Integrate oracle forms 11g with JSP
- How can I make virtual table whitout create privilege?
- oracle 11g database link
- how to image browsing in form from oracle database?
- how to get dates of all saturdays in 2011
- Oracle system trigger fired twice on drop table
- Microsoft ODBC of oracle error in windows xp
- tns:could not resolve service name
- Ora-02291 error when inserting data
- PL/SQL return count for all dates
- How to limit oracle table search?
- How to export data from oracle to excel and other databases
- where should i put update with this count function?
- edit the varchar in the columns
- How can I insert the system date into a table?
- Ora 00933 error
- jre missing in scratch path
- Order in left and right joins
- Query to display column name and value
- Sum two columns of different tables
- Database error: database not open
- directory service error
- Help with SQL script
- SQL Connection Refused
- Accessing oracle in a unix platform
- Oracle 10 Query by Unix Sysdate
- usage of CASE statement
- query from oracle
- Please advise a better index
- SELECT with OFFSET oracle
- Issue in enable/disable the value set in concurrent program
- how to encrypt the complete table
- ora-01033 error in oracle 7 server release 7.1.6.2.0 on unix
- ora-01033 oracle initialisation or shutdown in progress
- how can i convert float to number in my following prog. as i m getting wrong o/p.
- Error: imp-00002:failed to open the xyz.dmp for read
- How to exchange a string in oracle sql?
- Insert error: ORA-00936: missing expression
- Materialized view creation taking too long
- How to play Gif file in oracle form 6i/
- How to get 1st two characters and last two characters from a column in table?
- Store procedure question...
- How to improve performance on query
- ORA-01219: database not open
- Regarding Object ID in oracle
- How to import the dump file into oracle 9i
- How can I monitor the execution result of a stored procedure at run time?
- what is the input required here?(after running)and what's the right query?
- Oracle certification: complete ocp in 10g
- Explanation of how to implement oracle grid computing
- Migrate DB from UNIX to Windows
- Oracle SQL Query> Collect certian time intervatal data
- Internal error has occurred issue
- ORA 1033 Oracle intilization or shutdown in progress
- finding the emp info
- Aggregating Related Text Data
- How to call store procedure from DB trigger in oracle 10g?
- Delay Time when executing sql command
- How efficient are queries that use DISTINCT (vs filtering data yourself)
- why we cannot use decode in pl sql blocks ?
- Why Can't I Check Straightaway That at least One Row Matches My Criteria in a Query?
- how to set default value for column of new created table from select statement in 11g
- missing right parenthesis when creating table
- ORA-12541: TNS:no listener
- Toad Errors....???
- Merging result from three queries
- Oracle certification question
- How to clear IOException ?
- I am using Oracle 9i as backend Then how we can create .dmp file to my project?
- how to alter back this table to read write?
- How to Evaluate Pairs of Records?
- how to link primary and forgein keys in sql for oracle
- How to call Sql * Loader Program Without passing Database user name and PAssword
- Call to undefined function oci_connect() error.
- I am creating the following trigger. It seems to be working but return error messages
- Increase the length of the table_name cloumn in USER_TAB_COLUMNS table
- if loop is not woking pls clarify
- oracle services are getting started automatically on rebooting....
- Materialized view is not getting refreshed as expected.
- How to display one column values to multiple column values?
- How to convert from long to varchar2?
- error Object reference not set to an instance of an object..plz help
- ERROR: JRE missing in scratch path
- Unable select all columns from 2 tables using Union all...
- Sql query having problem
- How to import a database exported from an oracle 7 into 10g?
- How to represent HEX in Oracle?
- How to convert data with different charsets into other databases?
- Having problem with PRO* compiler
- How to create macros for Oracle?
- I am not able to run Multimedia Database program in oracle9i
- show column heading as table value in select statement
- Hi...question regarding a script for expdp
- How to update 1st record in a set of records with unique constrains?
- summing of child level display the parent level
- how to turn off auditing in oracle
- SQL Interpolation query
- Use of ASC & DESC indexes
- Round(45.923, -1)
- How to get the encoding of an oracle database?
- How to delete an Unknow table name?
- How to evaluate and get results of formula stored in column?
- How to execute a function with one out parameter and 2 in parameters & out parameter?
- Can we pass multiple arguments in 'nvl' function ?
- How to use a case statement in where clause with an 'in' operator?
- How to access a Result Set?
- How to join 2 tables A and B one field(x) is common in both?
- How is data captured through fingerprint scan & stored?
- How to load data from/to utl file?
- How to retrive data without table name?
- How to convert this MsSQL statement into Oracle?
- What are some sources to learn more about Joins?
- How to change the character set of a database?
- Why we are using to_number function in this query?
- How to tune the query?
- How to rename each column values with distinct prime number?
- How many varchar2 datatypes present in a table?
- Why are spfile contents are readable in text format?
- How to hide a main report header when a subreport is open In Crystal Reports?
- Why the query returns results having hire_date greater than given date?
- How to import old version dmp file into 10g express edition?
- How can I declare a ref cursor for unknown table?
- How to connect to my Oracle DB through VPN Connection?
- How to update column (ISO_WEEK) in TOAD Oracle?
- How to call report from Oracle form 10g?
- How to fix "Problems occcured with jrew.exe" error during installation on Vista?
- Help with an Oracle Error...
- Parametrized stored procedue on SQL prompt
- How to fix error on procedure creation?
- How to get the form_id or function_id or function_name?
- How to create a new Database from Toad Oracle?
- Can one user accesses two tablespaces?
- How to create synonym and privileges?
- How to import data's into oracle having existing values?
- Invalid Cursor Error while inserting data in a table.
- what is the difference b/w VARRAY,RecordType,table type and nested tables data type?
- TNS-12560: TNS: protocol adapter error TNS-00515: Connect failed because target host
- Trouble with SQL join on update statement
- Can I use my software developed by oracle form builder in Linux?
- How to select same column twice with different condition?
- How to call to procedure without Cursor giving me a Statement Handle Error?
- SQL PLUS FORM OUTPUT - how to do it
- How to update a table setting date as '11/30/2010 12:30:01 PM' in particular records?
- Why is package taking more time than expected?
- How to Close One Window from another window in oracle form6i?
- Crystal Reports: query prompts (date) and dynamic parameters
- Question on Creating Placeholder Rows
- How To Call .Swf file into oracle form6i?
- Reg Oracle Article/Content writing
- How to solve stock calculation Error?
- errors PLS-00302: component 'CALLS' must be declared How to solve this
- How to drop primary key referenced to other foreign key?
- Set constraint on column type?
- Why does assigning a default value cause invalid identifier error?
- Oracle Report 6i not print on Receipt Printer (CZERLOP)
- How to fetch data from oracle in xml format?
- Sql-2113 error
- Display all columns of a table using group by
- How do i avoid re-minising the value through a button when i click ?
- Query for specific duplicated values
- How to run oracle developer 6i report from client machine?
- How to calculate Stock information?
- How to restore Rman backup from unix to windows?
- How to use "rownum"
- How to run a LIKE query with multiple values?
- How to make report with help of D2k in oracle?
- How to transfer tables from one oracle to another oracle
- table contains name column i want to display senthil at first remaining in order ?
- Create sequence <seq_name>
- can i create dynamic menu in oracle forms 6i .
- ORA-01732: data manipulation operation not legal on this view
- Calculate leap year days between two dates
- I got error like "ORA-00971: missing SET keyword" why?
- how to retrieve data which have been overriden in oracle database?
- how to get a particular column alone in select statement?
- How to retrieve data from oracle database to Visual Studio -2005 asp.net grid view?
- none of the passwords are working in my PC,someone please helpme
- ORA-06572: Function ADD_NUM1 has out arguments
- seventh max user-id(NP09_USR_ID) from the table(NNPD00.NP09_PRFL_USR)
- The query below keeps yielding "SQL command not properly ended" when run. Why?
- PLS-00306 wrong number or types of arguments in call to
- How to merge rows from a Virtual Table, based on a foreign key
- How to need to access the DB1 procedure through db link from DB2
- What is the maximum query length in Oracle?
- Error. ORA 12535: TNS operation time out. How can i resolve it?
- looking for data of the market share of SGBD's
- How to display the names only with character '_' in oracle?
- Update and or insert
- retrieve commands from committed database
- How to view a created table query in oracle 10g
- materialized views
- How to reject the data when particular column value is null in sql loader?
- Integrity Constraint error ORA-02291 even if the parent key exists.
- Application Express and Passing JAVA URLs with Bing Variables
- How to fix oracle 8i on Win XP installation problem
- How to import a dump file into Oracle on linux?
- how do i fix the error ORA-01401: inserted value too large for column in PL/SQL
- What is the issue when a check is cut but doesn't hit the GL cash/AP?
- How to load an audio file in oracle form6i
- Can Oracle forms 11g connect to DB2 or SQL Server?
- How do I remove CHAR(10) and Char(13) from a table column
- Trigger to restrict alter session
- How to fix error on create table
- how to skip the bad record and continue with loading in SQL Loader?
- looking for making project of forms(oracle9i)
- How to solve ORA-02291: integrity constraint error
- how to take tables from oracle database
- How to get the last saturday of a month?
- Select statement within the select statment
- SELECT CONVERT(SMALLDATETIME,GETDATE(),20) ...i want the date to be 2010-02-02
- Validate pattern of field in combination of char & int
- Error while creating DBLINK Oracle - SQL Server
- Error (ORA-00904) after i run for this command
- some of my data is getting overwritten by the update query i want to save my old data
- Query taking too long to finish
- Date and Time comparison
- Calculate mode from series of date of birth
- How can I find out the min/max value form multiple tables?
- Join tables with empty records
- Comparing and updating values in same table but in different rows
- i inherited an windows oracle box. when i try to login to database, i get 12560, etc
- how can i update a table which is self joined?
- Stored function
- Create a stored procedure
- Repeat AND statement, but remember first result?
- how can i solve the error ora-03113 ?
- what is node cluster architecture
- Comma Separated to Rows
- Having problems to build a proper update in oracle10g
- SQL> startup force pfile="/oracle/orcl_11g/product/11.2.0/dbhome_1/dbs/initorcl"; ORA
- How to get count of frequently accessed record?
- Migrating data from Access 2000 to oracle 9i
- Run Same Query on tables in Schema
- how to execute stored procedure in SQuirrel
- how to solve this errors
- my view is slow
- trigger that can audit sql querys executed by the user in oracle
- insatlling database error?
- Pass Variable into Query
- trigger that can track whether that user has done any select,insert,delete,update sta
- is there any trigger that can manage to trac the details of a user's dml activity?
- What is recommended to set the page file size on Windows 2003 server (64bit)
- sql query to display half employee name in upper case & other half in lower case
- How to convert number to words in oracle form 6i?
- Which is better? Oracle DBA or Maintenence project in AS/400?
- MS ODBC for Oracle Driver 6.00.6001.18
- Problem in on delete no action why?