ป้ายกำกับ: คั่น

WITH RawData(tag_name) AS (
  SELECT DISTINCT TRIM(unnest(string_to_array(
    'Access,Admin,Algorithm,Application,Authentication,Backup,Broken,Brute,Code,Components,Control,Cryptographic,Data,Database,Default,Design,Digital,Error,Failures,Firewall,Force,Forgery,Framework,HTTP,HTTPS,ID,Identification,Injection,Insecure,Integrity,Library,Log,Logging,Login,Misconfiguration,Module,Monitoring,Open,Outdated,OWASP,password,Patch,Plaintext,Project,Request,Security,Server-Side,Session,Signature,Software',
    ','
  )))
)
SELECT * FROM RawData;

WITH RawData(tag_name) AS (
  SELECT DISTINCT TRIM(value)
  FROM STRING_SPLIT(
    'Access,Admin,Algorithm,Application,Authentication,Backup,Broken,Brute,Code,Components,Control,Cryptographic,Data,Database,Default,Design,Digital,Error,Failures,Firewall,Force,Forgery,Framework,HTTP,HTTPS,ID,Identification,Injection,Insecure,Integrity,Library,Log,Logging,Login,Misconfiguration,Module,Monitoring,Open,Outdated,OWASP,password,Patch,Plaintext,Project,Request,Security,Server-Side,Session,Signature,Software',
    ','
  )
)
SELECT * FROM RawData;

WITH RawData AS (
  SELECT DISTINCT TRIM(tag) AS tag_name
  FROM UNNEST(SPLIT(
    'Access,Admin,Algorithm,Application,Authentication,Backup,Broken,Brute,Code,Components,Control,Cryptographic,Data,Database,Default,Design,Digital,Error,Failures,Firewall,Force,Forgery,Framework,HTTP,HTTPS,ID,Identification,Injection,Insecure,Integrity,Library,Log,Logging,Login,Misconfiguration,Module,Monitoring,Open,Outdated,OWASP,password,Patch,Plaintext,Project,Request,Security,Server-Side,Session,Signature,Software',
    ','
  )) AS tag
)
SELECT * FROM RawData;

WITH RawData AS (
  SELECT DISTINCT TRIM(f.value) AS tag_name
  FROM TABLE(FLATTEN(SPLIT(
    'Access,Admin,Algorithm,Application,Authentication,Backup,Broken,Brute,Code,Components,Control,Cryptographic,Data,Database,Default,Design,Digital,Error,Failures,Firewall,Force,Forgery,Framework,HTTP,HTTPS,ID,Identification,Injection,Insecure,Integrity,Library,Log,Logging,Login,Misconfiguration,Module,Monitoring,Open,Outdated,OWASP,password,Patch,Plaintext,Project,Request,Security,Server-Side,Session,Signature,Software',
    ','
  ))) AS f
)
SELECT * FROM RawData;

WITH RawData AS (
  SELECT DISTINCT TRIM(j.tag) AS tag_name
  FROM JSON_TABLE(
    '["Access","Admin","Algorithm","Application","Authentication","Backup","Broken","Brute","Code","Components","Control","Cryptographic","Data","Database","Default","Design","Digital","Error","Failures","Firewall","Force","Forgery","Framework","HTTP","HTTPS","ID","Identification","Injection","Insecure","Integrity","Library","Log","Logging","Login","Misconfiguration","Module","Monitoring","Open","Outdated","OWASP","password","Patch","Plaintext","Project","Request","Security","Server-Side","Session","Signature","Software"]',
    '$[*]' COLUMNS(tag VARCHAR(50) PATH '$')
  ) AS j
)
SELECT * FROM RawData;