Insert Data Oracle

Insert example:
INSERT INTO <table_name> (<1st field>,<2nd field>,<…>) VALUES
(<value_1>,<value_2>,<value_…>);

SQL> INSERT INTO NEWS (NEWS_ID,NEWS_TITLE,NEWS_TEXT) VALUES ( "2","tasdfasdf","t
es" );
INSERT INTO NEWS (NEWS_ID,NEWS_TITLE,NEWS_TEXT) VALUES ( "2","tasdfasdf","tes" )

                                                                         *
ERROR en lÝnea 1:
ORA-00984: columna no permitida aquÝ
SQL>

We altered the double quotes for simpe ones.. and worked:
SQL> INSERT INTO NEWS( NEWS_ID,NEWS_TITLE,NEWS_TEXT ) VALUES ( '2','tasdfasdf','
tes' );

1 fila creada.

SQL>

If you insert duplicate vlaues at a restricted row:

SQL> insert into NEWS ( NEWS_ID,NEWS_TITLE,NEWS_TEXT) VALUES (3,'war at iraq','w
ar is going to happen at iraqi fields')
  2  ;

1 fila creada.

SQL> insert into NEWS ( NEWS_ID,NEWS_TITLE,NEWS_TEXT) VALUES (3,'war at iraq','w
ar is going to happen at iraqi fields');
insert into NEWS ( NEWS_ID,NEWS_TITLE,NEWS_TEXT) VALUES (3,'war at iraq','war is
 going to happen at iraqi fields')
*
ERROR en lÝnea 1:
ORA-00001: restriccion ·nica (SYSTEM.SYS_C006172) violada

SQL>

(Note that you need simple quotes in order to delimit rows wich have spaces)

Other restriction is you have to insert a valid data at the PK field:

SQL> INSERT INTO NEWS( NEWS_ID,NEWS_TITLE,NEWS_TEXT ) VALUES ( '','tasdfasdf','t
es' );
INSERT INTO NEWS( NEWS_ID,NEWS_TITLE,NEWS_TEXT ) VALUES ( '','tasdfasdf','tes' )

                                                          *
ERROR en lÝnea 1:
ORA-01400: no se puede realizar una inserci¾n NULL en
("SYSTEM"."NEWS"."NEWS_ID")

SQL> INSERT INTO NEWS( NEWS_ID,NEWS_TITLE,NEWS_TEXT ) VALUES ( '4','','tes' );

1 fila creada.

SQL>

update oracle