How to connect Oracle 8i and Oracle forms
You have to modify your TNSNAMES.ORA file in your Developer’s oracle home. If you can connect from your database installation SQL*Plus, you just need to copy the contents of your database’s oracle home tnsnames file to the Developer’s oracle home one.

View Answer   |  September 21, 2010  2:05 PM
Oracle, Oracle 8i, Oracle 8i Installation, Oracle DBA, Oracle Forms, Windows XP

Oracle 10g XE can be installed on Win 7 home basic 64 Bit
Yes, of course, u may download the Oracle 10g XE for 64 bit version.

View Answer   |  September 18, 2010  6:56 AM
Oracle 10g, Windows 7, Windows 7 64-bit, Windows 7 Home Basic, Windows 7 in 2010

Webpage calling from Oracle Forms 6i
You could use the DDE package, to call the browser sending the url as a parameter. Here's an example:declare nExplorer pls_integer; vCommand varchar2(200) := 'path/to/your/browser' || ' ' || 'www.yourpage.com'; Begin nExplorer := dde.app_begin(vCommand,dde.app_mode_normal); end;

View Answer   |  April 24, 2013  6:49 PM
Oracle developers, Oracle development, Oracle Forms, Oracle Forms 6i

Installed oracle 10g in windows xp but cannot connect to database
Which Oracle 10G Server or Client ? You couldn’t mention.

View Answer   |  September 6, 2010  8:42 AM
Oracle, Oracle connection error, Oracle connectivity, Oracle Database, Oracle Database 10g, Windows XP

system.cursor_record meaning in Oracle Forms 10g
System.cursor_record is a system variable, that represents the number of the record where the cursor is located at any given time, for example, say you have a block with 5 data records (tabular). If you click on any item of the first record, the cursor_record system variable’s value would be ’1′. If you press the [...]

View Answer   |  September 1, 2010  1:53 PM
Oracle, Oracle Application Server, Oracle Developer 2000, Oracle Forms 10g

Passing parameter to Query Manager
<i>How can I run this process without prompting for the variable?</i> You bypass prompting by supplying values for the replacement variables. In your example, you pass in a value for a replacement variable named &CUST; but the only replacement variable in your QM query is named &SELECT. You might change your STRQMQRY SETVAR() parameter to [...]

View Answer   |  September 1, 2010  1:46 AM
AS/400, CLP, CLPROGRAM, Query Manager, V5R4, V5R4M0

ora-12541; TNS No listener error
Hi Helppleaseit, Check out <a href=”http://www.orafaq.com/wiki/ORA-12541″>Oracle’s wiki page</a> for more information on error messages. Hope this helps! - Melanie

View Answer   |  August 26, 2010  3:01 PM
ORA-12541, Oracle Error Codes, Oracle error messages, Oracle errors, TNSNAMES.ora

Combination of oracle 10g database with developer 2000 on Windows XP
The older Forms release that was certified to work with Oracle database 10g r1 is Developer 6i. If it is 10g r2 even developer 6i might not work correctly. OTOH, when asking for help it is always recommended to post the complete and exact error messages (I guess the error message is not ‘orainst sorry’).

View Answer   |  August 25, 2010  1:50 PM
Oracle 10g, Oracle Database, Oracle Database 10g, Oracle Developer, Oracle Developer 2000, Oracle on Windows XP, Windows XP

date problem in oracle 10g
check for a login.sql in your ORACLE_HOME directory. Sounds like something is changing your date_format for the session.

View Answer   |  August 25, 2010  12:54 PM
Oracle 10g

Oracle Library cache
Hi Fsdfsdfsdfsdfasdfsd, Is this what you’re looking for? <a href=”http://www.dba-oracle.com/m_library_cache_hit_ratio.htm”>Oracle Library Cache Hit Ratio</a> & <a href=”http://www.cryer.co.uk/brian/oracle/tuning_tlc.htm”>Oracle how to tune the library cache</a> - Melanie

View Answer   |  August 12, 2010  3:49 PM
Oracle, Oracle administration

Migrate from Oracle forms 4.5 to Oracle forms 10g
There are several oracle partners offering this kind of work (check out the Oracle Partner web-site for Forms). The challenges of a migration are covered within the PITSS.CON knowledge-base which enables you to concentrate on the test effort of the converted Forms.

View Answer   |  July 19, 2012  2:21 PM
Oracle Forms 10g, Oracle Forms 4.5, Oracle migration, RHEL, RHEL 5

Temp table with months in Oracle
Deb4u, this question seems to be related to this one (which you posted yesterday): <a href=”http://itknowledgeexchange.techtarget.com/itanswers/to-display-not-exit-data/”>To display not exit data in oracle</a> If you want to provide more details or ask for clarification, please continue the discussion in the same thread. Also, you should specify the Oracle version you are using, since the answer to [...]

View Answer   |  August 11, 2010  1:47 PM
Oracle, Oracle Forms, Oracle Table, Oracle Tables

How to display non existent data as 0 in Oracle
Deb4u, this seems to be the same question as this one (which you posted yesterday): <a href=”http://itknowledgeexchange.techtarget.com/itanswers/to-display-not-exit-data/”>To display not exit data in oracle</a> If you want to provide more details or ask for clarification, please continue the discussion in the same thread.

View Answer   |  August 11, 2010  1:43 PM
Oracle, Oracle Database, Oracle Forms, Oracle Table

Converting FMX to FMB in Oracle 6i version
you can’t do this only use good text editor to copy ur SQl commands

View Answer   |  August 11, 2010  10:48 AM
FMB, FMX, Oracle 6i, Oracle Developer, Oracle Developer 2000

To display not exit data in oracle
You will probably need to create a table with the months of the year, and outer-join it to your main table. Or, you could use an in-line view or subquery factoring (depending on the Oracle version) to achieve the same result. Here’s an example: <pre>WITH months AS (SELECT 1 mm,’JANUARY’ month FROM dual UNION SELECT [...]

View Answer   |  August 10, 2010  5:01 PM
Oracle, Oracle commands, Oracle database design, Oracle Table

Connecting and disconnecting Oracle sessions through Oracle forms
To connect/disconnect Forms applications to/from the database, you have to use the <b>LOGON</b> and <b>LOGOUT </b>built-in procedures.

View Answer   |  August 10, 2010  3:33 PM
Oracle, Oracle administration, Oracle authentication, Oracle connectivity, Oracle Forms, Oracle User Profiles

oracle 9i it is possible we creates some files or inserting values in that particular tables?
I’m not sure to understand what you are asking, but in Oracle, the physical files used to store the data are called DATAFILEs. They could be located in any folder, but in ‘default’ installations they are inside a directory called ‘oradata’ inside the oracle home. These files can only be accessed by the DBMS. You [...]

View Answer   |  August 9, 2010  2:20 PM
Oracle 9i

ordering dates in Oracle
Here’s an option: <pre>SELECT * FROM your_table ORDER BY TO_DATE(’01′||month||year,’DDMONYYYY’);</pre> If you really want them in descending order (your example shows them in ascending order) just add the DESC keyword at the end of the query.

View Answer   |  August 9, 2010  2:05 PM
Oracle, Oracle Database, Oracle Forms, Oracle Table

Need query to retrieve data from a given date in Oracle 10g
Try something like this: <pre>SELECT TO_CHAR(entry_date,’month-yyyy’), column_x, column_y, column_z FROM your_table WHERE entrty_date >= ‘&start_date’;</pre>

View Answer   |  August 7, 2010  4:13 PM
Oracle, Oracle 10g, Oracle Data Access, Oracle Database, Oracle Query

Connecting databases in Oracle9i
sqlplus username@database name

View Answer   |  August 5, 2010  2:56 AM
Oracle 9i, Oracle Database