Forms Compile question
Did you change to binary when ftp? By default, is ASCII.

View Answer   |  May 18, 2012  1:43 AM
EBS, Oracle Forms 6i, Unix Servers

DMAAI SET-UP OF JD EDWARDS
Hi deeepak, DMAAi stands or Distribution Manufacturing Automatic Accounting Instructions. These need to be setup before making any transactions.In the Fast path type DMAAI and setup the instructions which you need to. Whenever you make a transactions you need to have defined DMAAI like 4122 is for inventory.

View Answer   |  May 15, 2012  11:22 AM
JD Edwards (JDE), JDE, JDE_JK

conversion of SQL Server 2008 stored procedure to Oracle 10g
There are lots of differences. For example there is no VARCHAR data type in Oracle, you’ll have to use VARCHAR2 instead. Using user defined functions is basically the same. The big difference is that SQL Server using T/SQL and Oracle uses PL/SQL as the programming language. All the code within the procedure will need to [...]

View Answer   |  May 15, 2012  3:20 AM
Oracle 10g, SQL Server 2008, SQL stored procedures

jrew.exe has stopped working while installing oracle 9i in windows 7 ulitemate
I have this problem too and as I have search in the google the windows 7 doen not support oracle 9i and it can support uper than 10g.

View Answer   |  May 7, 2012  9:22 AM
Oracle 9i, Windows 7 installation, Windows 7 Ultimate

How to redirect to different page after login in APEX 4.1
<a href=”http://www.ytfoam.com”>Polycarbonate PC Sheet</a>

View Answer   |  April 23, 2012  8:17 AM
Oracle Apex, Oracle Apex 4.1

Unable to print through oracle application on windows7 64 bits
<a href=”http://www.traffic-products.net/product/product_30_64_1.html”>Traffic cone </a>

View Answer   |  April 23, 2012  8:09 AM
Oracle, Windows 7 64-bit

Free online practice exercises on SQL/Oracle
A Gentle Introduction to SQL http://sqlzoo.net/ SQLCourse – Interactive Online SQL Training for Beginners http://sqlcourse.com/ SQLCourse2 – Advanced Online SQL Training http://sqlcourse2.com/ SQL Exercises – Online SQL (DML) Training <a href=”http://www.sql-ex.ru/”>www.sql-ex.ru/</a> w3schools you want online free test check this: it is more usefull………… www.wiziq.com/tests/sql ///////////////////////////////////// www.sqlzoo.net //////////////////////////////////////

View Answer   |  April 17, 2013  3:56 AM
MySQL, Oracle, SQL Server

i forgotten my user name and password of oracle 10g express edition.
Answer by Shiva3322: may this could suggest to ur answer <a href=”http://www.dba-oracle.com/t_retrieve_oracle_passwords.htm”>http://www.dba-oracle.com/t_retrieve_oracle_passwords.htm</a>

View Answer   |  April 4, 2012  9:01 PM
Oracle 10g Express, Windows 7 Ultimate

Enterprise One End User Training
I think you must consult the professionals of the concerned field. They may be helpful to you to share vast information regarding it. <a href=”http://www.pioneertraining.org/res-course-providercea-approved-real-estate-course”>RES Course Provider</a> | <a href=”http://www.pioneertraining.org/”>course in real estate</a>

View Answer   |  April 4, 2012  11:16 AM
Enterprise One, JD Edwards (JDE), JDE, One World Web

Grouping of a/c.
235235235, you have asked this same question 3 times. If you continue doing this, your questions will probably be deleted. 3 queries that produce the results you want were provided here: <a href=”http://itknowledgeexchange.techtarget.com/itanswers/sql-wks-select-command/”>SQL WKS SELECT COMMAND</a> If you don’t understand them, or want to provide any feedback, <b>please </b>continue the discussion there.

View Answer   |  March 28, 2012  5:26 PM
Oracle, SQL Worksheet

Excel File from PL/SQL Procedure
ff

View Answer   |  March 26, 2012  8:55 AM
excel, Oracle 10i, Oracle PL/SQL, PL/SQL

How to connect Visual Basic 6 to Oracle 11g
You could do it this way: First, you need to install Oracle Client software and make sure you are able to connect to the database (test the connection from SQL*Plus) Then the VB code is pretty simple. This is an example using ADO: Dim C As New ADODB.Connection Dim Rec As New ADODB.Recordset Dim SQL [...]

View Answer   |  May 10, 2013  12:18 PM
Database programming, Oracle 11g, Oracle connectivity, VB 6, Visual Basic, Visual Basic 6

select command
<i>Answer from CompleteITProfessional :</i> Depending on how your data is structured, you’ll need a query similar to this: SELECT * FROM tablename WHERE datefield > SYSDATE – (365 * 10) If you’re after more information on the financial years, you may need to convert the dates to financial years and go back 10 in the [...]

View Answer   |  March 21, 2012  9:27 PM
Oracle, Oracle commands, Oracle Table

migrate from oracle 9 to oracle 11
You can migrate from Oracle9i to Oracle11g and skip over Oacle10g in the process. While you could use the database upgrade assistant/utility, I would recommend creating a new, clean Oracle11g database and upgrade/migrate by performing an export from your Oracle9i database and import into your Oracle11g database to take full advantage of many new architectural [...]

View Answer   |  March 20, 2012  12:33 AM
Oracle 11, Oracle 9, Oracle migration

how to transfer oracle table data to .csv file by using pl/sql coding
You would have to create a cursor to read the data you want to export, and use the <a href=”http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/u_file.htm”>UTL_FILE package</a> to create the file and write the data to it. Here is another link with useful information and some examples: <a href=”http://docstore.mik.ua/orelly/oracle/bipack/ch06_02.htm”>UTL_FILE: Reading and Writing Server-side Files</a>

View Answer   |  March 14, 2012  3:11 PM
.CSV files, Oracle, Oracle Table

External Table / SQL Loader
If you are still having problems with the SQL loader, perhaps its time to switch to a commercial SQL loader. They should have less problems. Maybe it would be more compatible with your client. Kathy – <a href=”http://www.cartridgeshop.co.uk”>compatible cartridges</a>

View Answer   |  March 14, 2012  1:28 AM
PL/SQL, SQL Loader, SQL Server

Compressing/Compacting Tablespace and Data Files
Assuming that you are specifically asking how to shrink a tablespace and its related datafile(s) due to over-allocation/under-utilization, then you can run the command “alter database datafile ‘/directory-name/filename.dbf resize ???M;” where “directory-name” is the directory name/filesystem path that the datafile resides in, “filename.dbf” is the name of the datafile, and “???M” or “???G” is the [...]

View Answer   |  March 5, 2012  9:59 PM
Oracle, Oracle 10g

Calculate time difference with Oracle 9i
To calculate the difference you just need to perform a subtraction, for example: sysdate – some_date_column The result will be given in days, so you have to convert it as needed. To send the e-mail, you could use the UTL_SMTP database package, or write some forms code to use outlook to send it. <a href=”http://www.dba-oracle.com/t_utl_smtp_utility.htm”>Oracle [...]

View Answer   |  February 29, 2012  11:12 PM
Oracle 9i, Oracle development, Oracle Forms 6i, Oracle triggers

How to Migrate Oracle 10g forms in Oracle 11g
According to the <a href=”http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/toc.htm”>11g upgrade guide</a>: “<b>Overview of Upgrading Applications:</b> You are not required to modify existing applications that do not use features available in Oracle Database 11g Release 1 (11.1). Existing applications running against a new Oracle Database 11g Release 1 (11.1) database function the same as they did in prior releases and [...]

View Answer   |  February 22, 2012  9:12 PM
Oracle 10g forms, Oracle 11g, Oracle Forms

Oracle
Hello I am pretty,prettyshina74@yahoo.com I guess you will not surprise to receive my mail? i saw your profile and it sound well.I will like us to exchange good relationship.I am pretty by name,No kid and never marry.from here you can contact me at this email address(prettyshina74@yahoo.com )so that i can send you my pictures and [...]

View Answer   |  February 6, 2012  6:15 PM
Oracle 6i, Oracle 6i Reports Builder