WhatDatabase link is an option to connect to a remote database from another database. By using this database link option one can connect to remote database as authorized database user and can perform the operations as in the direct connection. Database link is of two types Public Private HowAdd a entry in tnsnames.ora file to …
ORA-12154: TNS: could not resolve the connect identifier specified Read More »
We will get this when we are trying to update a row in a table, for which there will be two or more corresponding records. Table 1: tc11 tcl2 t1 a t2 b t3 c t4 d Table 2: tc21 tc22 b1 a b2 b b3 c b4 d Table 3: tc31 tc32 t1 b1 …
ORA-30926: unable to get a stable set of rows in the source tables Read More »
We may get this error, when we try to assign a value to a variable which is bigger than the maximum size of the variable.Find the following code for example: DECLARE v_data VARCHAR2(1); BEGIN v_data := ‘YES’; END; / Error starting at line : 1 in command –DECLAREv_data varchar2(1);BEGINv_data := ‘YES’;END;Error …
