hi,
I have such problem.
In form i have multi-record block. If the value of an item in that block is <1 then i need format mask to be : 999
if item value >1 then format mask : 0D99
In th...
Hello. I work in Oracle 8.1.6 running in HP/UX 11. I am DBA and in the development area they work with Developer 6. We will migrate to Developer 9i. Also we want to migrate de database from 8....
Hi guys
i am using free version of toad 6. I want to logon using sys as sysdba in order to use explain plan feature of toad.
Toad has following login screen which asks for the fields...
Hi
I need to spool data from Forms block into a .csv file on the local PC. This should be kicked off by the user clicking a button which then just spools all the data from the fields in a b...
Hi,
Our user, who needs to connect to Oracle database(version 9.2.0.6.0) thru
Microsoft ODBC for ORACLE(version 2.573.9030.00). When she is trying to create a DSN , she is getting followi...
I want to assign insert/update provileges on specific tables to a role. How do I go about doing this in code (developer 2000 forms runtime).
The users in this role are also not dba and I a...
I want to change the shortcuts used in the application, which runs against a 9iAS un AIX.
How to do that?
Let's say that for Execute query the default is F11, i want to put F7 as a shortcu...
I've got a web site that works fine on 2 different Windows Server 2003 machines and the same code fails on my colleague's Windows XP machine. Other than the differences in the windows platform...
I need to gather stats on all tables in a schema that have rows of more than one. For some reason the script below is bombing....any help is appreciated. Also need to make sure that the inde...
Hi all,
I am doing a project in Developer 2000 and currently have a problem. I have a multi-block form and I need on click of a button and depending on certain conditions to copy all the f...
I am having great trouble finding out how to perform a simple IF statement as a calculation in Discoverer 10g. I want a calculation and not a condition as I want to show a value in an extra c...
Greetings!
I have a thrid party application that is designed to execute stored_procedure that accesses "views" from an oracle database. I have written the SP that will retrieve the values ...
When I have a dial up connection to the internet and I disconnect while I am running TOAD, I am disconnected from the Oracle connection.
What is the cause of this behaviour?
The application is pulling from a oracle db and uses sql statements to extract the data. Here is the portion of the statement that I need help with:
WHERE insured_name_type.name_type_code...
The database, and appserver come up fine. As soon as you hit enter after logging in from the browsr based login page, JVM crashes, Internet explorer goes with it, and it leaves a text file on...
i want a program (something like wizards ) that help me in making SQL scripts and SQL queries for ORACLE ( any version of of oracle)
there are many of these programs for MYSQL like Navicate ...
Hi,
I have one associative array which I need to take the data from and build up another array.
Existing code:
Build up first array:
for r_get_clauses in c_get_clauses(p_request_id,p...
I'm working in orgnization which ask for many reports and alot of statistical reports so always I type the SQL script and run in Toad software. I reach the point that I'm doing very big number...
need PL/sql code to CALCULATE FRIGHT CHARGES using ZIP code, shipping method, and service levels as criteria.
can anyone help me in this regard
We run a full set of Hyperion servers from our AU office. Web App data) We wish to provide Hyperion to other sites across the WAM in other parts of the world. Our WAN consists mainly of Sat li...
I'm trying to setup PL/SQL Developer to run an external program, and pass the select text editor string.
Does any one know how this can be done?
Following the 'Server Side Installation' chapter in the 'Oracle Designer Installation Guide', when clicking [start] on the Install a Repository Instance dialog box, I answer the prompts but th...
Hi
plate form : windows environment. and 9ias 8i database which is installed another system.
I have a report in Reports 6i, which was working in iAS with Oracle 8i database successfu...
I would like to write a stored proc.
and update a table in the stored proc.
and there is a trigger on that table to log the process.
No matter the stored proc is successed or failed.
the L...
hi ..
I have a table called item with two fields id and name ..
the customer will have an excel file where he will
specify the item ids and thier names .. how can i import
the data fr...
