noobow34

# 文字化け防止
chcp 65001 | Out-Null
$Env:NLS_LANG = "Japanese_Japan.UTF8"
[console]::OutputEncoding = [System.Text.Encoding]::UTF8

# 取得対象のSQL
$innerSql = @"
WITH Numbers AS (
    SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS SEQ
    FROM (VALUES(1),(1),(1),(1),(1),(1),(1),(1),(1),(1)) AS V(N)

noobow34

# 文字化け防止
chcp 65001 | Out-Null
[console]::OutputEncoding = [System.Text.Encoding]::UTF8

# 取得対象のSQL
$innerSql = @"
SELECT SEQ, SEQ + 1 AS SEQ2 
FROM generate_series(1,10) AS SEQ
"@

noobow34

function Convert-XmlToCustomObject {
    param (
        [Parameter(ValueFromPipeline)] [xml]$xml
    )

    process {
         # すべての <row> 要素をカスタムオブジェクトに変換
        $rows = $xml.resultset.row | ForEach-Object {
            $properties = @{}
            

noobow34

# 文字化け防止
chcp 65001 | Out-Null
[console]::OutputEncoding = [System.Text.Encoding]::UTF8

# 取得対象のSQL
$innerSql = @"
WITH RECURSIVE Numbers AS (
    SELECT 1 AS SEQ
    UNION ALL
    SELECT SEQ + 1 FROM Numbers WHERE SEQ < 10

noobow34

# 文字化け防止
chcp 65001 | Out-Null
$Env:NLS_LANG = "Japanese_Japan.UTF8"
[console]::OutputEncoding = [System.Text.Encoding]::UTF8

# 取得対象のSQL
$innerSql = @"
SELECT LEVEL SEQ,LEVEL+1 SEQ2
FROM DUAL
CONNECT BY LEVEL <= 10

noobow34

using System;
using System.Linq;

namespace ConsoleApp1
{
    class CalcSumOfOddNumberFrom1to100
    {
        static void Main(string[] args)
        {
            var sum = Enumerable.Range(1, 100).Where(x => x % 2 == 0).Sum();