作成したAPEXアプリケーションは以下のように動作します。
観光立国推進基本法の前文の最初のセンテンスを、小学生向けと中学生向けに言い換えてもらっています。言い換えを行なう生成AIとして、ローカルのLM Studioにロードしたphi-4@8bitを使用しています。
ちなみに、言い換えの対象とした観光立国基本法の前文は以下です。
「観光は、国際平和と国民生活の安定を象徴するものであって、その持続的な発展は、恒久の平和と国際社会の相互理解の増進を念願し、健康で文化的な生活を享受しようとする我らの理想とするところである。また、観光は、地域経済の活性化、雇用の機会の増大等国民経済のあらゆる領域にわたりその発展に寄与するとともに、健康の増進、潤いのある豊かな生活環境の創造等を通じて国民生活の安定向上に貢献するものであることに加え、国際相互理解を増進するものである。」
「観光って、とても大切なことなんだよ。みんなでお互いに仲良くするために、国や世界の人々が集まって遊びに来るんだよ。このことで、世界中の人々が仲良くなれたり、お互いを理解し合えるようになるんだ。 友達と一緒にお出かけするのと似ていて、観光は私たちが楽しさや素敵な経験を分かち合うことができるんだよ。また、観光は地域のお店を元気にしたり、仕事をたくさん作ってくれるんだ。 それから、観光で色々なところを訪れたりするのは、体も心も元気になるし、素敵で豊かな生活を送れるようにしてくれるんだ。さらに、異なる文化や考え方を知って楽しむことで、お互いのことをよく理解する手助けになるんだよ。 ね、観光って素晴らしいことだと思わない？みんなが楽しく、お互いを理解し合って生活できるように、観光はすごく役立っているんだね。」
中学生向けの言い換えとして、以下が生成されました。
法令データのロードには、以前の記事「日本の法令データをデータベースにロードする」で作成したアプリケーションを使用します。元記事を書いた時から２点、変更があります。
１点目は旧法令名（表JLAW_DATAの列LAW_TITLE_FORMER）の長さを600文字に拡張しています。２点目は、本文URLが変わっているため、列IDのデータ・プロファイルのソースのSQL式を以下のように変更しています。
旧
replace(BODY_URL, 'https://elaws.e-gov.go.jp/document?lawid=')
e-Gov法令検索リニューアル後
replace(replace(BODY_URL, 'https://laws.e-gov.go.jp/law/'),'/','_')
Oracle APEX 24.2で、元記事の手順に従って作成したAPEXアプリケーションのエクスポートを以下に置きました。
https://github.com/ujnak/apexapps/blob/master/exports/laws-e-gov-0.zip
このアプリケーションでは、法令XMLのデータをURLから取得しています。データをロードするごとに、データのダウンロードを繰り返すことを避けるために、法令XMLのZIPファイルを一旦ファイルとしてダウンロードしたのちに、そのファイルをアップロードする機能を追加します。
ホーム・ページに、アップロードするファイルを選択するページ・アイテムを作成します。
識別の名前はP1_FILE、タイプはファイルのアップロードです。ラベルはFileとします。ストレージのタイプに表APEX_APPLICATION_TEMP_FILES、ファイルをパージするタイミングとしてリクエストの終わりを選択します。ファイル・タイプにapplication/zipを指定し、アップロード対象をZIPファイルに限定します。
セッション・ステートのストレージはリクエストごと(メモリーのみ)とします。
ZIPファイルをアップロードするボタンを作成します。
識別のボタン名はUPLOAD、ラベルはUploadとします。外観のホットをオンにし、テンプレート・オプションのWidthをStretchにします。
動作のアクションはデフォルトのページの送信です。
プロセス・ビューを開き、実行チェーン法令データのロードを選択します。
実行チェーンの子プロセスでアップロードされたファイルが参照できるように、設定の一時ファイル処理を移動に変更し、一時ファイル・アイテムとしてP1_FILEを選択します。
また、ボタンUPLOADのクリックでもロード処理が実行されるように、サーバー側の条件のボタン押下時を- 選択 -に戻し、タイプにリクエストは値に含まれる、値としてLOAD UPLOADを設定します。
バインド変数REQUESTに、ページの送信を実行したボタン名が設定されています。タイプの意味が分かりにくいですが、バインド変数REQUESTの値としてLOAD UPLOADのどれかが設定されている、という条件になっています。ボタンによるページの送信に限れば、ボタン押下時の設定は、リクエスト = 値と同じ条件になります。
プロセスLoad e-Gov CSV and XMLのソースのPL/SQLコードを以下に置き換えます。ボタンUPLOADのときはZIPファイルをAPEX_APPLICATION_TEMP_FILESより取り出すように、コードを追加しています。
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| declare | |
| l_blob_zip blob; | |
| l_blob_csv blob; | |
| l_blob_xml blob; | |
| l_clob_xml clob; | |
| l_new_hash raw(32); | |
| l_old_hash raw(32); | |
| e_web_access_failed exception; | |
| l_files apex_zip.t_files; | |
| l_load_result apex_data_loading.t_data_load_result; | |
| l_total_laws number; | |
| l_id varchar2(4000); | |
| l_xml xmltype; | |
| l_skipped number := 0; | |
| l_ignored number := 0; | |
| l_updated number := 0; | |
| l_message varchar2(100); | |
| begin | |
| if :REQUEST = 'LOAD' then | |
| /* | |
| * URLで指定された法令種別データセットを取得する。ZIP形式のバイナリ。 | |
| */ | |
| apex_background_process.set_status('Start: downloading zip'); | |
| apex_web_service.set_request_headers('Content-Type', 'application/zip'); | |
| l_blob_zip := apex_web_service.make_rest_request_b( | |
| p_url => :P1_URL | |
| ,p_http_method => 'GET' | |
| ); | |
| if apex_web_service.g_status_code <> 200 then | |
| raise e_web_access_failed; | |
| end if; | |
| apex_debug.info('Download Completed.'); | |
| apex_background_process.set_status('Completed: downloading zip'); | |
| elsif :REQUEST = 'UPLOAD' then | |
| /* | |
| * P1_FILEで選択したファイルを取り出す。 | |
| */ | |
| select blob_content into l_blob_zip from apex_application_temp_files | |
| where name = :P1_FILE; | |
| end if; | |
| /* | |
| * ZIPアーカイブに含まれるファイル一覧を取得する。 | |
| */ | |
| l_files := apex_zip.get_files( | |
| p_zipped_blob => l_blob_zip | |
| ); | |
| /* | |
| * ZIPアーカイブに含まれるCSVファイルを見つけ、表JLAW_DATAにロードする。 | |
| */ | |
| apex_background_process.set_status('Start: load CSV in zip'); | |
| for i in 1..l_files.count | |
| loop | |
| /* | |
| * 含まれているCSVファイルは１つだけなはず。 | |
| */ | |
| if l_files(i) like '%.csv' then | |
| apex_debug.info('file %s found.', l_files(i)); | |
| l_blob_csv := apex_zip.get_file_content( | |
| p_zipped_blob => l_blob_zip | |
| ,p_file_name => l_files(i) | |
| ); | |
| l_load_result := apex_data_loading.load_data( | |
| p_static_id => 'LOAD_CSV' | |
| ,p_data_to_load => l_blob_csv | |
| ); | |
| l_total_laws := l_load_result.processed_rows; | |
| apex_debug.info( 'Processed %s rows.', l_total_laws); | |
| exit; -- CSVがロードできれば以降はスキップしてXMLのロードに移る。 | |
| end if; | |
| end loop; | |
| apex_debug.info('CSV Load Complated.'); | |
| apex_background_process.set_status('Completed: load CSV in zip'); | |
| /* | |
| * ZIPに含まれているXMLを表JLAW_DATAに更新する。 | |
| */ | |
| apex_background_process.set_status('Start: load XML files in zip'); | |
| for i in 1..l_files.count | |
| loop | |
| if l_files(i) like '%.xml' then | |
| l_blob_xml := apex_zip.get_file_content( | |
| p_zipped_blob => l_blob_zip | |
| ,p_file_name => l_files(i) | |
| ); | |
| /* 法令のXMLファイルはディレクトリ名とファイル名が同じ。 */ | |
| l_id := replace(l_files(i),'.xml'); | |
| l_id := substr(l_id, instr(l_id,'/')+1); | |
| /* BLOBをXMLtypeに変換 */ | |
| l_xml := xmltype( | |
| xmlData => l_blob_xml | |
| ,csid => NLS_CHARSET_ID('AL32UTF8') | |
| ); | |
| /* ハッシュ値の計算 */ | |
| l_clob_xml := l_xml.getClobVal(); | |
| l_new_hash := sys.dbms_crypto.hash(l_clob_xml, dbms_crypto.HASH_SH256); | |
| begin | |
| select body_hash into l_old_hash from jlaw_data where id = l_id; | |
| /* ハッシュ値が一致していれば更新しない。 */ | |
| if l_old_hash = l_new_hash then | |
| l_skipped := l_skipped + 1; | |
| else | |
| l_updated := l_updated + 1; | |
| update jlaw_data set body = l_xml, body_hash = l_new_hash where id = l_id; | |
| if mod(l_updated, 200) = 0 then | |
| commit; -- 200行アップデートごとにコミットする。 | |
| apex_debug.info('XML Load Commited.'); | |
| end if; | |
| end if; | |
| exception | |
| when no_data_found then | |
| /* CSVにエントリがないのにXMLはあるのは異常。 */ | |
| l_ignored := l_ignored + 1; | |
| apex_debug.info('id %s not in CSV.', l_id); | |
| end; | |
| apex_background_process.set_progress(p_sofar => i ,p_totalwork => l_total_laws); | |
| end if; | |
| end loop; | |
| commit; | |
| l_message := apex_string.format('Completed: updated %s, skipped %s, ignored %s', l_updated, l_skipped, l_ignored); | |
| apex_background_process.set_status(l_message); | |
| apex_debug.info(l_message); | |
| end; |
以上で、URL指定の代わりにファイルをアップロードする機能が追加されました。
APEXアプリケーションを実行し、法令データをロードしてみます。
記事の先頭のGIF動画ではe-Gov法令のXML一括ダウンロードより、観光に関する法令データを読み込んで扱っています。この法令データは、5_xml.zipとしてダウンロードされます。
バックグランド処理のStatus CodeがSUCCESSで終了していれば、データのロードは成功です。
ここまで実装したアプリケーションのエクスポートを以下に置きました。
https://github.com/ujnak/apexapps/blob/master/exports/laws-e-gov-1.zip
これから、法令データの言い換えを実装します。
法令データは、XML形式のままデータベースに保存しています。XML形式のままではAPEXで扱うのが難しいため、これを表として参照できるようにビューを定義します。CREATE VIEW文は、本記事の末尾に添付します。
作成するビューの中で、法令の前文を扱うビューJLAW_LAW_PREAMBLE_XVと、本則を扱うビューJLAW_LAW_MAINPROVISION_XVについて、対話モード・レポートで一覧します。
アプリケーションに空白のページを作成します。
ページの作成をクリックします。
空白ページを選択します。
識別の名前を前文とし、タイプに対話モード・レポートを選択します。ソースのSQL問合せに以下を記述します。
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select | |
| ID, | |
| LAW_ID, | |
| "LawType", | |
| "LawNum", | |
| to_number("Root_Num" default -1 on conversion error) "Root_Num", | |
| "LawTitle", | |
| "LawTitle_Kana", | |
| to_number("Paragraph_Num" default -1 on conversion error) "Paragraph_Num", | |
| to_number("Sentence_Num" default -1 on conversion error) "Sentence_Num", | |
| "Sentence" | |
| from JLAW_Law_Preamble_XV; |
詳細のリージョン表示セレクタをオンにします。
列"Root_Num"、"Paragraph_Num"、"Sentence_Num"は数値のはずなのですが、1_1のような数値に変換できない文字列が含まれていることがあったため、ビューの検索時にエラーが発生しないようにXMLからは文字列として取り出しています。レポートのソースで、文字列から数値に変換しています。
特に本則の表示はデフォルトでは見にくいため、対話モード・レポートのカスタマイズが必要でしょう。
もう一つ、本則を表示する対話モード・レポートのリージョンを作成します。
識別の名前を本則とし、タイプに対話モード・レポートを選択します。ソースのSQL問合せに以下を記述します。
先頭のリージョンを、リージョン表示セレクタにします。装飾は不要なため、外観のテンプレートにBlank with Attributesを選択します。
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select | |
| ID, | |
| LAW_ID, | |
| "LawType", | |
| "LawNum", | |
| to_number("Root_Num" default -1 on conversion error) "Root_Num", | |
| "LawTitle", | |
| "LawTitle_Kana", | |
| to_number("Part_Num" default -1 on conversion error) "Part_Num", | |
| "PartTitle", | |
| to_number("Chapter_Num" default -1 on conversion error) "Chapter_Num", | |
| "ChapterTitle", | |
| to_number("Section_Num" default -1 on conversion error) "Section_Num", | |
| "SectionTitle", | |
| to_number("Subsection_Num" default -1 on conversion error) "Subsection_Num", | |
| "SubsectionTitle", | |
| to_number("Division_Num" default -1 on conversion error) "Division_Num", | |
| "DivisionTitle", | |
| to_number("Article_Num" default -1 on conversion error) "Article_Num", | |
| "ArticleTitle", | |
| to_number("Paragraph_Num" default -1 on conversion error) "Paragraph_Num", | |
| to_number("Sentence_Num" default -1 on conversion error) "Sentence_Num", | |
| "Sentence" | |
| from JLAW_Law_MainProvision_XV | |
| order by | |
| "Root_Num" asc nulls first, | |
| "Part_Num" asc nulls first, | |
| "Chapter_Num" asc nulls first, | |
| "Section_Num" asc nulls first, | |
| "Subsection_Num" asc nulls first, | |
| "Division_Num" asc nulls first, | |
| "Article_Num" asc nulls first, | |
| "Paragraph_Num" asc nulls first, | |
| "Sentence_Num" asc nulls first |
詳細のリージョン表示セレクタをオンにします。
１ページに表示される情報量を制限するため、属性を開き、設定の「すべて表示」を含めるをオフにします。
ページを実行します。
対話モード・レポートとして法令の前文または本則が表示されます。
本則では、列として"Law Id"、"Lawtype"、"Lawnum"、"Parttitle"、"Chaptertitle"、"Sectiontitle"、"Subsectiontitile"、"Divisiontitle"、"Articletitle"、"Sentence Num"、"Sentence"などを表示します。
対話モード・レポートのソースとなるSELECT文にORDER BY句を含めるべきではありませんが、法令については表記の順番を変える必要はなく、また、対話モード・レポートとして設定できるソート列は６までなので、今回はソースのSELECT文で表示順序を決めています。
対話モード・レポートの属性のソートをオフにします。
列についてもソートをオフにすると、対話モード・レポートでソートの設定ができなくなります。
以上で、法令の前文と本則を表示する対話モード・レポートの設定は完了です。
これより、本題の動的アクションのAIによるテキストの生成を実装します。
生成AIはローカルのLM Studioを呼び出します。LLMとして、比較的速くレスポンスが返されるphi-4@8bitを使用します。
APEXのワークスペースに、ローカルのLM Studioを呼び出すための生成AIサービスの構成を作成します。ローカルのLM Studioの呼び出しにWeb資格証明は不要ですが、APEXの生成AIの構成では必須の設定になっています。そのため、ダミーのWeb資格証明を作成します。
ワークスペース・ユーティリティのWeb資格証明を作成します。
Web資格証明の一覧で作成をクリックし、以下のような形だけの資格証明を作成します。
名前はempty credential、静的IDとしてEMPTY_CRED、認証タイプにHTTPヘッダーを選択します。資格証明名はAuthorization、資格証明シークレットとしてbearer emptyを指定します。
以上の設定で、Web資格証明を作成します。
続いて、ワークスペース・ユーティリティの生成AIを開きます。
生成AIの一覧より作成をクリックし、生成AIサービスを作成します。
AIプロバイダにOpen AIを選択します。名前はphi-4@8bitとし、静的IDはPHI4とします。ベースURLは、podmanのコンテナとして実行されているOracle Databaseより、ホストのポート8080で待ち受けしているLM Studioのローカル・サーバーに接続するため、以下のように指定します。
http://host.containers.internal:8080/v1
資格証明として先ほど作成した空の資格証明EMPTY_CREDを選択します。詳細のAIモデルとして、呼び出すモデル名であるphi-4@8bitを設定します。
以上で接続のテストをクリックして、動作確認します。接続に成功したら、作成をクリックします。
生成AIサービスとしてphi-4@8bitが作成されました。
APEXワークスペースへの生成AIサービスの作成は以上で完了です。
APEXアプリケーションのAI構成を作成します。これはAPEX 24.2で追加された構成になります。
共有コンポーネントのAI構成を開きます。
AI構成として、法令を小学生向けに言い換える構成と、中学生向けに言い換える構成の２つを作成します。
作成をクリックします。
最初に小学生向けに言い換えを行なうAI構成を作成します。
識別の名前は小学生向け、静的IDはELEMENTARYとします。サービスに先ほど作成したphi-4@8bitを選択します。
システム・プロンプトとして以下を記述します。
「あなたには、日本の小学校の先生の役割が与えられています。与えられたメッセージを小学生に分かるように言い換えてください。」
以上で作成をクリックします。
生成AI構成として小学生向けが作成されます。RAGソースが設定可能な項目として表示されます。今回はRAGソースは構成しないため、そのまま変更の適用をクリックします。
識別の名前は中学生向け、静的IDはJUNIOR、生成AIのサービスはphi-4@8bitを選択し、システム・プロンプトとして以下を記述します。
「あなたには、日本の中学校の先生の役割が与えられています。与えられたメッセージを中学生に分かるように言い換えてください。」
以上の設定でAI構成を作成します。
AI構成として、小学生向けと中学生向けが作成されました。
APEXアプリケーションのページ番号３の説明のページに、言い換えの元になる法令を保持するページ・アイテムと言い換えた後の文章を表示するページ・アイテムおよび生成AIによる言い換えを呼び出すボタンを作成します。
言い換えの対象とする法令を保持するページ・アイテムはP3_TEXTとして作成します。タイプはテキスト領域、ラベルは法令とします。
セッション・ステートのデータ型はCLOB、ストレージはリクエストごと(メモリーのみ)とします。
動作のアクションとして動的アクションで定義を選択します。
同様に中学生に説明するボタンを作成します。ボタン名はEXPLAIN_JUNIORとします。
生成AIによる言い換えを表示するページ・アイテムとしてP3_EXPLAINを作成します。タイプはリッチ・テキスト・エディタとします。ラベルは言い換えとします。
設定の書式としてマークダウンを選択します。ただし、今回設定したシステム・プロンプトとphi-4@8bitの組み合わせでは、マークダウンは出力はされないようです。
セッション・ステートのデータ型はCLOB、ストレージはリクエストごと(メモリーのみ)を指定します。このページ・アイテムは表示しかしないため、読取り専用のタイプに常時を設定します。
ボタン小学生に説明するをクリックしたときに実行する動的アクションを作成します。
識別の名前はonClick EXPLAIN_ELEMENTARYとします。タイミングのイベントはクリック、選択タイプはボタン、ボタンはEXPLAIN_ELEMENTARYになります。
最初に実行されるTRUEアクションとしてクリアを実行し、言い換えを表示しているページ・アイテムP3_EXPLAINをクリアします。
続くTRUEアクションとしてAIによるテキスト生成を実行します。生成AIの構成に小学生向けを選択します。
入力値のタイプにアイテム、アイテムとしてP3_TEXTを選択します。入力値のタイプには、ページ・アイテムの他にシステム・プロンプトのみとJavaScriptコードがあります。入力値を加工したい場合、JavaScriptコードを使うことができます。
レスポンスの使用のタイプにアイテム、アイテムとしてP3_EXPLAINを選択します。レスポンスの使用のタイプには、ページ・アイテムの他にJavaScriptコードがあります。出力についても、JavaScriptコードで加工することができます。
以上で、ボタン小学生に説明するをクリックすると、ページ・アイテムP3_TEXTの内容を小学生向けに言い換えて、ページ・アイテムP3_EXPLAINに表示する機能が実装できました。
同様にボタン中学生に説明するの動的アクションを作成します。
動的アクションの識別の名前はonClick EXPLAIN_JUNIORとします。
小学生向けと同様に、最初のTRUEアクションでページ・アイテムP3_EXPLAINをクリアします。
後続のTRUEアクションとしてAIによるテキスト生成を実行します。小学生向けと同様ですが、生成AIの構成として、中学生向けを選択します。
以上で、APEX 24.2の新機能、AIによるテキスト生成を使った法令の言い換えが実装できました。
ページを実行し、対話モード・レポートに表示されている法令の文言を、ページ・アイテムの法令にコピーして、ボタン小学生に説明するをクリックします。
小学生向けの説明が、言い換えの領域に表示されます。
同様にボタン中学生に説明するをクリックすると、中学生向けの説明が表示されます。
毎回、対話モード・レポートから法令の文言をコピペするのは面倒なので、列Sentenceのセルをクリックしたときに、そのセルの文言をページ・アイテムにコピーするようにします。
前文を表示する対話モード・レポートのCSSクラスとしてlaw-Reportを設定します。これはセレクタで使用するためのクラスなので、CSSクラス自体は定義しません。
列Sentenceの静的IDとしてSENTENCE_COLUMNを設定します。Oracle APEXのほぼ全てのコンポーネントで静的IDは属性IDとして設定されますが、レポート列は例外で属性headersとして設定されます。
本則を表示する対話モード・レポートについても、同様の設定を行います。
対話モード・レポートのCSSクラスとしてlaw-Reportを設定します。
列Sentenceの静的IDとしてSENTENCE_COLUMNを設定します。
レポート列Sentenceからページ・アイテムP3_TEXTにテキストをコピーする動的アクションを作成します。
左ペインで動的アクション・ビューを開き、クリックのノードで新たに動的アクションを作成します。
識別の名前はClick to Copyとします。実行のイベント有効範囲に動的を選択し、静的コンテナ(jQueryセレクタ)に.law-Reportを指定します。タイプは即時です。
タイミングのイベントはクリック、選択タイプにjQueryセレクタを選び、jQueryセレクタとしてtd[headers="SENTENCE_COLUMN"]を指定します。
以上で、対話モード・レポートの列Sentence上でクリックしたときに、動的アクションが実行されます。
TRUEアクションとして値の設定を実行します。
設定のタイプの設定にJavaScript式を選択し、JavaScript式としてthis.triggeringElement.innerTextを記述します。ボタンのクリックはレポート上のTD要素上で発生するため、TD要素がtriggeringElementとなります。そのクリックされたTD要素のinnerTextが、コピーする対象の文字列になります。
影響を受ける要素の選択タイプはアイテム、アイテムとしてP3_TEXTを指定します。ページ・アイテムP3_TEXTがコピー先になります。
実行の初期化時に実行はオフとします。
これで、記事に先頭のGIF動画のように動作するAPEXアプリケーションは完成です。
完成したAPEXアプリケーションのエクスポートを以下に置きました。
https://github.com/ujnak/apexapps/blob/master/exports/laws-e-gov.zip
今回の記事は以上になります。
Oracle APEXのアプリケーション作成の参考になれば幸いです。
完
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * e-Gov法令XMLを表形式に変換するビュー定義。 | |
| */ | |
| /* | |
| * /Law/LawBody | |
| * | |
| * 全部は大変なので、ビューを作る要素はPreamble、MainProvision, SupplProvisionに限定する。 | |
| * | |
| * LawTitle_xのように、子ノードをtext()を指定して文字列として取得しているのにもかかわらずXMLTYPE型として定義し、 | |
| * その後にXMLSERIALIZEを呼び出しているのは、LawTitleの文字列に<Ruby>などのタグが含まれていることが原因で | |
| * エラーが発生するのを回避するため。 | |
| */ | |
| create or replace view jlaw_LawBody_xv | |
| as | |
| select | |
| d.id, | |
| d.law_id, | |
| -- /Law | |
| l."Era", | |
| l."Lang", | |
| l."LawType", | |
| l."Num" "Root_Num", | |
| l."Year", | |
| l."PromulgateMonth", | |
| l."PromulgateDay", | |
| l."LawNum", | |
| -- /Law/LawBody | |
| xmlserialize(content b."LawTitle_x" as varchar2(4000)) as "LawTitle", | |
| b."LawTitle_Kana", | |
| b."LawTitle_Abbrev", | |
| b."LawTitle_AbbrevKana", | |
| xmlserialize(content b."EnactStatement_x" as varchar2(4000)) as "EnactStatement" | |
| -- 子要素 | |
| ,b."Preamble" | |
| ,b."MainProvision" | |
| ,b."SupplProvision" | |
| -- 以下は扱わない。 | |
| ,b."TOC" | |
| ,b."AppdxTable" | |
| ,b."AppdxNote" | |
| ,b."AppdxStyle" | |
| ,b."Appdx" | |
| ,b."AppdxFig" | |
| ,b."AppdxFormat" | |
| from jlaw_data d, | |
| xmltable( | |
| '/Law' passing d.body | |
| columns | |
| "Era" varchar2(8) path '@Era', -- 今の所、Meiji, Taisho, Showa, Heisei, Reiwa | |
| "Lang" varchar2(2) path '@Lang', -- jaまたはen | |
| "LawType" varchar2(20) path '@LawType', -- Constitution, Act, CabinetOrder, ImperialOrder, MinisterialOrdinance, Rule, Misc | |
| "Num" varchar2(8) path '@Num', -- 定義上は数値だが、1_1のような文字列もある | |
| "Year" number path '@Year', | |
| "PromulgateMonth" number path '@PromulgateMonth', | |
| "PromulgateDay" number path '@PromulgateDay', | |
| "LawNum" varchar2(4000) path 'LawNum/text()', | |
| "LawBody" xmltype path 'LawBody' | |
| ) l, | |
| xmltable( | |
| '/LawBody' passing l."LawBody" | |
| columns | |
| "LawTitle_x" xmltype path 'LawTitle/text()', | |
| "LawTitle_Kana" varchar2(4000) path 'LawTitle/@Kana', | |
| "LawTitle_Abbrev" varchar2(4000) path 'LawTitle/@Abbrev', | |
| "LawTitle_AbbrevKana" varchar2(4000) path 'LawTitle/@AbbrevKana', | |
| "EnactStatement_x" xmltype path 'EnactStatement/text()' | |
| -- 処理する子要素 | |
| ,"Preamble" xmltype path 'Preamble' | |
| ,"MainProvision" xmltype path 'MainProvision' | |
| ,"SupplProvision" xmltype path 'SupplProvision' | |
| -- 以下は扱わない。 | |
| ,"TOC" xmltype path 'TOC' | |
| ,"AppdxTable" xmltype path 'AppdxTable' | |
| ,"AppdxNote" xmltype path 'AppdxNote' | |
| ,"AppdxStyle" xmltype path 'AppdxStyle' | |
| ,"Appdx" xmltype path 'Appdx' | |
| ,"AppdxFig" xmltype path 'AppdxFig' | |
| ,"AppdxFormat" xmltype path 'AppdxFormat' | |
| ) b; | |
| /** | |
| * /Law/LawBody/Preamble | |
| */ | |
| create or replace view jlaw_Preamble_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| -- 子要素 | |
| l."Paragraph" | |
| from jlaw_LawBody_xv d, | |
| xmltable( | |
| '/Preamble' passing d."Preamble" | |
| columns | |
| "Paragraph" xmltype path 'Paragraph' | |
| ) l | |
| where d."Preamble" is not null; | |
| /** | |
| * /Law/LawBody/Preamble/Paragraph | |
| */ | |
| create or replace view jlaw_Preamble_Paragraph_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| -- Paragraph | |
| l."Paragraph_Num", | |
| l."OldStyle", | |
| l."OldNum", | |
| l."Paragraph_Hide", | |
| xmlserialize(content l."ParagraphCaption_x" as varchar2(4000)) as "ParagraphCaption", | |
| xmlserialize(content l."ParagraphNum_x" as varchar2(4000)) as "ParagraphNum", | |
| -- Sentence | |
| s."Sentence_Num", | |
| xmlserialize(content s."Sentence_x" as clob) as "Sentence" | |
| ,"AmendProvision" | |
| ,"Class" | |
| ,"Item" | |
| from jlaw_Preamble_xv d, | |
| xmltable( | |
| '/Paragraph' passing d."Paragraph" | |
| columns | |
| "Paragraph_Num" varchar2(8) path '@Num', | |
| "OldStyle" boolean path '@OldStyle', | |
| "OldNum" boolean path '@OldNum', | |
| "Paragraph_Hide" boolean path '@Hide', | |
| "ParagraphCaption_x" xmltype path 'ParagraphCaption/text()', | |
| "ParagraphNum_x" xmltype path 'ParagraphNum/text()', | |
| "ParagraphSentence" xmltype path 'ParagraphSentence', | |
| "AmendProvision" xmltype path 'AmendProvision', | |
| "Class" xmltype path 'Class', | |
| "Item" xmltype path 'Item' | |
| ) l, | |
| xmltable( | |
| '/ParagraphSentence' passing l."ParagraphSentence" | |
| columns | |
| "Sentence_Num" varchar2(8) path '@Num', | |
| "Sentence_x" xmltype path 'Sentence/text()' | |
| ) s | |
| where d."Paragraph" is not null; | |
| /** | |
| * /Law/LawBody/MainProvision | |
| */ | |
| create or replace view jlaw_MainProvision_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| -- 自要素 | |
| l."Extract", | |
| -- 子要素 | |
| l."Part", | |
| l."Chapter", | |
| l."Section", | |
| l."Article", | |
| l."Paragraph" | |
| from jlaw_LawBody_xv d, | |
| xmltable( | |
| '/MainProvision' passing d."MainProvision" | |
| columns | |
| "Extract" boolean path '@Extract', | |
| "Part" xmltype path 'Part', | |
| "Chapter" xmltype path 'Chapter', | |
| "Section" xmltype path 'Section', | |
| "Article" xmltype path 'Article', | |
| "Paragraph" xmltype path 'Paragraph' | |
| ) l | |
| where d."MainProvision" is not null; | |
| /** | |
| * /Law/LawBody/MainProvision/Part | |
| */ | |
| create or replace view jlaw_MainProvision_Part_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| -- 自要素 | |
| l."Part_Num", | |
| l."Part_Delete", | |
| l."Part_Hide", | |
| xmlserialize(content l."PartTitle_x" as varchar2(4000)) as "PartTitle", | |
| -- 子要素 | |
| l."Chapter", | |
| l."Article" | |
| from jlaw_MainProvision_xv d, | |
| xmltable( | |
| '/Part' passing d."Part" | |
| columns | |
| "Part_Num" varchar2(8) path '@Num', | |
| "Part_Delete" boolean path '@Delete', | |
| "Part_Hide" boolean path '@Hide', | |
| "PartTitle_x" xmltype path 'PartTitle/text()', | |
| "Chapter" xmltype path 'Chapter', | |
| "Article" xmltype path 'Article' | |
| ) l | |
| where d."Part" is not null; | |
| /** | |
| * /Law/LawBody/MainProvision/Part/Chapter | |
| */ | |
| create or replace view jlaw_MainProvision_Part_Chapter_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| d."Part_Num", | |
| d."Part_Delete", | |
| d."Part_Hide", | |
| d."PartTitle", | |
| -- 自要素 | |
| l."Chapter_Num", | |
| l."Chapter_Delete", | |
| l."Chapter_Hide", | |
| xmlserialize(content l."ChapterTitle_x" as varchar2(4000)) as "ChapterTitle", | |
| -- 子要素 | |
| l."Section", | |
| l."Article" | |
| from jlaw_MainProvision_Part_xv d, | |
| xmltable( | |
| '/Chapter' passing d."Chapter" | |
| columns | |
| "Chapter_Num" varchar2(8) path '@Num', | |
| "Chapter_Delete" boolean path '@Delete', | |
| "Chapter_Hide" boolean path '@Hide', | |
| "ChapterTitle_x" xmltype path 'ChapterTitle/text()', | |
| "Section" xmltype path 'Section', | |
| "Article" xmltype path 'Article' | |
| ) l | |
| where d."Chapter" is not null; | |
| /** | |
| * /Law/LawBody/MainProvision/Part/Chapter/Section | |
| */ | |
| create or replace view jlaw_MainProvision_Part_Chapter_Section_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| d."Part_Num", | |
| d."Part_Delete", | |
| d."Part_Hide", | |
| d."PartTitle", | |
| d."Chapter_Num", | |
| d."Chapter_Delete", | |
| d."Chapter_Hide", | |
| d."ChapterTitle", | |
| -- 自要素 | |
| l."Section_Num", | |
| l."Section_Delete", | |
| l."Section_Hide", | |
| xmlserialize(content l."SectionTitle_x" as varchar2(4000)) as "SectionTitle", | |
| -- 子要素 | |
| l."Subsection", | |
| l."Article" | |
| from jlaw_MainProvision_Part_Chapter_xv d, | |
| xmltable( | |
| '/Section' passing d."Section" | |
| columns | |
| "Section_Num" varchar2(8) path '@Num', | |
| "Section_Delete" boolean path '@Delete', | |
| "Section_Hide" boolean path '@Hide', | |
| "SectionTitle_x" xmltype path 'SectionTitle/text()', | |
| "Subsection" xmltype path 'Subsection', | |
| "Article" xmltype path 'Article' | |
| -- "Divison" は必ず "Subsection" の下。 | |
| ) l | |
| where d."Section" is not null; | |
| /** | |
| * /Law/LawBody/MainProvision/Part/Chapter/Section/Subsection | |
| */ | |
| create or replace view jlaw_MainProvision_Part_Chapter_Section_Subsection_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| d."Part_Num", | |
| d."Part_Delete", | |
| d."Part_Hide", | |
| d."PartTitle", | |
| d."Chapter_Num", | |
| d."Chapter_Delete", | |
| d."Chapter_Hide", | |
| d."ChapterTitle", | |
| d."Section_Num", | |
| d."Section_Delete", | |
| d."Section_Hide", | |
| d."SectionTitle", | |
| -- 自要素 | |
| l."Subsection_Num", | |
| l."Subsection_Delete", | |
| l."Subsection_Hide", | |
| xmlserialize(content l."SubsectionTitle_x" as varchar2(4000)) as "SubsectionTitle", | |
| -- 子要素 | |
| l."Division", | |
| l."Article" | |
| from jlaw_MainProvision_Part_Chapter_Section_xv d, | |
| xmltable( | |
| '/Subsection' passing d."Subsection" | |
| columns | |
| "Subsection_Num" varchar2(8) path '@Num', | |
| "Subsection_Delete" boolean path '@Delete', | |
| "Subsection_Hide" boolean path '@Hide', | |
| "SubsectionTitle_x" xmltype path 'SubsectionTitle/text()', | |
| "Division" xmltype path 'Division', | |
| "Article" xmltype path 'Article' | |
| ) l | |
| where d."Subsection" is not null; | |
| /** | |
| * /Law/LawBody/MainProvision/Part/Chapter/Section/Subsection/Division | |
| */ | |
| create or replace view jlaw_MainProvision_Part_Chapter_Section_Subsection_Division_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| d."Part_Num", | |
| d."Part_Delete", | |
| d."Part_Hide", | |
| d."PartTitle", | |
| d."Chapter_Num", | |
| d."Chapter_Delete", | |
| d."Chapter_Hide", | |
| d."ChapterTitle", | |
| d."Section_Num", | |
| d."Section_Delete", | |
| d."Section_Hide", | |
| d."SectionTitle", | |
| d."Subsection_Num", | |
| d."Subsection_Delete", | |
| d."Subsection_Hide", | |
| d."SubsectionTitle", | |
| -- 自要素 | |
| l."Division_Num", | |
| l."Division_Delete", | |
| l."Division_Hide", | |
| xmlserialize(content l."DivisionTitle_x" as varchar2(4000)) as "DivisionTitle", | |
| -- 子要素 | |
| l."Article" | |
| from jlaw_MainProvision_Part_Chapter_Section_Subsection_xv d, | |
| xmltable( | |
| '/Division' passing d."Division" | |
| columns | |
| "Division_Num" varchar2(8) path '@Num', | |
| "Division_Delete" boolean path '@Delete', | |
| "Division_Hide" boolean path '@Hide', | |
| "DivisionTitle_x" xmltype path 'DivisionTitle/text()', | |
| "Article" xmltype path 'Article' | |
| ) l | |
| where d."Division" is not null; | |
| /** | |
| * /Law/LawBody/MainProvision/Part/Chapter/Section/Subsection/Division/Article | |
| */ | |
| create or replace view jlaw_MainProvision_Part_Chapter_Section_Subsection_Division_Article_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| d."Part_Num", | |
| d."Part_Delete", | |
| d."Part_Hide", | |
| d."PartTitle", | |
| d."Chapter_Num", | |
| d."Chapter_Delete", | |
| d."Chapter_Hide", | |
| d."ChapterTitle", | |
| d."Section_Num", | |
| d."Section_Delete", | |
| d."Section_Hide", | |
| d."SectionTitle", | |
| d."Subsection_Num", | |
| d."Subsection_Delete", | |
| d."Subsection_Hide", | |
| d."SubsectionTitle", | |
| d."Division_Num", | |
| d."Division_Delete", | |
| d."Division_Hide", | |
| d."DivisionTitle", | |
| -- Article | |
| a."Article_Num", | |
| a."Article_Delete", | |
| a."Article_Hide", | |
| xmlserialize(content a."ArticleTitle_x" as varchar2(4000)) as "ArticleTitle", | |
| xmlserialize(content a."ArticleCaption_x" as varchar2(4000)) as "ArticleCaption", | |
| -- Paragraph | |
| l."Paragraph_Num", | |
| l."OldStyle", | |
| l."OldNum", | |
| l."Paragraph_Hide", | |
| xmlserialize(content l."ParagraphCaption_x" as varchar2(4000)) as "ParagraphCaption", | |
| xmlserialize(content l."ParagraphNum_x" as varchar2(4000)) as "ParagraphNum", | |
| l."AmendProvision", | |
| l."Class", | |
| l."Item", | |
| -- Sentence | |
| s."Sentence_Num", | |
| xmlserialize(content s."Sentence_x" as clob) as "Sentence" | |
| from jlaw_MainProvision_Part_Chapter_Section_Subsection_Division_xv d, | |
| xmltable( | |
| '/Article' passing d."Article" | |
| columns | |
| "Article_Num" varchar2(8) path '@Num', | |
| "Article_Delete" boolean path '@Delete', | |
| "Article_Hide" boolean path '@Hide', | |
| "ArticleTitle_x" xmltype path 'ArticleTitle/text()', | |
| "ArticleCaption_x" xmltype path 'ArticleCaption/text()', | |
| "Paragraph" xmltype path 'Paragraph' | |
| ) a, | |
| xmltable( | |
| '/Paragraph' passing a."Paragraph" | |
| columns | |
| "Paragraph_Num" varchar2(8) path '@Num', | |
| "OldStyle" boolean path '@OldStyle', | |
| "OldNum" boolean path '@OldNum', | |
| "Paragraph_Hide" boolean path '@Hide', | |
| "ParagraphCaption_x" xmltype path 'ParagraphCaption/text()', | |
| "ParagraphNum_x" xmltype path 'ParagraphNum/text()', | |
| "ParagraphSentence" xmltype path 'ParagraphSentence/Sentence', | |
| "AmendProvision" xmltype path 'AmendProvision', | |
| "Class" xmltype path 'Class', | |
| "Item" xmltype path 'Item' | |
| ) l, | |
| xmltable( | |
| '/Sentence' passing l."ParagraphSentence" | |
| columns | |
| "Sentence_Num" varchar2(8) path '@Num', | |
| "Sentence_x" xmltype path 'text()' | |
| ) s | |
| where d."Article" is not null; | |
| /** | |
| * /Law/LawBody/MainProvision/Part/Chapter/Section/Subsection/Article | |
| */ | |
| create or replace view jlaw_MainProvision_Part_Chapter_Section_Subsection_Article_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| d."Part_Num", | |
| d."Part_Delete", | |
| d."Part_Hide", | |
| d."PartTitle", | |
| d."Chapter_Num", | |
| d."Chapter_Delete", | |
| d."Chapter_Hide", | |
| d."ChapterTitle", | |
| d."Section_Num", | |
| d."Section_Delete", | |
| d."Section_Hide", | |
| d."SectionTitle", | |
| d."Subsection_Num", | |
| d."Subsection_Delete", | |
| d."Subsection_Hide", | |
| d."SubsectionTitle", | |
| -- Article | |
| a."Article_Num", | |
| a."Article_Delete", | |
| a."Article_Hide", | |
| xmlserialize(content a."ArticleTitle_x" as varchar2(4000)) as "ArticleTitle", | |
| xmlserialize(content a."ArticleCaption_x" as varchar2(4000)) as "ArticleCaption", | |
| -- Paragraph | |
| l."Paragraph_Num", | |
| l."OldStyle", | |
| l."OldNum", | |
| l."Paragraph_Hide", | |
| xmlserialize(content l."ParagraphCaption_x" as varchar2(4000)) as "ParagraphCaption", | |
| xmlserialize(content l."ParagraphNum_x" as varchar2(4000)) as "ParagraphNum", | |
| l."AmendProvision", | |
| l."Class", | |
| l."Item", | |
| -- Sentence | |
| s."Sentence_Num", | |
| xmlserialize(content s."Sentence_x" as clob) as "Sentence" | |
| from jlaw_MainProvision_Part_Chapter_Section_Subsection_xv d, | |
| xmltable( | |
| '/Article' passing d."Article" | |
| columns | |
| "Article_Num" varchar2(8) path '@Num', | |
| "Article_Delete" boolean path '@Delete', | |
| "Article_Hide" boolean path '@Hide', | |
| "ArticleTitle_x" xmltype path 'ArticleTitle/text()', | |
| "ArticleCaption_x" xmltype path 'ArticleCaption/text()', | |
| "Paragraph" xmltype path 'Paragraph' | |
| ) a, | |
| xmltable( | |
| '/Paragraph' passing a."Paragraph" | |
| columns | |
| "Paragraph_Num" varchar2(8) path '@Num', | |
| "OldStyle" boolean path '@OldStyle', | |
| "OldNum" boolean path '@OldNum', | |
| "Paragraph_Hide" boolean path '@Hide', | |
| "ParagraphCaption_x" xmltype path 'ParagraphCaption/text()', | |
| "ParagraphNum_x" xmltype path 'ParagraphNum/text()', | |
| "ParagraphSentence" xmltype path 'ParagraphSentence/Sentence', | |
| "AmendProvision" xmltype path 'AmendProvision', | |
| "Class" xmltype path 'Class', | |
| "Item" xmltype path 'Item' | |
| ) l, | |
| xmltable( | |
| '/Sentence' passing l."ParagraphSentence" | |
| columns | |
| "Sentence_Num" varchar2(8) path '@Num', | |
| "Sentence_x" xmltype path 'text()' | |
| ) s | |
| where d."Article" is not null; | |
| /** | |
| * /Law/LawBody/MainProvision/Part/Chapter/Section/Article | |
| */ | |
| create or replace view jlaw_MainProvision_Part_Chapter_Section_Article_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| d."Part_Num", | |
| d."Part_Delete", | |
| d."Part_Hide", | |
| d."PartTitle", | |
| d."Chapter_Num", | |
| d."Chapter_Delete", | |
| d."Chapter_Hide", | |
| d."ChapterTitle", | |
| d."Section_Num", | |
| d."Section_Delete", | |
| d."Section_Hide", | |
| d."SectionTitle", | |
| -- Article | |
| a."Article_Num", | |
| a."Article_Delete", | |
| a."Article_Hide", | |
| xmlserialize(content a."ArticleTitle_x" as varchar2(4000)) as "ArticleTitle", | |
| xmlserialize(content a."ArticleCaption_x" as varchar2(4000)) as "ArticleCaption", | |
| -- Paragraph | |
| l."Paragraph_Num", | |
| l."OldStyle", | |
| l."OldNum", | |
| l."Paragraph_Hide", | |
| xmlserialize(content l."ParagraphCaption_x" as varchar2(4000)) as "ParagraphCaption", | |
| xmlserialize(content l."ParagraphNum_x" as varchar2(4000)) as "ParagraphNum", | |
| l."AmendProvision", | |
| l."Class", | |
| l."Item", | |
| -- Sentence | |
| s."Sentence_Num", | |
| xmlserialize(content s."Sentence_x" as clob) as "Sentence" | |
| from jlaw_MainProvision_Part_Chapter_Section_xv d, | |
| xmltable( | |
| '/Article' passing d."Article" | |
| columns | |
| "Article_Num" varchar2(8) path '@Num', | |
| "Article_Delete" boolean path '@Delete', | |
| "Article_Hide" boolean path '@Hide', | |
| "ArticleTitle_x" xmltype path 'ArticleTitle/text()', | |
| "ArticleCaption_x" xmltype path 'ArticleCaption/text()', | |
| "Paragraph" xmltype path 'Paragraph' | |
| ) a, | |
| xmltable( | |
| '/Paragraph' passing a."Paragraph" | |
| columns | |
| "Paragraph_Num" varchar2(8) path '@Num', | |
| "OldStyle" boolean path '@OldStyle', | |
| "OldNum" boolean path '@OldNum', | |
| "Paragraph_Hide" boolean path '@Hide', | |
| "ParagraphCaption_x" xmltype path 'ParagraphCaption/text()', | |
| "ParagraphNum_x" xmltype path 'ParagraphNum/text()', | |
| "ParagraphSentence" xmltype path 'ParagraphSentence/Sentence', | |
| "AmendProvision" xmltype path 'AmendProvision', | |
| "Class" xmltype path 'Class', | |
| "Item" xmltype path 'Item' | |
| ) l, | |
| xmltable( | |
| '/Sentence' passing l."ParagraphSentence" | |
| columns | |
| "Sentence_Num" varchar2(8) path '@Num', | |
| "Sentence_x" xmltype path 'text()' | |
| ) s | |
| where d."Article" is not null; | |
| /** | |
| * /Law/LawBody/MainProvision/Part/Chapter/Article | |
| */ | |
| create or replace view jlaw_MainProvision_Part_Chapter_Article_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| d."Part_Num", | |
| d."Part_Delete", | |
| d."Part_Hide", | |
| d."PartTitle", | |
| d."Chapter_Num", | |
| d."Chapter_Delete", | |
| d."Chapter_Hide", | |
| d."ChapterTitle", | |
| -- Article | |
| a."Article_Num", | |
| a."Article_Delete", | |
| a."Article_Hide", | |
| xmlserialize(content a."ArticleTitle_x" as varchar2(4000)) as "ArticleTitle", | |
| xmlserialize(content a."ArticleCaption_x" as varchar2(4000)) as "ArticleCaption", | |
| -- Paragraph | |
| l."Paragraph_Num", | |
| l."OldStyle", | |
| l."OldNum", | |
| l."Paragraph_Hide", | |
| xmlserialize(content l."ParagraphCaption_x" as varchar2(4000)) as "ParagraphCaption", | |
| xmlserialize(content l."ParagraphNum_x" as varchar2(4000)) as "ParagraphNum", | |
| l."AmendProvision", | |
| l."Class", | |
| l."Item", | |
| -- Sentence | |
| s."Sentence_Num", | |
| xmlserialize(content s."Sentence_x" as clob) as "Sentence" | |
| from jlaw_MainProvision_Part_Chapter_xv d, | |
| xmltable( | |
| '/Article' passing d."Article" | |
| columns | |
| "Article_Num" varchar2(8) path '@Num', | |
| "Article_Delete" boolean path '@Delete', | |
| "Article_Hide" boolean path '@Hide', | |
| "ArticleTitle_x" xmltype path 'ArticleTitle/text()', | |
| "ArticleCaption_x" xmltype path 'ArticleCaption/text()', | |
| "Paragraph" xmltype path 'Paragraph' | |
| ) a, | |
| xmltable( | |
| '/Paragraph' passing a."Paragraph" | |
| columns | |
| "Paragraph_Num" varchar2(8) path '@Num', | |
| "OldStyle" boolean path '@OldStyle', | |
| "OldNum" boolean path '@OldNum', | |
| "Paragraph_Hide" boolean path '@Hide', | |
| "ParagraphCaption_x" xmltype path 'ParagraphCaption/text()', | |
| "ParagraphNum_x" xmltype path 'ParagraphNum/text()', | |
| "ParagraphSentence" xmltype path 'ParagraphSentence/Sentence', | |
| "AmendProvision" xmltype path 'AmendProvision', | |
| "Class" xmltype path 'Class', | |
| "Item" xmltype path 'Item' | |
| ) l, | |
| xmltable( | |
| '/Sentence' passing l."ParagraphSentence" | |
| columns | |
| "Sentence_Num" varchar2(8) path '@Num', | |
| "Sentence_x" xmltype path 'text()' | |
| ) s | |
| where d."Article" is not null; | |
| /** | |
| * /Law/LawBody/MainProvision/Chapter | |
| */ | |
| create or replace view jlaw_MainProvision_Chapter_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| -- 自要素 | |
| l."Chapter_Num", | |
| l."Chapter_Delete", | |
| l."Chapter_Hide", | |
| xmlserialize(content l."ChapterTitle_x" as varchar2(4000)) as "ChapterTitle", | |
| -- 子要素 | |
| l."Section", | |
| l."Article" | |
| from jlaw_MainProvision_xv d, | |
| xmltable( | |
| '/Chapter' passing d."Chapter" | |
| columns | |
| "Chapter_Num" varchar2(8) path '@Num', | |
| "Chapter_Delete" boolean path '@Delete', | |
| "Chapter_Hide" boolean path '@Hide', | |
| "ChapterTitle_x" xmltype path 'ChapterTitle/text()', | |
| "Section" xmltype path 'Section', | |
| "Article" xmltype path 'Article' | |
| ) l | |
| where d."Chapter" is not null; | |
| /** | |
| * /Law/LawBody/MainProvision/Chapter/Section | |
| */ | |
| create or replace view jlaw_MainProvision_Chapter_Section_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| d."Chapter_Num", | |
| d."Chapter_Delete", | |
| d."Chapter_Hide", | |
| d."ChapterTitle", | |
| -- 自要素 | |
| l."Section_Num", | |
| l."Section_Delete", | |
| l."Section_Hide", | |
| xmlserialize(content l."SectionTitle_x" as varchar2(4000)) as "SectionTitle", | |
| -- 子要素 | |
| l."Subsection", | |
| l."Article" | |
| from jlaw_MainProvision_Chapter_xv d, | |
| xmltable( | |
| '/Section' passing d."Section" | |
| columns | |
| "Section_Num" varchar2(8) path '@Num', | |
| "Section_Delete" boolean path '@Delete', | |
| "Section_Hide" boolean path '@Hide', | |
| "SectionTitle_x" xmltype path 'SectionTitle/text()', | |
| "Subsection" xmltype path 'Subsection', | |
| "Article" xmltype path 'Article' | |
| -- "Division" は必ず "Subsection" の下。 | |
| ) l | |
| where d."Section" is not null; | |
| /** | |
| * /Law/LawBody/MainProvision/Part/Chapter/Section/Subsection | |
| */ | |
| create or replace view jlaw_MainProvision_Chapter_Section_Subsection_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| d."Chapter_Num", | |
| d."Chapter_Delete", | |
| d."Chapter_Hide", | |
| d."ChapterTitle", | |
| d."Section_Num", | |
| d."Section_Delete", | |
| d."Section_Hide", | |
| d."SectionTitle", | |
| -- 自要素 | |
| l."Subsection_Num", | |
| l."Subsection_Delete", | |
| l."Subsection_Hide", | |
| xmlserialize(content l."SubsectionTitle_x" as varchar2(4000)) as "SubsectionTitle", | |
| -- 子要素 | |
| l."Division", | |
| l."Article" | |
| from jlaw_MainProvision_Chapter_Section_xv d, | |
| xmltable( | |
| '/Subsection' passing d."Subsection" | |
| columns | |
| "Subsection_Num" varchar2(8) path '@Num', | |
| "Subsection_Delete" boolean path '@Delete', | |
| "Subsection_Hide" boolean path '@Hide', | |
| "SubsectionTitle_x" xmltype path 'SubsectionTitle/text()', | |
| "Division" xmltype path 'Division', | |
| "Article" xmltype path 'Article' | |
| ) l | |
| where d."Subsection" is not null; | |
| /** | |
| * /Law/LawBody/MainProvision/Chapter/Section/Subsection/Division | |
| */ | |
| create or replace view jlaw_MainProvision_Chapter_Section_Subsection_Division_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| d."Chapter_Num", | |
| d."Chapter_Delete", | |
| d."Chapter_Hide", | |
| d."ChapterTitle", | |
| d."Section_Num", | |
| d."Section_Delete", | |
| d."Section_Hide", | |
| d."SectionTitle", | |
| d."Subsection_Num", | |
| d."Subsection_Delete", | |
| d."Subsection_Hide", | |
| d."SubsectionTitle", | |
| -- 自要素 | |
| l."Division_Num", | |
| l."Division_Delete", | |
| l."Division_Hide", | |
| xmlserialize(content l."DivisionTitle_x" as varchar2(4000)) as "DivisionTitle", | |
| -- 子要素 | |
| l."Article" | |
| from jlaw_MainProvision_Chapter_Section_Subsection_xv d, | |
| xmltable( | |
| '/Division' passing d."Division" | |
| columns | |
| "Division_Num" varchar2(8) path '@Num', | |
| "Division_Delete" boolean path '@Delete', | |
| "Division_Hide" boolean path '@Hide', | |
| "DivisionTitle_x" xmltype path 'DivisionTitle/text()', | |
| "Article" xmltype path 'Article' | |
| ) l | |
| where d."Division" is not null; | |
| /** | |
| * /Law/LawBody/MainProvision/Chapter/Section/Subsection/Division/Article | |
| */ | |
| create or replace view jlaw_MainProvision_Chapter_Section_Subsection_Division_Article_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| d."Chapter_Num", | |
| d."Chapter_Delete", | |
| d."Chapter_Hide", | |
| d."ChapterTitle", | |
| d."Section_Num", | |
| d."Section_Delete", | |
| d."Section_Hide", | |
| d."SectionTitle", | |
| d."Subsection_Num", | |
| d."Subsection_Delete", | |
| d."Subsection_Hide", | |
| d."SubsectionTitle", | |
| d."Division_Num", | |
| d."Division_Delete", | |
| d."Division_Hide", | |
| d."DivisionTitle", | |
| -- Article | |
| a."Article_Num", | |
| a."Article_Delete", | |
| a."Article_Hide", | |
| xmlserialize(content a."ArticleTitle_x" as varchar2(4000)) as "ArticleTitle", | |
| xmlserialize(content a."ArticleCaption_x" as varchar2(4000)) as "ArticleCaption", | |
| -- Paragraph | |
| l."Paragraph_Num", | |
| l."OldStyle", | |
| l."OldNum", | |
| l."Paragraph_Hide", | |
| xmlserialize(content l."ParagraphCaption_x" as varchar2(4000)) as "ParagraphCaption", | |
| xmlserialize(content l."ParagraphNum_x" as varchar2(4000)) as "ParagraphNum", | |
| l."AmendProvision", | |
| l."Class", | |
| l."Item", | |
| -- Sentence | |
| s."Sentence_Num", | |
| xmlserialize(content s."Sentence_x" as clob) as "Sentence" | |
| from jlaw_MainProvision_Chapter_Section_Subsection_Division_xv d, | |
| xmltable( | |
| '/Article' passing d."Article" | |
| columns | |
| "Article_Num" varchar2(8) path '@Num', | |
| "Article_Delete" boolean path '@Delete', | |
| "Article_Hide" boolean path '@Hide', | |
| "ArticleTitle_x" xmltype path 'ArticleTitle/text()', | |
| "ArticleCaption_x" xmltype path 'ArticleCaption/text()', | |
| "Paragraph" xmltype path 'Paragraph' | |
| ) a, | |
| xmltable( | |
| '/Paragraph' passing a."Paragraph" | |
| columns | |
| "Paragraph_Num" varchar2(8) path '@Num', | |
| "OldStyle" boolean path '@OldStyle', | |
| "OldNum" boolean path '@OldNum', | |
| "Paragraph_Hide" boolean path '@Hide', | |
| "ParagraphCaption_x" xmltype path 'ParagraphCaption/text()', | |
| "ParagraphNum_x" xmltype path 'ParagraphNum/text()', | |
| "ParagraphSentence" xmltype path 'ParagraphSentence/Sentence', | |
| "AmendProvision" xmltype path 'AmendProvision', | |
| "Class" xmltype path 'Class', | |
| "Item" xmltype path 'Item' | |
| ) l, | |
| xmltable( | |
| '/Sentence' passing l."ParagraphSentence" | |
| columns | |
| "Sentence_Num" varchar2(8) path '@Num', | |
| "Sentence_x" xmltype path 'text()' | |
| ) s | |
| where d."Article" is not null; | |
| /** | |
| * /Law/LawBody/MainProvision/Chapter/Section/Subsection/Article | |
| */ | |
| create or replace view jlaw_MainProvision_Chapter_Section_Subsection_Article_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| d."Chapter_Num", | |
| d."Chapter_Delete", | |
| d."Chapter_Hide", | |
| d."ChapterTitle", | |
| d."Section_Num", | |
| d."Section_Delete", | |
| d."Section_Hide", | |
| d."SectionTitle", | |
| d."Subsection_Num", | |
| d."Subsection_Delete", | |
| d."Subsection_Hide", | |
| d."SubsectionTitle", | |
| -- Article | |
| a."Article_Num", | |
| a."Article_Delete", | |
| a."Article_Hide", | |
| xmlserialize(content a."ArticleTitle_x" as varchar2(4000)) as "ArticleTitle", | |
| xmlserialize(content a."ArticleCaption_x" as varchar2(4000)) as "ArticleCaption", | |
| -- Paragraph | |
| l."Paragraph_Num", | |
| l."OldStyle", | |
| l."OldNum", | |
| l."Paragraph_Hide", | |
| xmlserialize(content l."ParagraphCaption_x" as varchar2(4000)) as "ParagraphCaption", | |
| xmlserialize(content l."ParagraphNum_x" as varchar2(4000)) as "ParagraphNum", | |
| l."AmendProvision", | |
| l."Class", | |
| l."Item", | |
| -- Sentence | |
| s."Sentence_Num", | |
| xmlserialize(content s."Sentence_x" as clob) as "Sentence" | |
| from jlaw_MainProvision_Chapter_Section_Subsection_xv d, | |
| xmltable( | |
| '/Article' passing d."Article" | |
| columns | |
| "Article_Num" varchar2(8) path '@Num', | |
| "Article_Delete" boolean path '@Delete', | |
| "Article_Hide" boolean path '@Hide', | |
| "ArticleTitle_x" xmltype path 'ArticleTitle/text()', | |
| "ArticleCaption_x" xmltype path 'ArticleCaption/text()', | |
| "Paragraph" xmltype path 'Paragraph' | |
| ) a, | |
| xmltable( | |
| '/Paragraph' passing a."Paragraph" | |
| columns | |
| "Paragraph_Num" varchar2(8) path '@Num', | |
| "OldStyle" boolean path '@OldStyle', | |
| "OldNum" boolean path '@OldNum', | |
| "Paragraph_Hide" boolean path '@Hide', | |
| "ParagraphCaption_x" xmltype path 'ParagraphCaption/text()', | |
| "ParagraphNum_x" xmltype path 'ParagraphNum/text()', | |
| "ParagraphSentence" xmltype path 'ParagraphSentence/Sentence', | |
| "AmendProvision" xmltype path 'AmendProvision', | |
| "Class" xmltype path 'Class', | |
| "Item" xmltype path 'Item' | |
| ) l, | |
| xmltable( | |
| '/Sentence' passing l."ParagraphSentence" | |
| columns | |
| "Sentence_Num" varchar2(8) path '@Num', | |
| "Sentence_x" xmltype path 'text()' | |
| ) s | |
| where d."Article" is not null; | |
| /** | |
| * /Law/LawBody/MainProvision/Chapter/Section/Article | |
| */ | |
| create or replace view jlaw_MainProvision_Chapter_Section_Article_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| d."Chapter_Num", | |
| d."Chapter_Delete", | |
| d."Chapter_Hide", | |
| d."ChapterTitle", | |
| d."Section_Num", | |
| d."Section_Delete", | |
| d."Section_Hide", | |
| d."SectionTitle", | |
| -- Article | |
| a."Article_Num", | |
| a."Article_Delete", | |
| a."Article_Hide", | |
| xmlserialize(content a."ArticleTitle_x" as varchar2(4000)) as "ArticleTitle", | |
| xmlserialize(content a."ArticleCaption_x" as varchar2(4000)) as "ArticleCaption", | |
| -- Paragraph | |
| l."Paragraph_Num", | |
| l."OldStyle", | |
| l."OldNum", | |
| l."Paragraph_Hide", | |
| xmlserialize(content l."ParagraphCaption_x" as varchar2(4000)) as "ParagraphCaption", | |
| xmlserialize(content l."ParagraphNum_x" as varchar2(4000)) as "ParagraphNum", | |
| l."AmendProvision", | |
| l."Class", | |
| l."Item", | |
| -- Sentence | |
| s."Sentence_Num", | |
| xmlserialize(content s."Sentence_x" as clob) as "Sentence" | |
| from jlaw_MainProvision_Chapter_Section_xv d, | |
| xmltable( | |
| '/Article' passing d."Article" | |
| columns | |
| "Article_Num" varchar2(8) path '@Num', | |
| "Article_Delete" boolean path '@Delete', | |
| "Article_Hide" boolean path '@Hide', | |
| "ArticleTitle_x" xmltype path 'ArticleTitle/text()', | |
| "ArticleCaption_x" xmltype path 'ArticleCaption/text()', | |
| "Paragraph" xmltype path 'Paragraph' | |
| ) a, | |
| xmltable( | |
| '/Paragraph' passing a."Paragraph" | |
| columns | |
| "Paragraph_Num" varchar2(8) path '@Num', | |
| "OldStyle" boolean path '@OldStyle', | |
| "OldNum" boolean path '@OldNum', | |
| "Paragraph_Hide" boolean path '@Hide', | |
| "ParagraphCaption_x" xmltype path 'ParagraphCaption/text()', | |
| "ParagraphNum_x" xmltype path 'ParagraphNum/text()', | |
| "ParagraphSentence" xmltype path 'ParagraphSentence/Sentence', | |
| "AmendProvision" xmltype path 'AmendProvision', | |
| "Class" xmltype path 'Class', | |
| "Item" xmltype path 'Item' | |
| ) l, | |
| xmltable( | |
| '/Sentence' passing l."ParagraphSentence" | |
| columns | |
| "Sentence_Num" varchar2(8) path '@Num', | |
| "Sentence_x" xmltype path 'text()' | |
| ) s | |
| where d."Article" is not null; | |
| /** | |
| * /Law/LawBody/MainProvision/Chapter/Article | |
| */ | |
| create or replace view jlaw_MainProvision_Chapter_Article_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| d."Chapter_Num", | |
| d."Chapter_Delete", | |
| d."Chapter_Hide", | |
| d."ChapterTitle", | |
| -- Article | |
| a."Article_Num", | |
| a."Article_Delete", | |
| a."Article_Hide", | |
| xmlserialize(content a."ArticleTitle_x" as varchar2(4000)) as "ArticleTitle", | |
| xmlserialize(content a."ArticleCaption_x" as varchar2(4000)) as "ArticleCaption", | |
| -- Paragraph | |
| l."Paragraph_Num", | |
| l."OldStyle", | |
| l."OldNum", | |
| l."Paragraph_Hide", | |
| xmlserialize(content l."ParagraphCaption_x" as varchar2(4000)) as "ParagraphCaption", | |
| xmlserialize(content l."ParagraphNum_x" as varchar2(4000)) as "ParagraphNum", | |
| l."AmendProvision", | |
| l."Class", | |
| l."Item", | |
| -- Sentence | |
| s."Sentence_Num", | |
| xmlserialize(content s."Sentence_x" as clob) as "Sentence" | |
| from jlaw_MainProvision_Chapter_xv d, | |
| xmltable( | |
| '/Article' passing d."Article" | |
| columns | |
| "Article_Num" varchar2(8) path '@Num', | |
| "Article_Delete" boolean path '@Delete', | |
| "Article_Hide" boolean path '@Hide', | |
| "ArticleTitle_x" xmltype path 'ArticleTitle/text()', | |
| "ArticleCaption_x" xmltype path 'ArticleCaption/text()', | |
| "Paragraph" xmltype path 'Paragraph' | |
| ) a, | |
| xmltable( | |
| '/Paragraph' passing a."Paragraph" | |
| columns | |
| "Paragraph_Num" varchar2(8) path '@Num', | |
| "OldStyle" boolean path '@OldStyle', | |
| "OldNum" boolean path '@OldNum', | |
| "Paragraph_Hide" boolean path '@Hide', | |
| "ParagraphCaption_x" xmltype path 'ParagraphCaption/text()', | |
| "ParagraphNum_x" xmltype path 'ParagraphNum/text()', | |
| "ParagraphSentence" xmltype path 'ParagraphSentence/Sentence', | |
| "AmendProvision" xmltype path 'AmendProvision', | |
| "Class" xmltype path 'Class', | |
| "Item" xmltype path 'Item' | |
| ) l, | |
| xmltable( | |
| '/Sentence' passing l."ParagraphSentence" | |
| columns | |
| "Sentence_Num" varchar2(8) path '@Num', | |
| "Sentence_x" xmltype path 'text()' | |
| ) s | |
| where d."Article" is not null; | |
| /** | |
| * /Law/LawBody/MainProvision/Section | |
| */ | |
| create or replace view jlaw_MainProvision_Section_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| -- 自要素 | |
| l."Section_Num", | |
| l."Section_Delete", | |
| l."Section_Hide", | |
| xmlserialize(content l."SectionTitle_x" as varchar2(4000)) as "SectionTitle", | |
| -- 子要素 | |
| l."Subsection", | |
| l."Division", | |
| l."Article" | |
| from jlaw_MainProvision_xv d, | |
| xmltable( | |
| '/Section' passing d."Section" | |
| columns | |
| "Section_Num" varchar2(8) path '@Num', | |
| "Section_Delete" boolean path '@Delete', | |
| "Section_Hide" boolean path '@Hide', | |
| "SectionTitle_x" xmltype path 'SectionTitle/text()', | |
| "Subsection" xmltype path 'Subsection', | |
| "Division" xmltype path 'Division', | |
| "Article" xmltype path 'Article' -- 直下にあるのはArticleのみ。 | |
| ) l | |
| where d."Section" is not null; | |
| /** | |
| * /Law/LawBody/MainProvision/Section/Article | |
| */ | |
| create or replace view jlaw_MainProvision_Section_Article_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| d."Section_Num", | |
| d."Section_Delete", | |
| d."Section_Hide", | |
| d."SectionTitle", | |
| -- Article | |
| a."Article_Num", | |
| a."Article_Delete", | |
| a."Article_Hide", | |
| xmlserialize(content a."ArticleTitle_x" as varchar2(4000)) as "ArticleTitle", | |
| xmlserialize(content a."ArticleCaption_x" as varchar2(4000)) as "ArticleCaption", | |
| -- Paragraph | |
| l."Paragraph_Num", | |
| l."OldStyle", | |
| l."OldNum", | |
| l."Paragraph_Hide", | |
| xmlserialize(content l."ParagraphCaption_x" as varchar2(4000)) as "ParagraphCaption", | |
| xmlserialize(content l."ParagraphNum_x" as varchar2(4000)) as "ParagraphNum", | |
| l."AmendProvision", | |
| l."Class", | |
| l."Item", | |
| -- Sentence | |
| s."Sentence_Num", | |
| xmlserialize(content s."Sentence_x" as clob) as "Sentence" | |
| from jlaw_MainProvision_Section_xv d, | |
| xmltable( | |
| '/Article' passing d."Article" | |
| columns | |
| "Article_Num" varchar2(8) path '@Num', | |
| "Article_Delete" boolean path '@Delete', | |
| "Article_Hide" boolean path '@Hide', | |
| "ArticleTitle_x" xmltype path 'ArticleTitle/text()', | |
| "ArticleCaption_x" xmltype path 'ArticleCaption/text()', | |
| "Paragraph" xmltype path 'Paragraph' | |
| ) a, | |
| xmltable( | |
| '/Paragraph' passing a."Paragraph" | |
| columns | |
| "Paragraph_Num" varchar2(8) path '@Num', | |
| "OldStyle" boolean path '@OldStyle', | |
| "OldNum" boolean path '@OldNum', | |
| "Paragraph_Hide" boolean path '@Hide', | |
| "ParagraphCaption_x" xmltype path 'ParagraphCaption/text()', | |
| "ParagraphNum_x" xmltype path 'ParagraphNum/text()', | |
| "ParagraphSentence" xmltype path 'ParagraphSentence/Sentence', | |
| "AmendProvision" xmltype path 'AmendProvision', | |
| "Class" xmltype path 'Class', | |
| "Item" xmltype path 'Item' | |
| ) l, | |
| xmltable( | |
| '/Sentence' passing l."ParagraphSentence" | |
| columns | |
| "Sentence_Num" varchar2(8) path '@Num', | |
| "Sentence_x" xmltype path 'text()' | |
| ) s | |
| where d."Article" is not null; | |
| /** | |
| * /Law/LawBody/MainProvision/Article | |
| */ | |
| create or replace view jlaw_MainProvision_Article_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| -- Article | |
| a."Article_Num", | |
| xmlserialize(content a."ArticleTitle_x" as varchar2(4000)) as "ArticleTitle", | |
| xmlserialize(content a."ArticleCaption_x" as varchar2(4000)) as "ArticleCaption", | |
| -- Paragraph | |
| l."Paragraph_Num", | |
| l."OldStyle", | |
| l."OldNum", | |
| l."Paragraph_Hide", | |
| xmlserialize(content l."ParagraphCaption_x" as varchar2(4000)) as "ParagraphCaption", | |
| xmlserialize(content l."ParagraphNum_x" as varchar2(4000)) as "ParagraphNum", | |
| l."AmendProvision", | |
| l."Class", | |
| l."Item", | |
| -- Sentence | |
| s."Sentence_Num", | |
| xmlserialize(content s."Sentence_x" as clob) as "Sentence" | |
| from jlaw_MainProvision_xv d, | |
| xmltable( | |
| '/Article' passing d."Article" | |
| columns | |
| "Article_Num" varchar2(8) path '@Num', | |
| "Article_Delete" boolean path '@Delete', | |
| "Article_Hide" boolean path '@Hide', | |
| "ArticleTitle_x" xmltype path 'ArticleTitle/text()', | |
| "ArticleCaption_x" xmltype path 'ArticleCaption/text()', | |
| "Paragraph" xmltype path 'Paragraph' | |
| ) a, | |
| xmltable( | |
| '/Paragraph' passing a."Paragraph" | |
| columns | |
| "Paragraph_Num" varchar2(8) path '@Num', | |
| "OldStyle" boolean path '@OldStyle', | |
| "OldNum" boolean path '@OldNum', | |
| "Paragraph_Hide" boolean path '@Hide', | |
| "ParagraphCaption_x" xmltype path 'ParagraphCaption/text()', | |
| "ParagraphNum_x" xmltype path 'ParagraphNum/text()', | |
| "ParagraphSentence" xmltype path 'ParagraphSentence/Sentence', | |
| "AmendProvision" xmltype path 'AmendProvision', | |
| "Class" xmltype path 'Class', | |
| "Item" xmltype path 'Item' | |
| ) l, | |
| xmltable( | |
| '/Sentence' passing l."ParagraphSentence" | |
| columns | |
| "Sentence_Num" varchar2(8) path '@Num', | |
| "Sentence_x" xmltype path 'text()' | |
| ) s | |
| where d."Article" is not null; | |
| /** | |
| * /Law/LawBody/MainProvision/Paragraph | |
| */ | |
| create or replace view jlaw_MainProvision_Paragraph_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| -- Paragraph | |
| l."Paragraph_Num", | |
| l."OldStyle", | |
| l."OldNum", | |
| l."Paragraph_Hide", | |
| xmlserialize(content l."ParagraphCaption_x" as varchar2(4000)) as "ParagraphCaption", | |
| xmlserialize(content l."ParagraphNum_x" as varchar2(4000)) as "ParagraphNum", | |
| l."AmendProvision", | |
| l."Class", | |
| l."Item", | |
| -- Sentence | |
| s."Sentence_Num", | |
| xmlserialize(content s."Sentence_x" as clob) as "Sentence" | |
| from jlaw_MainProvision_xv d, | |
| xmltable( | |
| '/Paragraph' passing d."Paragraph" | |
| columns | |
| "Paragraph_Num" varchar2(8) path '@Num', | |
| "OldStyle" boolean path '@OldStyle', | |
| "OldNum" boolean path '@OldNum', | |
| "Paragraph_Hide" boolean path '@Hide', | |
| "ParagraphCaption_x" xmltype path 'ParagraphCaption/text()', | |
| "ParagraphNum_x" xmltype path 'ParagraphNum/text()', | |
| "ParagraphSentence" xmltype path 'ParagraphSentence/Sentence', | |
| "AmendProvision" xmltype path 'AmendProvision', | |
| "Class" xmltype path 'Class', | |
| "Item" xmltype path 'Item' | |
| ) l, | |
| xmltable( | |
| '/Sentence' passing l."ParagraphSentence" | |
| columns | |
| "Sentence_Num" varchar2(8) path '@Num', | |
| "Sentence_x" xmltype path 'text()' | |
| ) s | |
| where d."Paragraph" is not null; | |
| /** | |
| * /Law/LawBody/SupplProvision | |
| * | |
| * ビューを作成する対象は、Chapter、Article、Paragraphに限定する。 | |
| */ | |
| create or replace view jlaw_SupplProvision_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| -- 自要素 | |
| l."Suppl_Extract", | |
| l."Suppl_Type", | |
| l."Suppl_AmendLawNum", | |
| xmlserialize(content l."SupplProvisionLabel_x" as varchar2(4000)) as "SupplProvisionLabel", | |
| -- 子要素 | |
| l."Chapter", | |
| l."Article", | |
| l."Paragraph", | |
| l."SupplProvisionAppdxTable", | |
| l."SupplProvisionAppdxStyle", | |
| l."SupplProvisionAppdx" | |
| from jlaw_LawBody_xv d, | |
| xmltable( | |
| '/SupplProvision' passing d."SupplProvision" | |
| columns | |
| "Suppl_Extract" boolean path '@Extract', | |
| "Suppl_Type" varchar2(8) path '@Type', | |
| "Suppl_AmendLawNum" varchar2(4000) path '@AmendLawNum', | |
| "SupplProvisionLabel_x" xmltype path 'SupplProvisionLabel/text()', | |
| "Chapter" xmltype path 'Chapter', | |
| "Article" xmltype path 'Article', | |
| "Paragraph" xmltype path 'Paragraph', | |
| "SupplProvisionAppdxTable" xmltype path 'SupplProvisionAppdxTable', | |
| "SupplProvisionAppdxStyle" xmltype path 'SupplProvisionAppdxStyle', | |
| "SupplProvisionAppdx" xmltype path 'SupplProvisionAppdx' | |
| ) l | |
| where d."SupplProvision" is not null; | |
| /** | |
| * /Law/LawBody/SupplProvision/Chapter | |
| * | |
| * Chapterの直下はArticleのみ | |
| */ | |
| create or replace view jlaw_SupplProvision_Chapter_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| d."Suppl_Extract", | |
| d."Suppl_Type", | |
| d."Suppl_AmendLawNum", | |
| d."SupplProvisionLabel", | |
| -- 自要素 | |
| l."Chapter_Num", | |
| l."Chapter_Delete", | |
| l."Chapter_Hide", | |
| xmlserialize(content l."ChapterTitle_x" as varchar2(4000)) as "ChapterTitle", | |
| -- 子要素 | |
| l."Article" | |
| from jlaw_SupplProvision_xv d, | |
| xmltable( | |
| '/Chapter' passing d."Chapter" | |
| columns | |
| "Chapter_Num" varchar2(8) path '@Num', | |
| "Chapter_Delete" boolean path '@Delete', | |
| "Chapter_Hide" boolean path '@Hide', | |
| "ChapterTitle_x" xmltype path 'ChapterTitle/text()', | |
| "Article" xmltype path 'Article' | |
| ) l | |
| where d."Chapter" is not null; | |
| /** | |
| * /Law/LawBody/SupplProvision/Chapter/Article | |
| */ | |
| create or replace view jlaw_SupplProvision_Chapter_Article_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| d."Suppl_Extract", | |
| d."Suppl_Type", | |
| d."Suppl_AmendLawNum", | |
| d."SupplProvisionLabel", | |
| d."Chapter_Num", | |
| d."Chapter_Delete", | |
| d."Chapter_Hide", | |
| d."ChapterTitle", | |
| -- Article | |
| a."Article_Num", | |
| a."Article_Delete", | |
| a."Article_Hide", | |
| xmlserialize(content a."ArticleTitle_x" as varchar2(4000)) as "ArticleTitle", | |
| xmlserialize(content a."ArticleCaption_x" as varchar2(4000)) as "ArticleCaption", | |
| -- Paragraph | |
| l."Paragraph_Num", | |
| l."OldStyle", | |
| l."OldNum", | |
| l."Paragraph_Hide", | |
| xmlserialize(content l."ParagraphCaption_x" as varchar2(4000)) as "ParagraphCaption", | |
| xmlserialize(content l."ParagraphNum_x" as varchar2(4000)) as "ParagraphNum", | |
| l."AmendProvision", | |
| l."Class", | |
| l."Item", | |
| -- Sentence | |
| s."Sentence_Num", | |
| xmlserialize(content s."Sentence_x" as clob) as "Sentence" | |
| from jlaw_SupplProvision_Chapter_xv d, | |
| xmltable( | |
| '/Article' passing d."Article" | |
| columns | |
| "Article_Num" varchar2(8) path '@Num', | |
| "Article_Delete" boolean path '@Delete', | |
| "Article_Hide" boolean path '@Hide', | |
| "ArticleTitle_x" xmltype path 'ArticleTitle/text()', | |
| "ArticleCaption_x" xmltype path 'ArticleCaption/text()', | |
| "Paragraph" xmltype path 'Paragraph' | |
| ) a, | |
| xmltable( | |
| '/Paragraph' passing a."Paragraph" | |
| columns | |
| "Paragraph_Num" varchar2(8) path '@Num', | |
| "OldStyle" boolean path '@OldStyle', | |
| "OldNum" boolean path '@OldNum', | |
| "Paragraph_Hide" boolean path '@Hide', | |
| "ParagraphCaption_x" xmltype path 'ParagraphCaption/text()', | |
| "ParagraphNum_x" xmltype path 'ParagraphNum/text()', | |
| "ParagraphSentence" xmltype path 'ParagraphSentence/Sentence', | |
| "AmendProvision" xmltype path 'AmendProvision', | |
| "Class" xmltype path 'Class', | |
| "Item" xmltype path 'Item' | |
| ) l, | |
| xmltable( | |
| '/Sentence' passing l."ParagraphSentence" | |
| columns | |
| "Sentence_Num" varchar2(8) path '@Num', | |
| "Sentence_x" xmltype path 'text()' | |
| ) s | |
| where d."Article" is not null; | |
| /** | |
| * /Law/LawBody/SupplProvision/Article | |
| */ | |
| create or replace view jlaw_SupplProvision_Article_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| d."Suppl_Extract", | |
| d."Suppl_Type", | |
| d."Suppl_AmendLawNum", | |
| d."SupplProvisionLabel", | |
| -- Article | |
| a."Article_Num", | |
| a."Article_Delete", | |
| a."Article_Hide", | |
| xmlserialize(content a."ArticleTitle_x" as varchar2(4000)) as "ArticleTitle", | |
| xmlserialize(content a."ArticleCaption_x" as varchar2(4000)) as "ArticleCaption", | |
| -- Paragraph | |
| l."Paragraph_Num", | |
| l."OldStyle", | |
| l."OldNum", | |
| l."Paragraph_Hide", | |
| xmlserialize(content l."ParagraphCaption_x" as varchar2(4000)) as "ParagraphCaption", | |
| xmlserialize(content l."ParagraphNum_x" as varchar2(4000)) as "ParagraphNum", | |
| l."AmendProvision", | |
| l."Class", | |
| l."Item", | |
| -- Sentence | |
| s."Sentence_Num", | |
| xmlserialize(content s."Sentence_x" as clob) as "Sentence" | |
| from jlaw_SupplProvision_xv d, | |
| xmltable( | |
| '/Article' passing d."Article" | |
| columns | |
| "Article_Num" varchar2(8) path '@Num', | |
| "Article_Delete" boolean path '@Delete', | |
| "Article_Hide" boolean path '@Hide', | |
| "ArticleTitle_x" xmltype path 'ArticleTitle/text()', | |
| "ArticleCaption_x" xmltype path 'ArticleCaption/text()', | |
| "Paragraph" xmltype path 'Paragraph' | |
| ) a, | |
| xmltable( | |
| '/Paragraph' passing a."Paragraph" | |
| columns | |
| "Paragraph_Num" varchar2(8) path '@Num', | |
| "OldStyle" boolean path '@OldStyle', | |
| "OldNum" boolean path '@OldNum', | |
| "Paragraph_Hide" boolean path '@Hide', | |
| "ParagraphCaption_x" xmltype path 'ParagraphCaption/text()', | |
| "ParagraphNum_x" xmltype path 'ParagraphNum/text()', | |
| "ParagraphSentence" xmltype path 'ParagraphSentence/Sentence', | |
| "AmendProvision" xmltype path 'AmendProvision', | |
| "Class" xmltype path 'Class', | |
| "Item" xmltype path 'Item' | |
| ) l, | |
| xmltable( | |
| '/Sentence' passing l."ParagraphSentence" | |
| columns | |
| "Sentence_Num" varchar2(8) path '@Num', | |
| "Sentence_x" xmltype path 'text()' | |
| ) s | |
| where d."Article" is not null; | |
| /** | |
| * /Law/LawBody/SupplProvision/Paragraph | |
| */ | |
| create or replace view jlaw_SupplProvision_Paragraph_xv as | |
| select | |
| -- 親要素 | |
| d.id, | |
| d.law_id, | |
| d."Era", | |
| d."Lang", | |
| d."LawType", | |
| d."Root_Num", | |
| d."Year", | |
| d."PromulgateMonth", | |
| d."PromulgateDay", | |
| d."LawNum", | |
| d."LawTitle", | |
| d."LawTitle_Kana", | |
| d."Suppl_Extract", | |
| d."Suppl_Type", | |
| d."Suppl_AmendLawNum", | |
| d."SupplProvisionLabel", | |
| -- Paragraph | |
| l."Paragraph_Num", | |
| l."OldStyle", | |
| l."OldNum", | |
| l."Paragraph_Hide", | |
| xmlserialize(content l."ParagraphCaption_x" as varchar2(4000)) as "ParagraphCaption", | |
| xmlserialize(content l."ParagraphNum_x" as varchar2(4000)) as "ParagraphNum", | |
| l."AmendProvision", | |
| l."Class", | |
| l."Item", | |
| -- Sentence | |
| s."Sentence_Num", | |
| xmlserialize(content s."Sentence_x" as clob) as "Sentence" | |
| from jlaw_SupplProvision_xv d, | |
| xmltable( | |
| '/Paragraph' passing d."Paragraph" | |
| columns | |
| "Paragraph_Num" varchar2(8) path '@Num', | |
| "OldStyle" boolean path '@OldStyle', | |
| "OldNum" boolean path '@OldNum', | |
| "Paragraph_Hide" boolean path '@Hide', | |
| "ParagraphCaption_x" xmltype path 'ParagraphCaption/text()', | |
| "ParagraphNum_x" xmltype path 'ParagraphNum/text()', | |
| "ParagraphSentence" xmltype path 'ParagraphSentence/Sentence', | |
| "AmendProvision" xmltype path 'AmendProvision', | |
| "Class" xmltype path 'Class', | |
| "Item" xmltype path 'Item' | |
| ) l, | |
| xmltable( | |
| '/Sentence' passing l."ParagraphSentence" | |
| columns | |
| "Sentence_Num" varchar2(8) path '@Num', | |
| "Sentence_x" xmltype path 'text()' | |
| ) s | |
| where d."Paragraph" is not null; | |
| /** | |
| * 法令XMLのユニオン・ビュー | |
| */ | |
| /* 前文 */ | |
| create or replace view jlaw_law_preamble_xv | |
| as | |
| select | |
| id, law_id, "Era", "Lang", "LawType", "Root_Num", "Year", "PromulgateMonth", "PromulgateDay", "LawNum", "LawTitle", "LawTitle_Kana", "Paragraph_Num", "ParagraphCaption", "ParagraphNum", "Sentence_Num", "Sentence" | |
| from JLAW_PREAMBLE_PARAGRAPH_XV; | |
| /* 主要条項 */ | |
| create or replace view jlaw_law_mainprovision_xv | |
| as | |
| select | |
| id, law_id, "Era", "Lang", "LawType", "Root_Num", "Year", "PromulgateMonth", "PromulgateDay", "LawNum", "LawTitle", "LawTitle_Kana", | |
| "Part_Num", "PartTitle", "Chapter_Num", "ChapterTitle", "Section_Num", "SectionTitle", "Subsection_Num", "SubsectionTitle", "Division_Num", "DivisionTitle", | |
| "Article_Num", "ArticleTitle", "Paragraph_Num", "ParagraphCaption", "ParagraphNum", "Sentence_Num", "Sentence" | |
| from JLAW_MAINPROVISION_PART_CHAPTER_SECTION_SUBSECTION_DIVISION_ARTICLE_XV | |
| union all | |
| select | |
| id, law_id, "Era", "Lang", "LawType", "Root_Num", "Year", "PromulgateMonth", "PromulgateDay", "LawNum", "LawTitle", "LawTitle_Kana", | |
| "Part_Num", "PartTitle", "Chapter_Num", "ChapterTitle", "Section_Num", "SectionTitle", "Subsection_Num", "SubsectionTitle", null "Division_Num", null "DivisionTitle", | |
| "Article_Num", "ArticleTitle", "Paragraph_Num", "ParagraphCaption", "ParagraphNum", "Sentence_Num", "Sentence" | |
| from JLAW_MAINPROVISION_PART_CHAPTER_SECTION_SUBSECTION_ARTICLE_XV | |
| union all | |
| select | |
| id, law_id, "Era", "Lang", "LawType", "Root_Num", "Year", "PromulgateMonth", "PromulgateDay", "LawNum", "LawTitle", "LawTitle_Kana", | |
| "Part_Num", "PartTitle", "Chapter_Num", "ChapterTitle", "Section_Num", "SectionTitle", null "Subsection_Num", null "SubsectionTitle", null "Division_Num", null "DivisionTitle", | |
| "Article_Num", "ArticleTitle", "Paragraph_Num", "ParagraphCaption", "ParagraphNum", "Sentence_Num", "Sentence" | |
| from JLAW_MAINPROVISION_PART_CHAPTER_SECTION_ARTICLE_XV | |
| union all | |
| select | |
| id, law_id, "Era", "Lang", "LawType", "Root_Num", "Year", "PromulgateMonth", "PromulgateDay", "LawNum", "LawTitle", "LawTitle_Kana", | |
| "Part_Num", "PartTitle", "Chapter_Num", "ChapterTitle", null "Section_Num", null "SectionTitle", null "Subsection_Num", null "SubsectionTitle", null "Division_Num", null "DivisionTitle", | |
| "Article_Num", "ArticleTitle", "Paragraph_Num", "ParagraphCaption", "ParagraphNum", "Sentence_Num", "Sentence" | |
| from JLAW_MAINPROVISION_PART_CHAPTER_ARTICLE_XV | |
| union all | |
| select | |
| id, law_id, "Era", "Lang", "LawType", "Root_Num", "Year", "PromulgateMonth", "PromulgateDay", "LawNum", "LawTitle", "LawTitle_Kana", | |
| null "Part_Num", null "PartTitle", "Chapter_Num", "ChapterTitle", "Section_Num", "SectionTitle", "Subsection_Num", "SubsectionTitle", "Division_Num", "DivisionTitle", | |
| "Article_Num", "ArticleTitle", "Paragraph_Num", "ParagraphCaption", "ParagraphNum", "Sentence_Num", "Sentence" | |
| from JLAW_MAINPROVISION_CHAPTER_SECTION_SUBSECTION_DIVISION_ARTICLE_XV | |
| union all | |
| select id, law_id, "Era", "Lang", "LawType", "Root_Num", "Year", "PromulgateMonth", "PromulgateDay", "LawNum", "LawTitle", "LawTitle_Kana", | |
| null "Part_Num", null "PartTitle", "Chapter_Num", "ChapterTitle", "Section_Num", "SectionTitle", "Subsection_Num", "SubsectionTitle", null "Division_Num", null "DivisionTitle", | |
| "Article_Num", "ArticleTitle", "Paragraph_Num", "ParagraphCaption", "ParagraphNum", "Sentence_Num", "Sentence" | |
| from JLAW_MAINPROVISION_CHAPTER_SECTION_SUBSECTION_ARTICLE_XV | |
| union all | |
| select | |
| id, law_id, "Era", "Lang", "LawType", "Root_Num", "Year", "PromulgateMonth", "PromulgateDay", "LawNum", "LawTitle", "LawTitle_Kana", | |
| null "Part_Num", null "PartTitle", "Chapter_Num", "ChapterTitle", "Section_Num", "SectionTitle", null "Subsection_Num", null "SubsectionTitle", null "Division_Num", null "DivisionTitle", | |
| "Article_Num", "ArticleTitle", "Paragraph_Num", "ParagraphCaption", "ParagraphNum", "Sentence_Num", "Sentence" | |
| from JLAW_MAINPROVISION_CHAPTER_SECTION_ARTICLE_XV | |
| union all | |
| select | |
| id, law_id, "Era", "Lang", "LawType", "Root_Num", "Year", "PromulgateMonth", "PromulgateDay", "LawNum", "LawTitle", "LawTitle_Kana", | |
| null "Part_Num", null "PartTitle", "Chapter_Num", "ChapterTitle", null "Section_Num", null "SectionTitle", null "Subsection_Num", null "SubsectionTitle", null "Division_Num", null "DivisionTitle", | |
| "Article_Num", "ArticleTitle", "Paragraph_Num", "ParagraphCaption", "ParagraphNum", "Sentence_Num", "Sentence" | |
| from JLAW_MAINPROVISION_CHAPTER_ARTICLE_XV | |
| union all | |
| select | |
| id, law_id, "Era", "Lang", "LawType", "Root_Num", "Year", "PromulgateMonth", "PromulgateDay", "LawNum", "LawTitle", "LawTitle_Kana", | |
| null "Part_Num", null "PartTitle", null "Chapter_Num", null "ChapterTitle", "Section_Num", "SectionTitle", null "Subsection_Num", null "SubsectionTitle", null "Division_Num", null "DivisionTitle", | |
| "Article_Num", "ArticleTitle", "Paragraph_Num", "ParagraphCaption", "ParagraphNum", "Sentence_Num", "Sentence" | |
| from JLAW_MAINPROVISION_SECTION_ARTICLE_XV | |
| union all | |
| select | |
| id, law_id, "Era", "Lang", "LawType", "Root_Num", "Year", "PromulgateMonth", "PromulgateDay", "LawNum", "LawTitle", "LawTitle_Kana", | |
| null "Part_Num", null "PartTitle", null "Chapter_Num", null "ChapterTitle", null "Section_Num", null "SectionTitle", null "Subsection_Num", null "SubsectionTitle", null "Division_Num", null "DivisionTitle", | |
| "Article_Num", "ArticleTitle", "Paragraph_Num", "ParagraphCaption", "ParagraphNum", "Sentence_Num", "Sentence" | |
| from JLAW_MAINPROVISION_ARTICLE_XV | |
| union all | |
| select | |
| id, law_id, "Era", "Lang", "LawType", "Root_Num", "Year", "PromulgateMonth", "PromulgateDay", "LawNum", "LawTitle", "LawTitle_Kana", | |
| null "Part_Num", null "PartTitle", null "Chapter_Num", null "ChapterTitle", null "Section_Num", null "SectionTitle", null "Subsection_Num", null "SubsectionTitle", null "Division_Num", null "DivisionTitle", | |
| null "Article_Num", null "ArticleTitle", "Paragraph_Num", "ParagraphCaption", "ParagraphNum", "Sentence_Num", "Sentence" | |
| from JLAW_MAINPROVISION_PARAGRAPH_XV; | |
| /* 付則 */ | |
| create or replace view jlaw_law_supplprovision_xv | |
| as | |
| select | |
| id, law_id, "Era", "Lang", "LawType", "Root_Num", "Year", "PromulgateMonth", "PromulgateDay", "LawNum", "LawTitle", "LawTitle_Kana", | |
| "Suppl_Type", "Suppl_AmendLawNum", "SupplProvisionLabel", | |
| "Chapter_Num", "ChapterTitle", | |
| "Article_Num", "ArticleTitle", "Paragraph_Num", "ParagraphCaption", "ParagraphNum", "Sentence_Num", "Sentence" | |
| from JLAW_SUPPLPROVISION_CHAPTER_ARTICLE_XV | |
| union all | |
| select | |
| id, law_id, "Era", "Lang", "LawType", "Root_Num", "Year", "PromulgateMonth", "PromulgateDay", "LawNum", "LawTitle", "LawTitle_Kana", | |
| "Suppl_Type", "Suppl_AmendLawNum", "SupplProvisionLabel", | |
| null "Chapter_Num", null "ChapterTitle", | |
| "Article_Num", "ArticleTitle", "Paragraph_Num", "ParagraphCaption", "ParagraphNum", "Sentence_Num", "Sentence" | |
| from JLAW_SUPPLPROVISION_ARTICLE_XV | |
| union all | |
| select | |
| id, law_id, "Era", "Lang", "LawType", "Root_Num", "Year", "PromulgateMonth", "PromulgateDay", "LawNum", "LawTitle", "LawTitle_Kana", | |
| "Suppl_Type", "Suppl_AmendLawNum", "SupplProvisionLabel", | |
| null "Chapter_Num", null "ChapterTitle", | |
| null "Article_Num", null "ArticleTitle", "Paragraph_Num", "ParagraphCaption", "ParagraphNum", "Sentence_Num", "Sentence" | |
| from JLAW_SUPPLPROVISION_PARAGRAPH_XV; | |
| /* | |
| * ビュー定義終了 | |
| */ |
