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

Scene

Oracle comes with database query tools.

Check which tables are in the database

Select * from tab

Query table structure

Desc pas_alarm_info

Formatting fields of type date, string output

Select to_char (alarm_time, 'yyyy-mm-dd hh34:mi:ss') from pas_alarm_info

To_char (alarm_time

2019-09-06 12:12:12

By default, it appears as follows:

Select alarm_time from pas_alarm_info

Alarm_time

06-September-19

Date string insertion, need to be converted

Insert into tabname (datecol) value (to_date ('2014-02-14 20 value 47 to_date))

Execute script

@ C:test\ mysql.sql

Be careful

SQL Plus additions, deletions and modifications enable transactions by default, so if you do not execute the commit instruction, you will still keep it in memory and do not really write to the library

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.