Oracle SQL Developer or SQLPlus for creating a scheduled query

SELECT 
    		CC.TermID as Termid,
		Schools.Name as "[39]Name",
		Teachers.FIRST_NAME as "[5]first_name",
		Teachers.LAST_NAME as "[5]last_name",
		Teachers.EMAIL_ADDR as "[5]Email_Addr",		
		Teachers.TEACHERNUMBER as "[5]TeacherNumber",		
		CustomText2.VALUE as "[5]paylocity_id",
		Courses.COURSE_NAME as "[2]course_name",
		Courses.COURSE_NUMBER "[2]Course_Number",		
		CustomText1.VALUE as "[3]section_name_schoolsuse",		
		Students.FIRST_NAME as "[1]first_name",
		Students.LAST_NAME as "[1]last_name",
		CONCAT (CC.SchoolID,Students.STUDENT_NUMBER)  as "[1]student_number"
		
		FROM CC  CC
		left outer join Teachers  Teachers
		ON CC.TeacherID = Teachers.ID and CC.SchoolID = Teachers.SchoolID
		
		left outer join Courses  Courses
		ON CC.Course_Number = Courses.Course_Number and CC.SchoolID = Courses.SchoolID 
		
		left outer join Students  Students
		ON CC.StudentID = Students.ID and CC.SchoolID = Students.SchoolID  
		
		left outer join Schools  Schools
		ON CC.SchoolID = Schools.School_Number
		
		left outer join CustomText CustomText1
		ON CC.SectionID = CustomText1.KeyNo and CustomText1.FieldNo = 571		
		
		left outer join CustomText  CustomText2
		ON Teachers.ID = CustomText2.KeyNo and CustomText2.FieldNo = 551

		left outer join CustomText  CustomText3
		ON Courses.ID = CustomText3.KeyNo and CustomText3.FieldNo = 771


 		WHERE CC.TermID > 0 
		--and CustomText3.VALUE like 'yes'
		and (Students.ExitCode not like ('NS') or Students.ExitCode is NULL)
    		and Students.STUDENT_NUMBER is not NULL
  
		and Courses.COURSE_NAME not in ('ACE','AE','Lunch','Meet','Recess','Snack','Study Hall','TA','TLC', 'Enrichment')
  
   		ORDER BY Schools.Name asc, Teachers.LAST_NAME asc, Teachers.FIRST_NAME asc, Courses.COURSE_NAME asc, Students.LAST_NAME asc, Students.FIRST_NAME

Select allOpen in new window