PL/SQL Script to find the factorial of a number

1.	PL/SQL Script to find the factorial of a number
Answer» To include single QUOTES in a string literal, you NEED to use it like: “That wasn’’t a big blow to the team” Above, we have SET TWO single quotes to display one single quote. Let us see an example. Our string is: It's my life The following is the code to include single quotes: DECLARE a varchar2(15):= 'It''s my life!'; BEGIN dbms_output.put_line(a); END; / The output: It's my life!

Answer»

To include single QUOTES in a string literal, you NEED to use it like:

“That wasn’’t a big blow to the team”

Above, we have SET TWO single quotes to display one single quote.

Let us see an example.

Our string is:

It's my life

The following is the code to include single quotes:

DECLARE a varchar2(15):= 'It''s my life!'; BEGIN dbms_output.put_line(a); END; /

The output:

It's my life!

Discussion