Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
<?php
$query = "-- test
CREATE OR REPLACE PROCEDURE welcome_msg (p_name IN VARCHAR2)
IS
BEGIN
dbms_output.put_line ('Welcome '|| p_name);
END;
EXEC welcome_msg (‘Guru99’);";
var_dump(
preg_split('//u', $query, -1, PREG_SPLIT_NO_EMPTY)
);