Oracle PL/SQL ORA-00947 Not Enough Values Error Oracle PL / SQL ORA-00947 Not Enough vērtību kļūda
In Oracle database, the following error message may appear when an incorrect SQL statement is used, in SQL Plus or in anywhere that send SQL queries to the databases such as stored procedure or external programs. Oracle datu bāzes, šāds kļūdas ziņojums var parādīties, kad nepareizs SQL izmanto, SQL Plus vai jebkurā vietā, kas nosūta SQL vaicājumus datu bāzēm, piemēram, uzglabā procedūru vai ārējām programmām.
PL/SQL: SQL Statement ignored PL / SQL: SQL ignorēt
PL/SQL: ORA-00947: not enough values PL / SQL: ORA-00947: nav pietiekami vērtības
The reason for ORA-00947 error is when a SQL statement requires two sets of value, ie number of number of columns and its value that are specified in the SQL to be equal in number. Iemesls ORA-00947 kļūda ir tad, ja SQL prasa divas vērtības, proti, vairāki kolonnu skaits un vērtība, kas ir norādītas SQL ir vienāds numurs. But the second part of the query which is column values contains fewer items than the first part which is the number of columns. Bet otrā daļa vaicājums, kas slejas vērtības ir mazāk preču, nekā pirmā daļa, kas ir kolonnu skaitu. The error may happens in all kind of SQL statements – Insert, Update or Select – and it can also occur in a WHERE or HAVING clause in which a nested sub-SELECT returns too few columns. Kļūda notiek, visu veidu SQL paziņojumi - ievadīt, aktualizēt vai Select - un tas var notikt arī WHERE vai ar klauzulu, kas nested sub-SELECT atgriež pārāk maz kolonnas. If the SQL does not specify columns, it means that the values entered are less that the columns existed in the table in database. Ja SQL neprecizē kolonnas, tas nozīmē, ka vērtībām, kas ir mazāk nekā kolonnas pastāvēja tabulā datubāzē.
For example, the ORA-00947 error will be returned if you try to execute the following SQL statements: Piemēram, ORA-00947 kļūdas tiek atgriezta, ja jūs mēģināt izpildīt šādus SQL paziņojumi:
INSERT INTO Customers (Customer_ID, Customer_Name, Birthday) VALUES ('1′, 'My Customer'); INSERT INTO klienti (Customer_ID, Customer_Name, Birthday) VALUES ('1 ',' Mans Klientu ');
or vai
SELECT * FROM Customers WHERE (Customer_ID, Customer_Name) IN (SELECT Customer_ID FROM Orders); SELECT * FROM Customers WHERE (Customer_ID, Customer_Name) in (SELECT Customer_ID FROM Orders);
To solve the error and correct the problem, check that the number of values provided in the column values part is equal that the columns specified, or the number of columns in table, and change the SQL statement to make them equal. Lai atrisinātu kļūdas un labot problēmu, pārliecinieties, ka ir vērtības, kas slejas vērtības daļu skaits ir vienāds, ka kolonnas norādīta vai kolonnu skaitu tabulā un maina SQL, lai tos vienādi.
You can either reduce the number of columns, or increase the number of values provided to the column to make the SQL statement equaled. Jūs varat vai nu samazināt kolonnu skaitu vai arī palielināt skaitu, vērtības, lai kolonna padarīt SQL equaled. This applies to the nested SQL statements with HAVING or WHERE clause too. Tas attiecas uz nested SQL ar kura ir vai WHERE klauzulu pārāk. For example, the correct SQL statements should be like the following: Piemēram, pareizi SQL vajadzētu būt šādi:
INSERT INTO Customers (Customer_ID, Customer_Name, Birthday) VALUES ('1′, 'My Customer', '08/08/1988′); INSERT INTO klienti (Customer_ID, Customer_Name, Birthday) VALUES ('1 ',' Mans Klientu ', '08 / 08/1988');
or vai
INSERT INTO Customers (Customer_ID, Customer_Name) VALUES ('1′, 'My Customer'); INSERT INTO klienti (Customer_ID, Customer_Name) VALUES ('1 ',' Mans Klientu ');
or vai
SELECT * FROM Customers WHERE (Customer_ID, Customer_Name) IN (SELECT Customer_ID, Customer_Name FROM Orders); SELECT * FROM Customers WHERE (Customer_ID, Customer_Name) in (SELECT Customer_ID, Customer_Name no pasūtījumiem);
or vai
SELECT * FROM Customers WHERE (Customer_ID) IN (SELECT Customer_ID FROM Orders); SELECT * FROM Customers WHERE (Customer_ID) in (SELECT Customer_ID FROM Orders);
IMPORTANT : The page is machine translated and provided "as is" without warranty. SVARĪGI: lapa mašīna iztulkot un pasniegts tàds, "kàds tas ir" bez garantijas. Machine translation may be difficult to understand. Mašīntulkošanu var būt grūti saprast. Please refer to Lūdzu, skatiet original English article oriģināls angļu rakstu whenever possible. kad vien iespējams.
Related Articles Saistītie raksti
- ORA-00942 Table or View Does Not Exist Oracle Error ORA-00.942 tabulā vai View neeksistē Oracle Kļūda
- ORA-02449 Oracle Drop Table Error ORA-02.449 Oracle Drop tabula Kļūda
- Easily Duplicate, Copy or Backup Tables in Oracle, PostgreSQL, DB2 and SQLite with Create Table As SQL Viegli Dublēt, kopēšana vai Backup tabulu Oracle, PostgreSQL, DB2 un SQLite ar tabulas izveidošanai, SQL
- Oracle ORA-14074 Create or Add New Partition Fails Error Oracle ORA-14.074 izveidošana vai Add New Partition nav kļūda
- Create, Add or Split Oracle Database Partition Fails with ORA-14080 Error Izveidot, pievienošana vai Split Oracle Database Partition neizdodas, ORA-14.080 Kļūda
- Oracle EXP-00091 Error When Export Database Oracle EXP-00091 kļūdu Export Database
- ORA-25153 Temporary Tablespace is Empty Error in Oracle ORA-25.153 Pagaidu Tablespace ir tukšs Kļūda Oracle
- Oracle ORA-01658 Unable to Create INITIAL Extent for Segment in Tablespace Error Oracle ORA-01.658 Nevar izveidot INITIAL Apjoms, kādā segmentā Tablespace Kļūda
- Oracle Database Import Error 3113/3114 Oracle Database Import Error 3113/3114
- IMP-00013 Oracle Import Error IMP-00013 Oracle Import Error
