What's the best way to translate a website
You want to use a TRANSLATIONS table, that looks something like:

CREATE TABLE TRANSLATIONS 
(
  translation_id    INTEGER,
  language_id       INTEGER,
  translation       VARCHAR(255),
  PRIMARY KEY (translation_id, language_id)
);


Then edit your current schema and/or code to reference the TRANSLATIONS table, rather than any hard-coded values (using translation_id,language_id to lookup). For example, rather than having a VARCHAR column in a table, you'd instead have a NUMBER column that would "link" to the TRANSLATIONS table.

Probably also best to have a LANGUAGES table that lists what each language_id represents.

For example:

CREATE TABLE LANGUAGES
(
  language_id   NUMBER PRIMARY KEY,
  iso_code      CHAR(4), -- eg "en"
  language_name VARCHAR(32) -- eg "English"
);