select pk1, service_level, course_id, course_name from bblearn.course_main where course_id='xxxxxxx';
update bblearn.course_main set service_level = 'C' where course_id=' xxxxxxx';
select * from bblearn.gateway_course_categories where crsmain_pk1=nnnnn;
delete from bblearn.gateway_course_categories where crsmain_pk1= nnnnn;
select * from bblearn.community_course_categories where crsmain_pk1=nnnnn;
delete from bblearn.community_course_categories where crsmain_pk1=nnnnn;
select crsmain_pk1, label from bblearn.course_toc where crsmain_pk1=nnnnn;
update bblearn.course_toc set label=replace(label,'COURSE','ORGANIZATION') where crsmain_pk1= nnnnn;
commit;
So, for Data Security Basics (avcf.pci):
select pk1, service_level, course_id, course_name from bblearn.course_main where course_id='avcf.pci';
update bblearn.course_main set service_level = 'C' where course_id='avcf.pci';
select * from bblearn.gateway_course_categories where crsmain_pk1=181;
delete from bblearn.gateway_course_categories where crsmain_pk1=181;
select * from bblearn.community_course_categories where crsmain_pk1=181;
delete from bblearn.community_course_categories where crsmain_pk1=181;
select crsmain_pk1, label from bblearn.course_toc where crsmain_pk1=181;
update bblearn.course_toc set label=replace(label,'COURSE','ORGANIZATION') where crsmain_pk1=181;
Full query results:
13:29:48 SQL> select pk1, service_level, course_id, course_name from bblearn.course_main where course_id='avcf.pci';
PK1 S COURSE_ID COURSE_NAME
---------- - ---------- -----------------
181 F avcf.pci Data Security Basics
13:34:49 SQL> update bblearn.course_main set service_level = 'C' where course_id='avcf.pci';
1 row updated.
13:35:00 SQL> select * from bblearn.gateway_course_categories where crsmain_pk1=181;
PK1 GATEWAYCAT_PK1 CRSMAIN_PK1 DATA_SRC_PK1 ROW_STATUS A SOS_ID_PK2 CRSMAIN_SOS_ID_PK2 DATA_SRC_SOS_ID_PK2 GATEWAYCAT_SOS_ID_PK2 DTMODIFIED DTCREATED
---------- -------------- ----------- ------------ ---------- - ---------- ------------------ ------------------- --------------------- ------------------- -------------------
235 105 181 2 0 Y 1 1 1 1 2010-06-03 17:58:53 2010-06-03 17:58:53
13:35:05 SQL> delete from bblearn.gateway_course_categories where crsmain_pk1= 181;
1 row deleted.
13:35:15 SQL> select * from bblearn.community_course_categories where crsmain_pk1=181;
no rows selected
13:35:23 SQL> delete from bblearn.gateway_course_categories where crsmain_pk1=181;
0 rows deleted.
13:35:34 SQL> delete from bblearn.community_course_categories where crsmain_pk1=181;
0 rows deleted.
13:35:39 SQL> select crsmain_pk1, label from bblearn.course_toc where crsmain_pk1=181;
CRSMAIN_PK1 LABEL
----------- -------------------------------------------
181 COURSE_DEFAULT.BulletinBoard.MODULE.label
181 COURSE_DEFAULT.Groups.APPLICATION.label
181 Content
181 CALENDAR.label
181 WEBLINKS.label
13:35:46 SQL> update bblearn.course_toc set label=replace(label,'COURSE','ORGANIZATION') where crsmain_pk1=181;
5 rows updated.
13:35:56 SQL> select crsmain_pk1, label from bblearn.course_toc where crsmain_pk1=181;
CRSMAIN_PK1 LABEL
----------- -------------------------------------------------
181 ORGANIZATION_DEFAULT.BulletinBoard.MODULE.label
181 ORGANIZATION_DEFAULT.Groups.APPLICATION.label
181 Content
181 CALENDAR.label
181 WEBLINKS.label
13:36:04 SQL> commit;
Commit complete.
]]>
