What happens when an oracle database query encounters an ORA 1578 error? ora 01578 ORACLE data blo

It can be used normally after plugging in the USB flash drive, but there is no icon in the taskbar to safely delete the hardwareI don't know how to fix it, here is a share of the fix.

1. First of all, in the start menu, open the "Control Panel" program.

2. In the control panel window, drag the scroll bar, find the "System" icon, and double-click.

3. After entering the system properties window, select the "Device Manager" button under "Hardware".

4. In the Device Manager window, select "USB Disk Devices" under "Disk Drives", then right-click and select Properties.

5. In the properties window, select the "Strategy" tab.

6. Enter the strategy interface, and the original selection is "Optimize for quick deletion".

7. Modify it, select "Optimized for performance", and press the "OK" button after setting it.

8. At this time, go to the notification area of the taskbar to delete the USB flash drive, and the prompt of "Safely delete hardware" will pop up.

Since that's the case, then step by step, don't you also know that the problem is in the **, don't you report the error if you replace it with *, that means that your SQL statement is no problem both grammatically and logically, but once it is changed to a specific column, there will be a problem, then it is obviously a problem with the column, and if there is an error in the definition of a certain (some) column, such as referencing a non-existent column (if the column name is written incorrectly), then the error should be reported as 00904, and now it is not, Then this situation is ruled out, you observe, you define an alias for each column has a prominent feature, some columns use parentheses in the table name, and you have not used a pair of double quotation marks for the alias, then the parentheses will not be recognized when compiling, just like if there is a space when you define an alias, you must use a pair of double quotation marks to enclose it, but in our usual writing, no matter what the alias you define, it is best to use a pair of double quotation marks to distinguish it.

(time), (times) such parentheses are a problem. was parsed incorrectly.

Try removing parentheses, or enclosing those renames in quotation marks.

Please put double quotation marks for each alias. This basically does not appear.

What columns did you add and report an error?

When adding data to the oracle database, the message ORA-00947: There are not enough values. The structure of Table 1 has 4 columns, and apparently there are only 3 inserted values, so this problem will occur, and the value of one column is added.

Here's how to fix it:

1. First of all, in the computer, open the Oracle connection program, use the new database administrator, and click the [Server] button with the left mouse button, as shown in the figure below.

2. Then, on the window of [Oracle Server], left-click the [SQL Sheet] button, as shown in the following figure.

3. Then, on the window of the [State Cover Old SQL Worksheet], enter the SQL query statement in the input window, and click the [Execute] button, there is no query in the prompt window and cover it, and you need to recreate ** for this user.

4. On the SQL Worksheet window, enter the SQL statement to create ** and click the Execute button.

5. You can see the message that the SQL statement is successfully executed.

Cause: The date type cannot contain a precision after seconds.

Date: 2012-06-20 21:01:24.

This error can occur when using the to date() function.

Workaround: to date(.)'2012-06-20 21:01:24','yyyy-mm-dd') is wrong.

to_date( substr('2012-1-1 00:00:00',0,instr('2012-1-1 00:

00:00', ':', 1, 1)-3),'yyyy-mm-dd') is correct.

1. Create a stored procedure to write data from one table to another. As shown in the figure below.

2. Test the stored procedure, select the stored procedure, and select "Test".

3. "Single step in" to start the test.

4. Click Next, the error is as follows, and click OK.

5. Test again, and the error is as follows.

6. Click "Yes" to locate the error as follows and check it. Locate the statement strsql :='select * from test1 where id>0 ' ;"Check, Find, Define" strsql varchar2(10); "10 is too small, modify it to " strsql varchar2(1000); "Test again.

7. Test again, the process is normal.

8. Continue to execute, which takes 27 seconds to complete the execution.

9. Check and find, enter a piece of data, and the error is solved.

Problem: varchar2 type is converted to date type.

select to_date(invoice_date,'yyyy-mm-dd') from tab;

Tip ORA-01830: Date format ends before converting the entire input string error.

Last reason checked: invoice date='2005-11-10 00:00:00' is longer than formatted'yyyy-mm-dd'length.

Solve: (using substr()).

to_date(substr(invoice_date,1,10),'yyyy-mm-dd')