How to run sql command using chef?

Chef Infra (archive)
1

first i want to connect to sqlplus / as sysdba and then shutdown immediate; using chef from pwershell

2

Have you tried the powershell_script resource ? https://docs.chef.io/resource_powershell_script.html

3

Actually i want to first connect to sqlplus like this in example and then run a abc command
Powershell_script ‘alw’ do
Command "sqlplus / as sysdba abc"
End