i create a report using report buider 9i , and i wana invoke that report
from a form module when press on a button on that form .
but i dont know how to do it pls help me with a code pls
thanks

I'm making the following select in an Oracle 9i database:
select s.cusip, s.udf3, s.udf2 from trade t, security s where t.sec_sid
= s.sec_sid and s.udf2 != 'CMO' and end_date >= '25-jan-05';
As expected, this does exclude records with values of 'CMO' in s.udf2

A large part of my work duties involve designing, implementing and to some
extent maintaining backup & recovery solutions. It is not limited to Oracle,
rather I have to deal with file systems, mail servers, application servers
etc spread over quite a few platforms. This of course ...

I cannot make tnsping through VPN connection.  VPN is setup and I can access
the files but the oracle data service is not accessible.  Any tricks need
here or ideas.
Regards

I can't tell I'm newbee - with  Oracle I just customer.  I have Oracle(8.1)
client under Win2000 and can read some datas from server. And have to use it
with application under Linux. Naturaly I do it with some manual manipulation.
Tried to find possibility to read directly - seems ...

I have been tasked with converting a MS SQL 2000 db to Oracle 10g. I am
the one that will be writing the updates to the table structures,
taking existing sp's and moving them to pl/sql. My problem is I have
not done this in a good number of years, converting sql to ora, and I

I'm considering a move to Mac OSX at work, but I manage various Oracle
Databases with Oracle Enterprise Manager Console.  Is it possible to
install this on OSX?  I assume so since it runs in Java and works on
Linux and Windows -- but I've never seen or heard of it running on OSX.

I want to know if a simple tool ( for windows ) can check the syntax
of a PLSQL script without running it ... in fact, just an analyser to
check if a ; is missing for example ...
Thanks a lot.

I'm trying to get Oracle Migration Workbench up and running and am
having some difficulty. I just downloaded it yesterday and have
followed the instructions as far as I could. I need to move some
tables from SQL Server into Oracle. Here's the problem: The

I ran across a problem with the format of an ASCI output file of an
SQL script.  The problem I have is with handling a particular column
that contains account numbers.  The column is defined with 8
characters.  However not every entry has data.  I have several fields

Sr. Oracle 9i back end developers that possess 5 years of experience
with various Oracle development tools.
Must skills: Oracle 9i, Erwin,Toad, Unix, and Data Modeling.
Must have experience with Data modeling, Physical Design, Logical

I'm using Oracle Developer 6 (forms and reports) and find that the fonts
size is too small to be seen.  When I use 1024x768, I can barely see the
code, esp. in Plsql editor.  I have no choice to switch to 800x600.
Is there a way to make the fonts larger for easy viewing?

Thanks Mark.  Our report is report based.  However, the IT person
would not update the codes for me.  Therefore I cannot directly
access the database.  There is no place I can put DESFORMAT and
DESTYPE parameters to control output format.  What I can do is "READ"

I am new to this group. Iam looking for projects to work from home. I
am Oracle Certified Associate (OCA) with 93% score and have a 5 yrs of
exp as oracle developer. I am in H1 B visa. I had my 1st baby few
months back. So I am looking for projects to work from home. Could

I have very strange situation. SQLPLUS installed on version 7.3 of Oracle
RDBMS (on AIX), best running about a lot of days ago, now cannot display
command prompt after logon.
Via svrmgrl I've full control and terminating sqlplus session (after long