Hi,
I am actually using Outlook for email interaction but I would like to be able to access my emails from oracle directly while working, without creating an email server. Anyone can help? T...
I need to list each referral in year 04/05 for those students who were referred more than once in the year.
The query below returns referrals in the previous year as well as 04/05. How do ...
Hello,
Please let me hear some knowledge about what is the difference between deleting the instance/database through the oracle database tool and if i just go directly to the database direc...
A have a table in a oracle 9i environment.
The table contains three columns of type varchar2(500).
I want to load the datas with sqlldr from a .csv-File.
The columns are terminated by the c...
Does anyone knows of a freeware tool for SQL Optimization like TOAD Quest SQL OPTIMIZER.
My main database is Oracle 9i
Thanks in advance
I am using Oracle Report Builder 6.0.8.20.1
The report that I am working on uses two sections in the layout model (Main and trailer sections).
my users have requested that a user paramet...
I want to get only the filename and not the full path from the v$datafile table. If I could locate the last last backslash I could then use SUBSTR.
If there was a RINSTR (reverse INSTR) I w...
Hi,
I want to import my database design to a "visual model".
I don't have ERWIN, do you know a freeware or open source that I can use?
I just want to import my model to a "visual model"...
hello
i have an oracle(6i) report based on something similiar to this:
SELECT * FROM emp
WHERE dept_no = :p_dept
and the parameter p_dept list value is based on the following query:
SELEC...
HELLO, ALL!
I have been troubled by an INSERT sentence that seems to be having problems ONLY when executed from an ADODB.Connection object in Visual Basic 6.
If I execute this from SQL+,...
Hi experts,
I need to find the time difference between dates that should be in hours.
The thing is,
I need to find the time difference in hours to display how many hours did my batch pgm ...
Q1. In TOAD, i see an option "Run to Cursor" on the shortcuts menu right on the top of TOAD window.
The icon is located next to the Step Over, Trace Into, Trace Out, and then Run Into Curso...
URGENT!!
Hi I am new to using Informatica
I am using the 7.1 version. Can anyone tell me how can I send a ".out" file as an email attachment using the email command task?
I have the ".out"...
I am using Oracle 8.1.5 and attempting to build a db in Win 2000 using svrmgr.
I have installed Oracle, ceated a "Temp" db as part of the installation. I then deleted the "Temp" db using D...
Hi
I am using PL/SQL Developer trying to run a query that should be giving me 2,000,000+ records but whenever I get to around 150,000 records I get an error message saying "Out Of Memory". ...
Im using Access 2003 and I wanted to know if there is any way that I can create a view like in sql that will show a diagram of the tables and the keys. The will be of linked tables. Any 3rd ...
Hi,
I am trying to write a few dos-scripts get a daily status-report from all my machines, including an Oracle Database server 8.x
Is there a simple command to check the free space of a ...
Hi, I get the error OCI-22064: invalid NLS parameter string [NLS_NUMERIC_CHARACTERS='..'] when I perform a table export data operation from the TOAD menu: Database---> Export--->Table Data.
I...
Hi All, I don't want to reinvent the wheel, so I thought that I would ask if any one has a PL/SQL Procedure that I can use as a template. What I would like to do is:
1) Data base has a t...
Hello,
I am doing a project at uni which involving building a prototype data warehouse. For the last two weeks, I was supposed to research the oracle warehouse builder application. Its become...
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...
Hello, I am trying to connect to an Oracle DB through TOAD, but I get the infamous ORA-12154 error message ("could not resolve service name").
From the connection string of an Interdev projec...
i have used all the populate_list function etc.... but its not working .... so plz suggest a solution... basically first i have used a record group where i'm taking all the values using the se...
Hi,
I need to change the colour of text in a multi-record block depending on the value of that text.
i.e OK = Green, Failed = red.
I call this on postquery but it just colours ALL the...
Hi
I cant seem to find the solution to this, can anybody please tell me if there is a switch I can turn on to log all sql statements from Oracle Toad 9 to a text file?
The reason I want ...
