Dear Carlos De Leon… Kindly help me out
Hi…. Dear Carlos De Leon You have told that i have to do that by saving the value of the parameter in the database and use it later when i need that…. Can you please help me out how can i do that…. we will have to pas as much parameters as the number of [...]

Answer Question   |  April 21, 2009  6:27 AM
Carlos De Leon, Oracle development

Oracle 6i How to Save the Value of a Parameter so that next time when report runs it uses the last given Value
Dear All Hope that you all will be at the best of your health and job,,,,, I have made a report in Oracle 6i. and given the options to user so that he can show/Hide a colum on report at run time… by passing a parameter with values Show and Hide….. if the user makes [...]

Answer Question   |  April 16, 2009  8:23 AM
Oracle 6i, Oracle Reports 6i

How To execute procedure
I have procedure iven below Output of the procedure below is multiple rows but i am getting only 1st row how to use concept of SYS_REFCURSOR over here CREATE OR REPLACE procedure Vishal_PROC_sp1 (kpiid in number, val1 out varchar2, val2 OUT Number) as cursor c1 is select kpimainid,sysdate,selectstmt,clause,to_char(sysdate,’MON’) month,cautionmax,cautionmin from kpimain where kpimainid = kpiid; [...]

Answer Question   |  April 30, 2009  7:25 PM
Oracle SQL, Oracle stored procedures, SYS_REFCURSOR

Label in oracle
I have heard of local labels in oracle, do we have something called public labels?

Answer Question   |  April 15, 2009  2:05 PM
Oracle Local Labels, Oracle Public Labels

oracle 10g release2 forms builder problem for windows
when oracle form builder is running internet explorer closes itself automaticly. we tried it with mozilla firefox but we came across similar problems. Can you helps us?

Answer Question   |  November 20, 2009  12:08 PM
Oracle 10g, Oracle Form Builder, Oracle Forms, Oracle Forms & Reports Developer 10g

Variation in space occupied in same TABLSPACE by equally populated tables.
I am inserting data in table T2 from T1(INSERT INTO T2..SELECT..FROM T1..). Both tables are in same tablespace. Even though records in T2 are less than T1,size occupied by T2(12 GB) is much higher than T1(440 MB). WHat may be the reason(s)?

Answer Question   |  April 14, 2009  12:41 PM
Oracle 10g, Oracle Tablespaces

Oracle 6i runtime installation
what is runtime installation

Answer Question   |  April 13, 2009  10:27 AM
Oracle 6i, Oracle 6i runtime installation

A program is trying to automatically send email on your behalf (Outlook via Oracle Developer 6i)
whenever i am trying to send mail via outlook from oracle developer forms 6i it asked for a confirmation from user. ie:— a program is trying to automatically send email on your behalf do you want to allow this? if this is unexpected it may be virus and you should choose no I dont want [...]

Answer Question   |  May 12, 2011  9:06 AM
Microsoft Outlook, Oracle Developer 6i, Oracle development, Outlook

Oracle SQL question
I want to create a SQL script in Oracle that will run one of two possible SQL scripts based on what the user enters in the Parameter request. Since I’m unable to use IIF and If Then like I can in SQL Server, is there another way to do this? I have tried using case [...]

Answer Question   |  April 22, 2009  2:39 AM
CASE statement, IF THEN statement, IIF statement, Oracle developers, Oracle development, Oracle SQL, SQL

How to create procedure in Oracle
I WANT TO CREATE A PROCEDURE FOR DOING FOLLOWING 4 ACTIONS 1) That will first delete all data from xa and then load data from xls file (TOWN.XLS on d drive)with columns USER_ID, CLUSTER_CODE,TOWN, TOWN_CATEGORY, TOWN_TYPE, TYPE, STATUS INto the table XA TABLE XA ( USER_ID VARCHAR2(40) NOT NULL, CLUSTER_CODE VARCHAR2(15) NOT NULL, TOWN VARCHAR2(50), [...]

Answer Question   |  July 30, 2009  12:28 PM
Microsoft Excel import/export, Oracle development, Oracle import/export

calling reports in pl/sql code
how to call reports 6i report from pl/sql code procedure in pdf format

Answer Question   |  April 27, 2009  6:03 AM
Oracle 6i, Oracle Reports, Oracle Reports 6i, PL/SQL, PL/SQL procedure

HOW TO SAVE DATA FAST
I have a query that retrieves 7 lakh rows of data in say 3 minutes but when i go to save this data in comma sepatrated file using toad’s save as feature .it takes almost 3 hrs to save the data. This query looks like: SELECT circle_name,cluster_name,rsnnumber ,mdnnumber,hs_rsnnumber ,otafdate, (case when old_mdn is null then [...]

Answer Question   |  April 15, 2009  12:46 PM
Oracle Database, Oracle Output Via SQL, Oracle SQL

Can I install Developer 6i and make/run forms and reports on Windows Vista?
I am going to change my windows xp to vista, I want to know if I can form/report developer 6i on it and build my forms or reports? Does it make any problem? Thanks.

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

Using INSTEAD OF Views in Oracle Forms 6i
I have a block in my forms which is based on a view. I have created an instead of trigger on this view tu update certain fields. I would like to update this view through a Forms. I have made the block and the field updatable, but it gives me the following message when I [...]

Answer Question   |  July 30, 2009  7:18 AM
FRM-40602, INSTEAD OF triggers, Oracle development, Oracle Forms 6i, Oracle Views

BULK COLLECT and FORALL in PL/SQL
How do I update multiple columns in a table using the BULK COLLECT… FORALL methods in PL/SQL.

Answer Question   |  April 19, 2013  3:11 AM
BULK COLLECT statement, FORALL statement, Oracle PL/SQL, PL/SQL

rdbms and dbms
what is rdbms and dbms in oracle?

Answer Question   |  April 6, 2009  6:51 PM
DBMS, Oracle 9i, RDBMS

Oracle 9i: jrew.exe
while installing oracle9i in laptop i a getting message jrew.exe stopping program(i am using windows vista)

Answer Question   |  April 12, 2011  4:54 PM
Oracle 9i, Oracle error messages, Oracle installation, Windows XP

DB2/400 field to match an Oracle VARCHAR?
We are having trouble trying to use a 255 byte key in DB2/400 DDS specs. We use Oracle VARCHAR keys 255 bytes long all the time. How do we specify a DB2/400 key to be like an Oracle VARCHAR? Note: in an Oracle VARCHAR the trailing spaces are compressed out. In a pure 255 DDS [...]

Answer Question   |  May 18, 2009  9:03 PM
AS/400 interoperability, DB2 connectivity, DB2/400, DDS, Oracle development, Oracle interoperability, Oracle VARCHAR, VARCHAR

Need help with this Oracle Query
BPC_APPLICATIONS_TRANSACTIONS (Table) Application_no,Transaction_no,Transaction_date Step_id Dept_code Decision 20090045 1 01/14/2009 10:07:17 1 001 0 20090045 2 01/14/2009 10:07:17 70 007 0 20090045 3 01/14/2009 10:08:57 1 001 0 20090045 4 01/14/2009 10:08:57 60 006 0 20090045 5 01/14/2009 10:14:12 71 007 1 20090045 6 01/14/2009 10:14:41 61 006 1 20090045 7 01/18/2009 11:45:13 73 007 1 [...]

Answer Question   |  April 6, 2009  9:08 AM
Oracle queries, Oracle Query, Query optimization

ora-01033 oracle initialization or shutdown in progress
ora-01033 oracle initialization or shutdown in progress what is solution

Answer Question   |  July 22, 2009  7:22 AM
ORA-01033, Oracle error messages