Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator
16 Search Results Found
1 Forum: SQL & PL/SQL «» Posted on: Tue, 31 July 2018 12:36 «» By: Solomon Yakobson
Re: Create JSON from SQL 12C R1
… 4 / insert * ERROR at line 1: ORA-02290: check constraint (SCOTT.VALIDATE_JSON) violated SQL> insert 2 into tbl 3 values('{"departmentId":100,"name":"Finance","employees":[{"employeeId…
2 Forum: SQL & PL/SQL «» Posted on: Fri, 14 July 2017 19:19 «» By: Barbara Boehmer
Re: Insert statement with bind variable and Create statement
…values ('dddddd') 2 / insert into test_tab values ('dddddd') * ERROR at line 1: ORA-02290: check constraint (SCOTT.SYS_C0034101) violated SCOTT@orcl_12.1.0.2.0> insert into test_tab values ('dddd 2 dd') 3 / 1 row created…
3 Forum: SQL & PL/SQL «» Posted on: Wed, 17 May 2017 08:49 «» By: whdyck
Re: Use ":NEW" in Dynamic SQL in Trigger?
…referring to a check constraint violation (ORA-02290). Yes, SQL users will understand what a check constraint violation is in a generic sense, but they will not understand exactly what is wrong. (e.g., they won't know what the error message "check …
4 Forum: SQL & PL/SQL «» Posted on: Sun, 19 March 2017 07:53 «» By: Solomon Yakobson
Re: need help in SQL Check constraint on column referencing other tables
…VALUES (1, 2, 333, 3) * ERROR at line 1: ORA-02290: check constraint (SCOTT.MATCHSCHEDULED_CHK) violated SQL> INSERT INTO matchscheduled (guestteam, hostteam, manofthematch, manofthematch_teamid) VALUES (1, 2, 222, 3) 2 / INSERT INTO …
5 Forum: SQL & PL/SQL «» Posted on: Fri, 17 March 2017 23:24 «» By: Barbara Boehmer
Re: need help in SQL Check constraint on column referencing other tables
…VALUES (1, 2, 333) * ERROR at line 1: ORA-02290: check constraint (SCOTT.MATCHSCHDULED_CK) violated SCOTT@orcl_12.1.0.2.0> SELECT guestteam, hostteam, manofthematch FROM matchscheduled 2 / no rows selected -- insert that does not …
6 Forum: Forms «» Posted on: Fri, 08 January 2016 03:30 «» By: cookiemonster
Re: VALIDATING QTY
…inserted SQL> commit; commit ORA-12008: error in materialized view refresh path ORA-02290: check constraint (OPS$TAGTRAK.STOCK_V_CHK) violated SQL> Just bear in mind that the constraint is only checked when the user commits…
7 Forum: SQL & PL/SQL «» Posted on: Thu, 26 June 2014 07:21 «» By: Solomon Yakobson
Re: How to enforce key uniqueness in a temporal table?
… 8 ) 9 / 1 row created. SQL> COMMIT 2 / COMMIT * ERROR at line 1: ORA-12008: error in materialized view refresh path ORA-02290: check constraint (SCOTT.CATCH_OVERLAPPING_VALUES_CHK1) violated SQL> SY…
8 Forum: SQL & PL/SQL «» Posted on: Mon, 21 October 2013 11:50 «» By: Solomon Yakobson
Re: Materialized views to rescue "mutating tables"
…error in materialized view refresh path ORA-02290: check constraint (SCOTT.CK_THEO) violated SCOTT@orcl > update theo_life set nb_theo = 0 2 / 3 rows updated. SCOTT@orcl > commit 2 / Commit complete. SCOTT@orcl > …
9 Forum: SQL & PL/SQL «» Posted on: Mon, 21 October 2013 07:30 «» By: Solomon Yakobson
Re: Materialized views to rescue "mutating tables"
…error in materialized view refresh path ORA-02290: check constraint (SCOTT.CK_THEO) violated SCOTT@orcl > select * 2 from theo_life 3 / ID NB_THEO ---------- ---------- 1 1 2 3…
10 Forum: SQL & PL/SQL «» Posted on: Fri, 27 September 2013 15:27 «» By: Michel Cadot
Re: complex constraint
…at line 1: ORA-02290: check constraint (MICHEL.T1_CHK1) violated SQL> insert into abcd values('R',null,null); insert into abcd values('R',null,null) * ERROR at line 1: ORA-02290: check constraint (MICHEL.T1_CHK1) violated SQL> insert …
11 Forum: SQL & PL/SQL «» Posted on: Fri, 27 September 2013 15:02 «» By: Solomon Yakobson
Re: complex constraint
… 4 / insert * ERROR at line 1: ORA-02290: check constraint (SCOTT.T1_CHK1) violated SCOTT@orcl > insert 2 into abcd 3 values('R',null,sysdate) 4 / insert * ERROR at line 1: ORA-02290: check constraint (SCOTT.T1_CHK1) …
12 Forum: SQL & PL/SQL «» Posted on: Mon, 27 May 2013 07:51 «» By: Michel Cadot
Re: regex validation
…values ('01.003') * ERROR at line 1: ORA-02290: check constraint (MICHEL.SYS_C0011635) violated SQL> insert into OM_AIC_SALES_CODES values ('001.003'); insert into OM_AIC_SALES_CODES values ('001.003…
13 Forum: SQL & PL/SQL «» Posted on: Fri, 08 February 2013 11:59 «» By: Solomon Yakobson
Re: assertions
…15 / insert * ERROR at line 1: ORA-02290: check constraint (SCOTT.EMP1_CHK1) violated SQL> insert 2 into emp1 3 select empno, 4 ename, 5 job, 6 mgr, 7 hiredate…
14 Forum: SQL & PL/SQL «» Posted on: Wed, 08 August 2012 01:28 «» By: Littlefoot
Re: special character not allowed in column value
…insert into stud_mst values ('Abc13'); 1 row created. SQL> insert into stud_mst values ('L''Pradhan'); insert into stud_mst values ('L''Pradhan') * ERROR at line 1: ORA-02290: check constraint (SCOTT.CH_ENAME) violated SQL>…
15 Forum: SQL & PL/SQL «» Posted on: Fri, 11 May 2012 16:33 «» By: Barbara Boehmer
Re: sql & syntax (regex maybe) (4 threads merged by bb)
…values (null) * ERROR at line 1: ORA-02290: check constraint (SCOTT.POSTAL_ZONE_NOT_NULL) violated SCOTT@orcl_11gR2> insert into ar_address values ('sdkj') 2 / insert into ar_address values ('sdkj') * ERROR at line 1: ORA-02290: check …
16 Forum: SQL & PL/SQL «» Posted on: Mon, 05 March 2012 10:28 «» By: Solomon Yakobson
Re: Constraints on objects?
…object_tab_ext values(1,'A',99,'Gerontology'); insert * ERROR at line 1: ORA-02290: check constraint (SCOTT.OBJECT_TAB_EXT_CHK1) violated SQL> insert 2 into object_tab_ext values(1,'A',19,'Math'); 1 row created. SQL> SY…

Current Time: Sat Jan 25 06:26:45 CST 2020