No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
2 Posted Topics
[QUOTE=hawkoftheeye;1194785]Hello. Im wondering if anybody can help me out on a problem I am having for my SQL class. I have been going round in circles for the last three hours and am about ready to give up. The brief asks that I design a query that performs a division …
[CODE] declare faculty_last_name varchar2(80) := 'COX'; faculty_first_name varchar2(80) := 'KIM'; faculty_phone varchar2(80) := '7155551234'; begin dbms_output.put_line ( initcap(faculty_first_name) || ' ' || initcap(faculty_last_name) || '''s phone number is (' || substr (faculty_phone, 1, 3) || ') ' || substr (faculty_phone, 4, 3) || '-' || substr (faculty_phone, 8, 4) ); …
The End.