How to run sql command using chef?

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

Have you tried the powershell_script resource ?

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"