L>
SQL> var v1 number;
SQL>
SQL> exec :v1 := 1;

PL/SQL procedure successfully completed.

SQL> exec :v1 := 2;

PL/SQL procedure successfully completed.

SQL>
SQL> select :v1 + :v1 from dual;

   :V1+:V1
----------
         4

SQL>

SQL>
SQL> select &v1 + &v1 from dual;
Enter value for v1: 1
Enter value for v1: 2
old   1: select &v1 + &v1 from dual
new   1: select 1 + 2 from dual

       1+2
----------
         3

SQL>

SQL>
SQL> set serveroutput on
SQL> declare
  2       l_n1 number;
  3       l_n2 number;
  4       l_n3 number;
  5   begin
  6       execute immediate 'select :x, :x, :x from dual'
  7       into l_n1, l_n2, l_n3
  8       using 1, 2, 3
  9       ;
 10  --
 11       dbms_output.put_line( l_n1 || ', ' || l_n2 || ', ' || l_n3 );
 12   end;
 13   /
1, 2, 3

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.00
SQL>

SQL> VAR X1 REFCURSOR
SQL>
SQL>
SQL> set serveroutput on timing on
SQL> declare
  2       v1 varchar2(100) := 'somevalue200';
  3  --
  4   begin
  5   open :x1 for select count(*) from dual where 'somevalue200' = v1 ;
  6  --
  7   end;
  8   /

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.00
SQL>
SQL> print :x1

  COUNT(*)
----------
         1

Elapsed: 00:00:00.01
SQL>
SQL>
SQL>

SCOTT@orcl_12.1.0.2.0> var x1 refcursor
SCOTT@orcl_12.1.0.2.0> begin
  2    open :x1 for
  3    'select * from emp where deptno in (:x, :x, :x) order by deptno, empno'
  4    using 10, 20, 40;
  5  end;
  6  /

PL/SQL procedure successfully completed.

SCOTT@orcl_12.1.0.2.0> print :x1

     EMPNO ENAME      JOB              MGR HIREDATE                   SAL       COMM     DEPTNO
---------- ---------- --------- ---------- ------------------- ---------- ---------- ----------
      7782 CLARK      MANAGER         7839 1981-06-09 00:00:00       2450                    10
      7839 KING       PRESIDENT            1981-11-17 00:00:00       5000                    10
      7934 MILLER     CLERK           7782 1982-01-23 00:00:00       1300                    10
      7369 SMITH      CLERK           7902 1980-12-17 00:00:00        800                    20
      7566 JONES      MANAGER         7839 1981-04-02 00:00:00       2975                    20
      7788 SCOTT      ANALYST         7566 1982-12-09 00:00:00       3000                    20
      7876 ADAMS      CLERK           7788 1983-01-12 00:00:00       1100                    20
      7902 FORD       ANALYST         7566 1981-12-03 00:00:00       3000                    20

8 rows selected.

SCOTT@orcl_12.1.0.2.0> select t.*
  2  from   (select distinct s.sql_id, s.child_number
  3  	     from   v$sql s, v$sql_plan p
  4  	     where  s.sql_id = p.sql_id
  5  	     and    s.child_number = p.child_number
  6  	     and    UPPER (s.sql_text) like '%SELECT * FROM EMP WHERE DEPTNO IN%') v,
  7  	    table (dbms_xplan.display_cursor(v.sql_id, v.child_number)) t
  8  /

PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------------------------------------------------
SQL_ID  5rn5ykq18p0t1, child number 0
-------------------------------------
select * from emp where deptno in (:x, :x, :x) order by deptno, empno

Plan hash value: 150391907

---------------------------------------------------------------------------
| Id  | Operation          | Name | Rows  | Bytes | Cost (%CPU)| Time     |
---------------------------------------------------------------------------
|   0 | SELECT STATEMENT   |      |       |       |     4 (100)|          |
|   1 |  SORT ORDER BY     |      |     9 |   342 |     4  (25)| 00:00:01 |
|*  2 |   TABLE ACCESS FULL| EMP  |     9 |   342 |     3   (0)| 00:00:01 |
---------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   2 - filter(("DEPTNO"=:X OR "DEPTNO"=:X OR "DEPTNO"=:X))


19 rows selected.

SCOTT@orcl_12.1.0.2.0> column value_string format a30
SCOTT@orcl_12.1.0.2.0> select b.position, b.value_string
  2  from   (select distinct s.sql_id, s.child_number, s.hash_value, s.child_address
  3  	     from   v$sql s, v$sql_plan p
  4  	     where  s.sql_id = p.sql_id
  5  	     and    s.child_number = p.child_number
  6  	     and    UPPER (s.sql_text) like '%SELECT * FROM EMP%') v,
  7  	    v$sql_bind_capture b
  8  where  b.hash_value = v.hash_value
  9  and    b.child_address = v.child_address
 10  /

  POSITION VALUE_STRING
---------- ------------------------------
         1 10
         2 20
         3 40

3 rows selected.