Can I run Seconds on an Alert in Oracle Forms 6i
I don’t think that’s possible using an ALERT in forms 6i, however, you could create your own alert (a new window with a couple of display items and the necessary buttons), then when you call this window you start a timer (1000 msecs), and in the Form’s WHEN-TIMER-EXPIRED trigger you set the current time to [...]

View Answer   |  April 22, 2009  6:18 PM
Oracle development, Oracle Forms 6i, Time On Alerts in Oracle Forms 6i

Multiple Tables to Bulk Import .sql script
I have been using the Lite version of Navicat Oracle for a couple of weeks now which compared it to Oracle’s SQL Developer and also Oracle Maestro. I have found Navicat to open quicker (especially compared to SQL Developer… java runs soooo slow!). I also find the interface/gui to be less cluttered and easier to [...]

View Answer   |  April 22, 2009  4:03 AM
Oracle, Oracle import/export, Oracle Table Export, SQL, Sql Script, TOAD

Generating multiple pdf files using oracle report builder
I’m not sure whether it is possible to split a report output in more than one file, but I guess the answer is no. I think you could implement some kind of pagination to split the report in many files. You could do it by modifying the report’s query to recieve the record numbers to [...]

View Answer   |  April 21, 2009  1:05 AM
Oracle 10g, Oracle Reports, Oracle Reports 10g

How number of processors correlated to Oracle database size
I don’t know of such a guideline, and I don’t think you should determine the number of processors based on the database size. I would look for metrics like transactions/operations per second, or something like that. A small database could demand more CPU than a much bigger one, depending on the amount of operations it [...]

View Answer   |  April 20, 2009  10:13 PM
Oracle on Linux, Oracle performance, Unix Server sizing, Unix Servers

Database
You could do it by using the Database Configuration Assistant (DBCA), or using the CREATE DATABASE statement. Have a look at the following document for further details. <a href=”http://www.sc.ehu.es/siwebso/KZCC/Oracle_10g_Documentacion/server.101/b10739/create.htm”>Creating an Oracle Database</a>

View Answer   |  April 20, 2009  7:27 PM
Oracle Database, Oracle database administration

Does something similar to Oracle’s optimizer hints exist in SQL Server ?
Yes to some extent. You can use locking hints to change the way that SQL Server locks the tables. You can use execution plan hints to change the way that SQL Accesses the table by forcing it to use a specific index. If you want to you can statically set an execution plan into the [...]

View Answer   |  April 19, 2009  8:06 AM
Microsoft SQL Server, Optimizer, Oracle, SQL, SQL Server, SQL tuning

automatic go next field without enter keyboard key oracle form 6i
Hi Kutub Did you test “When Validate Item” trigger ? in this case you can insert your code, such az “first_record” or “next_record” or selecting which record you want to show. I hope it helps.

View Answer   |  April 18, 2009  11:24 AM
Oracle 6i, Oracle development

Dear Carlos De Leon… Kindly help me out
For others to understand: This question, is a followup of <a href=”http://itknowledgeexchange.techtarget.com/itanswers/how-to-save-the-value-of-a-parameter-so-that-next-time-when-report-runs-it-uses-the-last-given-value/”>this one</a>. How are you running the report ? Are you calling it from a Forms application ?

View Answer   |  April 17, 2009  8:12 PM
Carlos De Leon, Oracle development

log sql queries?
Try this: <pre>SELECT username users, sql_text, Executions, loads, users_executing FROM sys.v_$sqlarea a, dba_users b WHERE a.parsing_user_id = b.user_id AND b.username LIKE UPPER(‘%&user_name%’);</pre>

View Answer   |  April 17, 2009  7:55 PM
Oracle 9i, SQL queries, SQL Server logs

Oracle Form (fmx) connect to database through Internet
6i uses client-server technology … It is not native web-browser based … Move to the current version which is internet (browser) enabled … This does require installing the Oracle application server

View Answer   |  April 17, 2009  7:19 AM
Oracle 10g, Oracle connectivity, Oracle Forms 6i

A program is trying to automatically send email on your behalf (Outlook via Oracle Developer 6i)
Hi you need to lower the security settings in Outlook in order to allow this. ——— This is from <a href=”http://support.microsoft.com/kb/263084″>a Microsoft Support article</a>: “<b>Cause</b>: When you apply the Microsoft Outlook E-mail Security Update, the Outlook E-mail Security Update provides additional levels of protection against malicious e-mail messages. The Outlook E-mail Security Update changes the [...]

View Answer   |  April 17, 2009  12:36 AM
Microsoft Outlook, Oracle Developer 6i, Oracle development, Outlook

Oracle 6i How to Save the Value of a Parameter so that next time when report runs it uses the last given Value
There is no way to ‘save’ a value in the report between executions. You should store the value of that paramter somewhere in the database, so you can read it the next time the user runs the report.

View Answer   |  April 16, 2009  1:58 PM
Oracle 6i, Oracle Reports 6i

calling reports in pl/sql code
You need to send the DESTYPE,DESFORMAT and DESNAME parameters to the report. Something like this: Add_Parameter(MyParamList,’DESTYPE’,TEXT_PARAMETER,’FILE’); Add_Parameter(MyParamList,’DESFORMAT’,TEXT_PARAMETER,’PDF’); Add_Parameter(MyParamList,’DESNAME’,TEXT_PARAMETER,’C:YOUR_OUTPUT_FILE.PDF’); And then call the RUN_REPORT_OBJECT or RUN_PRODUCT built-in as you usualy do. This will generate the file, but it wont be opened automatically.

View Answer   |  April 16, 2009  12:26 AM
Oracle 6i, Oracle Reports, Oracle Reports 6i, PL/SQL, PL/SQL procedure

How To execute procedure
I think you are getting the last row only, not the first, because you are overwriting val1 and val2 on each loop iteration. On the other hand, you could return a REF CURSOR if the data you want to return proceeds from a cursor (i.e. a query), but in this case, it comes from many [...]

View Answer   |  April 15, 2009  10:17 PM
Oracle SQL, Oracle stored procedures, SYS_REFCURSOR

Label in oracle
Are you talking about Oracle Label Security ? Could you please be a little more specific ?

View Answer   |  April 15, 2009  2:26 PM
Oracle Local Labels, Oracle Public Labels

oracle 10g release2 forms builder problem for windows
Could you please provide more information ? The browser closes itself when Forms Builder runs, or when you run a form from Forms Builder ? If the latter, does that happen with any form ? What operating system and version of internet explorer are you using ?

View Answer   |  April 15, 2009  1:00 PM
Oracle 10g, Oracle Form Builder, Oracle Forms, Oracle Forms & Reports Developer 10g

HOW TO SAVE DATA FAST
You could try spooling the query’s output to a file in SQL*Plus, but you will need to make it ‘comma separated’. This is an example: <pre>set pagesize 20000; spool c:your_file.csv; SELECT circle_name||’,'||cluster_name||’,'||rsnnumber||’,'||mdnnumber||’,'||hs_rsnnumber||’,'||otafdate||’,'|| (case when old_mdn is null then ‘INACTIVE’ else ‘ACTIVE’ end) FROM GSK_INVENTORYDETAILS WHERE OTAFDATE>=’1-MAR-2009′ AND OTAFDATE<=’31-MAR-2009′ AND GSKPLAN LIKE ‘PREPAID%’ AND CIRCLE_NAME=’UTTAR PRADESH [...]

View Answer   |  April 15, 2009  12:14 AM
Oracle Database, Oracle Output Via SQL, Oracle SQL

Variation in space occupied in same TABLSPACE by equally populated tables.
Hi, Have you tried to create an empty T2 table based on T1? create table t2 as select * from t1 where 1 = 2; If T2 is still of a signficant size, then you need to explore your default table settings. Devski777

View Answer   |  April 14, 2009  4:25 PM
Oracle 10g, Oracle Tablespaces

Oracle SQL question
Oracle does indeed have if-then-else constructs as well as many other programmatic functions available in PL/SQL. I suggest you get some documentation so that you can learn allthe available options you have as well as correct syntax, etc.

View Answer   |  April 13, 2009  6:27 PM
CASE statement, IF THEN statement, IIF statement, Oracle developers, Oracle development, Oracle SQL, SQL

Can I install Developer 6i and make/run forms and reports on Windows Vista?
you can install 6i on vista it will work fine as your previous windows i already working on vista with 6i

View Answer   |  April 11, 2009  7:47 AM
Oracle Developer 6i, Oracle Forms, Oracle Forms 6i, Oracle Reports, Vista, Windows Vista