Skip to content

Instantly share code, notes, and snippets.

@ujnak

ujnak/digital-agency-icon-source.sql Secret

Created June 29, 2023 02:17
Show Gist options
  • Save ujnak/c48db081431b3fb8ccf72b0bdefac2ff to your computer and use it in GitHub Desktop.
Save ujnak/c48db081431b3fb8ccf72b0bdefac2ff to your computer and use it in GitHub Desktop.
Download ZIP
デジタル庁のアイコン素材を一覧する
Raw
digital-agency-icon-source.sql
select
workspace_file_id, file_name, mime_type, file_charset, to_clob(file_content) file_content, last_updated_on
, replace(file_name,'designsystem-assets/icon/svg/','') as file_name_short
, '#' || 'WORKSPACE_FILES' || '#' || file_name as file_name_long
from apex_workspace_static_files
where file_name like 'designsystem-assets/icon/svg/%.svg'
and workspace_id = :WORKSPACE_ID
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment