pointer

How do I assign something to a pointer or a reference in Oracle? Thanks.

"IS REF" like 'IS REF CURSOR"

That isn't much help - show us what you're trying to do.

I have a long piece of script (I think it is PL/SQL). In the script, the tablespace name is everywhere. When I want to change the tablespace name, I have to change every place. Because of that, I was thinking when creating the tablespace name, I should assign the name to an reference so that I only need to change the name at one place when I need to. For example,

CREATE TABLESPACE TS ...

CREATE TABLE TS.FOO(...) TABLESPACE TS;

Can I assign TS to a reference?

Thanks.

Short answer: no

Assuming it is a SQL script (you can't do DDL in PL/SQL easily), creating tables and tablespaces on the fly:
doing DDL is generally not a great idea. If this script runs once a month, no problem.

DDL is a command like
CREATE
DROP
ALTER

Edit:
You can do SQL in PL/SQL as dynamic SQL. Create a string like:

and then execute the SQL statement. DDL does not work in PL/SQL dynamic statements. This is the only shortcut I know.