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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.