3
votes
SQL breaking my query where there is NULL value
Error was thrown because of trying to insert NULL values in the COUNTRY column, not COUNTRY_CODE. You did not specify any value for COUNTRY column, an INSERT like that would insert NULL values in ...
1
vote
SQL breaking my query where there is NULL value
Since all three columns of country are defined as NOT NULL, you have to provide a value for all three columns when you insert a new row. To load that table using distinct values from airportdemodata, ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
oracle-11g-r2 × 1352oracle × 1022
plsql × 101
oracle-11g × 88
oracle-12c × 63
rman × 61
performance × 53
linux × 44
backup × 36
sqlplus × 35
oracle-10g × 34
installation × 33
oracle-sql-developer × 32
query-performance × 30
query × 30
tablespaces × 30
dataguard × 27
stored-procedures × 25
rac × 25
impdp × 25
audit × 24
listener × 24
permissions × 22
index × 21
import × 21