Operations in Oracle that contain keywords as fields = query, insertion, etc. = standard double quotation marks

<! --
/* Font Definitions */
@ Font-face
{Font-family:;
Panose-1: 2 1 6 0 3 1 1 1 1 1;
MSO-font-alt: simsun;
MSO-font-charset: 134;
MSO-generic-font-family: auto;
MSO-font-pitch: variable;
MSO-font-Signature: 3 135135232 16 0 262145 0 ;}
@ Font-face
{Font-family: "/@ ";
Panose-1: 2 1 6 0 3 1 1 1 1 1;
MSO-font-charset: 134;
MSO-generic-font-family: auto;
MSO-font-pitch: variable;
MSO-font-Signature: 3 135135232 16 0 262145 0 ;}
/* Style definitions */
P. msonormal, Li. msonormal, Div. msonormal
{MSO-style-parent :"";
Margin: 0 cm;
Margin-bottom:. 0001pt;
Text-align: justify;
Text-justify: Inter-ideograph;
MSO-pagination: none;
Font-size: 10.5pt;
MSO-bidi-font-size: 12.0pt;
Font-family: "Times New Roman ";
MSO-Fareast-font-family:;
MSO-font-kerning: 1.0pt ;}
/* Page Definitions */
@ Page
{MSO-page-border-Surround-header: No;
MSO-page-border-Surround-footer: No ;}
@ Page Section1
{Size: 612.0pt 792.0pt;
Margin: 72.0pt 90.0pt 72.0pt 90.0pt;
MSO-header-margin: 361_pt;
MSO-footer-margin: 36366pt;
MSO-paper-Source: 0 ;}
Div. Section1
{Page: Section1 ;}
-->

This is actually nothing to say, because for database operations, it must take into account the existence of this problem, so there must be a solution to the problem.

 

I am also a habit of operating databases.
=
Not strict. Therefore, it may lead to a lot of passing by (in fact, it should be your own problem.

 

For example, a table

Table

"Jqt". "syn_logs"

"ID"

Number (8, 0 ),

"Type"

Number (8, 0)

Not

Null

Enable,

"Start_time"

Date

Not

Null

Enable,

"Complete_time"

Date

Not

Null

Enable,

"File"

Varchar2 (256 ),

"File_backup"

Varchar2 (256 ),

"Result"

Number (2, 0)

Not

Null

Enable,

Primary

Key

("ID ")

At this time, you need to query
File
Field, an exception occurs, and an error is inevitable.

 

The main reason is that we have not written the statement, whether it is
Golden
, Or
PL/SQL
, Or
SQL/plus
I have tried it all. Haha, the tools are used a lot, but they are not very proficient. Alas, this is also my shortcoming.

 

I am not a student now. I don't have that time. I only need to study hard after work.

 

This operation should be performed.

For example:
Select

"File"

As

SDFD

From

Syn_logs

Or:
Select

S. "file"

From

Syn_logs

S

Or:
Select

"S". "file"

From

Syn_logs

S

Of course, other statements are similar. In fact, I have answers on the Internet. I just met them, but I didn't pay attention to double quotation marks. I still have a lot to learn.

 

Continue to work hard. = Pay attention to the details. Do not forget the case sensitivity or the case sensitivity. Otherwise, errors may occur. This may also be a standard. I have not learned much and hope to understand it.