Recent content by meridian99

Our IS grape vine is saying we'll be going to ellipse full suite package. I was wondering if ellipse HR module has a employee training records component, which records training courses taken by individual employees? thanks

I was wondering if there's a way to determine in forms 10g on a window that displays 12 records in a tabular style if the cursor is sitting on record 1? Need to partially fill in data for record 1 then the remaining records get manually entered by the user. thanks for helping.....

I have a oracle 10g form that displays 12 records in a tabular style. When a user select a record then I call another window for them to edit the details. when the user exits the 2nd window and returns to the 1st window is there a way to move the cursor to the next record automatically? Not...

I was wondering what the DBMS product is used on the backend server for eclipse software?

Hello Oracle Vets, I was wondering if there a method for the select that would return records that do not have a value in a field of 'HST-'. Otherwords show me all courses that do not have 'HST-' in the course name. In vb you can do a substring to check for the values but not sure if oracle 8i...

Hi fellow SQlers... I'm trying to do a sql command that will return the records that are NOT in another associated oracle table. select * from employees where employeeid not found in employee_history Need to retrieve contractors which are in the employees file but do not exist in the...

Hello, I was wondering if a function within a package can be executed from a call in a .BAT file? I'd like to use win scheduler to run a bat file that call a function. Just for testing purposes. Here's the syntax d:\oracle\ora81\BIN\SQLPLUS.EXE -S jobs/xxxx@dbase EXEC pkg_testing.bundles...

I was wondering if there is a way in a script of sql/pl code within the 'exception' block to capture a oracle error code to assist in debugging. My code is failing on an INSERT. thanks

Is there a technique in oracle sql/pl that I can lookup an associated value based on a numeric code? 1 = crew A, 2 = crew B, 3 = crew C Instead of having to use multi IF statements to determine the crew code based on the numeric value. thanks

Is there a technique in oracle sql/pl that I can lookup an associated value based on a code? 1 = crew A, 2 = crew B, 3 = crew C Instead of having to use multi IF statements to determine the crew code based on the numeric value. thanks!

I use the following fix to add the century values to a 2 digit year into a 4 digit year. I found that dates < 1950 are converted into 2048 instead of 1948. update employee_details set date_of_birth = to_char(to_date(date_of_birth,'mm/dd/rr'),'mm/dd/yyyy'); commit; Is there a number of...

Hi Mufasa, your right! my mistake. Works perfect now. thanks again

Hi Mufasa, thanks for the great help. The field size is ok. But when I 'confirm the correctness of the change' using select to_char(to_date(birth_date,'mm/dd/rr'),'mm/dd/yyyy') birth_date from <table_name>; I noticed that all years are prefixed with '20' as in old date = 06/28/64 now shows...

Hello all, I have a date formatting issue and would ask for some sql help. I have a oracle field that is a varchar2 in a table that stores a birth_date value as text in the format of mm/dd/yy as text. I would like to re-format the value into mm/dd/yyyy to include the century and leave it as...

Aside from printing to a file, is there a option in excel2000 where I can export my sheet to a text file? thanks for your help