Shulou(Shulou.com)06/01 Report--

When the oracle PLSQl developer text importer imports data, remember to match the format, especially the time format, for example, if the database is in string format, but the Excel is in the following time format:

The create_time implied by execel is a string format, while the database is a string, so importing it will prompt you to lose the closing parenthesis ORA-00907:missing right parenthesis, so we need to remove the sql function and click Import. So pay attention to whether the import field matches the format of the database. If it doesn't match, we can handle it through a function on this side of the sql function.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.