Recent content by marjac

To me it sounds as if your director is opening the door to the concept of collaboration. I appreciate that your director is not autocratic and is breaking the normal organizational hierarchy. When directors involve their team in the process, they get buy-in from the team. Your director is...

Thanks for responding so quickly lewisp...it worked, Yay!

I am creating a CSV file and am using an input value in SQL Plus to select data. (AND SCHYEAR = SUBSTR('&SCHYEAR',6,4);) selects the end of a school year input like ‘2003-2004’ I have set echo off set serveroutput on size 1000000 set linesize 300 set heading off set feedback off but I...

Well...t’s been fun. I really needed to only worry about a last name field at this point, and jad has started me on writing a custom function...so thanks to all for an interesting thread!

I agree that it would be easier to store the correct value in the database JediDan, but then I would need a way to train all the Monkey’s to do so :) .

I need to update columns to mixed case letters. I use INITCAP, which does fine at capitalizing the first letter in the word. The question I have is how to use proper capitalization. Example: MACDONALD is Macdonald instead of MacDonald. Does anybody know any rules to use or tools to use to do...

Can a stored procedure select SQL stored in a database table?