PROCEDURE COLUMN_SPLIT (p_def IN VARCHAR2,
p_sch OUT VARCHAR2,
p_table OUT VARCHAR2,
p_column OUT VARCHAR2)
IS
BEGIN
NULL;
END;
END;
I want to split p_def by dots, check for 3 elements, and return them in p_sch, p_table and p_column
for example p_sch will be like hello.howare.you.
I want to split it to
hello
howare
you
I have very limited knowledge with pl/sql can someone point me in the right direction or maybe show some example.