oracle
when i create a table in oracle10g then what is the path where my table is stored and how can i move that table to another system

Answer Question   |  May 28, 2012  8:01 AM
Oracle

Query from Oracle forms to Excel sheet
I had a matrix report made in oracle reports builder 11g. This report was called from a button in my form. now, I want to open an excel file when that button is pressed and show the data exactly in the format as it was shown previously in the report which was made using report [...]

Answer Question   |  May 25, 2012  6:04 AM
Microsoft Excel, Oracle 11g

How to view Crystal Reports in Internet Explorer?
when i deploy my asp.net website on windows 7 with oracle 11g database in backend.I am using sap crystal report version 13.0.2000.0 It gives error as Unsupported Operation. A document processed by the JRC engine cannot be opened in the C++ stack.Description: An unhandled exception occurred during the execution of the current web request. Please [...]

Answer Question   |  May 24, 2012  6:01 AM
Crystal Reports, Oracle 11g

Materialized Views
I have a materialized view LOG on an Oracle 11 database and a materialized view on an Oracle 10 database. The LOG file does not recognize that the MV on Oracle 10 needs it for refreshing. The same setup on 10g to 10g works fine. Any ideas?

Answer Question   |  May 24, 2012  1:27 PM
Oracle 10g, Oracle 11g

Using select statement in an update query of Oracle SQL
how to update an entire column of an table by an subquery in an update statement.and that subquery is returning multiple rows

Answer Question   |  May 22, 2012  11:28 AM
Oracle Query, Oracle SQL

What Oracle 10g software is needed to download and install on the system for Running JDBC Programs on the system.
Sir what, Oracle 10g Software  is needed to be downloaded from the Internet, for installing it into the system for compiling JDBC java programs. Sir please tell me the reply sir, for the running JDBC java programs.

Answer Question   |  May 22, 2012  1:30 PM
JDBC, Oracle 10g

How to have sub-columns in a column of a matrix report?
Hi All, Need to have sub-columns in a column of a matrix report. The structure is as follows:                 Lease          Rental               MTD | YTD |     MTD |  YTD Segment           |     |         |                               |                               |             My doubt is asto how to have the structure of MTD and YTD (sub-columns) within Lease and Rental (column). [...]

Answer Question   |  May 18, 2012  5:57 AM
Oracle, Oracle Reports

Oracle IR ISO error
Hi,   I am trying to test the IR ISO (Internal Requisition and Internal sales Order) process. But when I run the ‘Create Intercompany AP Invoices’ in the requesting org, the record fails with following error   “APP-INV-05708: Vendor and/or vendor site information not found  Returned warning from extra function”   Any ideas?

Answer Question   |  May 14, 2012  4:13 PM
Oracle Apps 11i, Oracle error messages

Forms Compile question
Is there a difference between compiling a form through the developer client on my windows machine and compiling it on a unix server. I compiled it on my windows developer client and ftp’d it to the unix server and when I try and run it through EBS, it says it is not a valid forms [...]

Answer Question   |  May 18, 2012  11:01 PM
EBS, Oracle Forms 6i, Unix Servers

Query Manager Report Forms
Is there a simple way to print a cover page using Query Manager like there is in regular query/400

Answer Question   |  May 9, 2012  7:15 PM
AS/400, Query Manager

Failed Link to External Data
I was able to link to all external data in ODBC Oracle database but one table that has more than 32 indexes. How can I link to this table? Please advise. Thanks

Answer Question   |  April 26, 2012  2:52 AM
ODBC Oracle, Oracle Database

Unable to print through oracle application on windows7 64 bits
when I try to print through Oracle application using OS windows 7 64 bits, it gives working on bottomn bar and nothing print

Answer Question   |  April 23, 2012  10:28 AM
Oracle, Windows 7 64-bit

error in grid xml: each dimension must be used once and only once
Hello, I’ve got problem on one workstation with installed Hyperion version 9.2.1.0.0.002 Add-in for Excel. When we run Refresh of sheet full of HsGetValue formulas we can’t get data. It shows #NAZEV? instead numbers and popups Error window ‘Hyperion Smartview for Office’ with message “Error in grid xml: each dimension must be used once and [...]

Answer Question   |  April 19, 2012  1:52 PM
Hyperion, Microsoft Excel, XML

convert report to excel without convater
Is it possible to convert a 10g generated report to excel without excel convater?  

Answer Question   |  April 19, 2012  9:13 AM
Microsoft Excel, Oracle 10g

How to redirect to different page after login in APEX 4.1
Dear All, Here my Requirement is,When the users login  the username = Raj should be redirected to page 1 and username = vikram should be redirected to page 2 when they entered their username and password and pressed login button. How can I do this? please give some suggestion. Thank you. regards, Gurujothi [Blockquote style="display: [...]

Answer Question   |  April 23, 2012  11:05 AM
Oracle Apex, Oracle Apex 4.1

i forgotten my user name and password of oracle 10g express edition.
i m using oracle 10g express edition i forgotten my username and password so please suggest me any idea to recover the username and password or tel any other possibilites to reset the username and password.

Answer Question   |  April 4, 2012  7:46 AM
Oracle 10g Express, Windows 7 Ultimate

Grouping of a/c.
I am using Oracle and through SQL Worksheet i want to get information as followes.  My table Name is bilmst and field 1 enterdate and field 2 a/c. no  I want to group no of a/cs fininacial year wise. My financial year starts from 01-jul to 30-jun for example 2005-06 means from 01-jul-05 to 30- [...]

Answer Question   |  April 6, 2012  6:55 AM
Oracle, SQL Worksheet

Creating Views in MYSQL via Sysdate
Hello Guys, I can create simple views for MYSQL Database tables but I am unsure on how to create a view for the following requirement: I want to create a view which restricts staff user access to a specific table between working hours of 13:00 – 14:00. I have been told that this can be [...]

Answer Question   |  March 27, 2012  8:58 PM
MySQL, MySQL Database, Oracle

ORA-03127: no new operations allowed until the active operation ends
Good Morning, Since oracle 10g and even after upgrading to oracle 11g , e keep getting an oracle error: ORA-03127: no new operations allowed until the active operation ends, in relation to a diferent db table, every time the error occurs. including db tables that have maintenunce every day. can anyone tell me why this error [...]

Answer Question   |  March 22, 2012  12:13 PM
ORA-03127, Oracle 11g, Oracle Reports 10g

select command
i would like to collect informations from oracle date table through select query financial year wise my financial year starts from01 jul and ends on 30 jun. my task is to collect total number of entries from last ten financial years wise.

Answer Question   |  March 22, 2012  7:49 AM
Oracle, Oracle commands, Oracle Table