title: Is it possible to create to tables that reference each other without using ALTER?
body: <p>I am new to databases in general and would like to have an answer to a problem that I am facing.
  I would like to know if there is away two create two tables that reference each other without creating one and Altering it later and adding the reference.</p>
  <pre><code>CREATE TABLE Cats(
  name VARCHAR2(15) CONSTRAINT cat_name_nn NOT NULL,
  gender VARCHAR2(1) CONSTRAINT cat_gd CHECK(gender IN('W', 'M')),
  nickname VARCHAR2(15) CONSTRAINT cat_pk PRIMARY KEY,
  function VARCHAR2(10) CONSTRAINT cat_fn REFERENCES Functions(function),
  chief VARCHAR2(15) CONSTRAINT cat_chf REFERENCES Cats(nickname),
  in_herd_sinnce DATE   DEFAULT  SYSDATE,
  mice_ration NUMBER(3), 
  mice_extra NUMBER(3),
  band_no NUMBER(2) CONSTRAINT cat_bno REFERENCES Bands(band_no))
  
  CREATE TABLE Bands(
  band_no NUMBER(2) CONSTRAINT bd_pk PRIMARY KEY,
  name VARCHAR2(20) CONSTRAINT bd_name_nn NOT NULL,
  site VARCHAR2(15) CONSTRAINT bd_site_un UNIQUE,
  band_chief VARCHAR2(15) CONSTRAINT bd_chf_un UNIQUE 
      CONSTRAINT bd_chf_nm REFERENCES Cats(nickname)
  </code></pre>
  <p>);</p>
  <p>As far as I remember I can not do it; I am right?</p>