Oracle is missing from keyword 5

You can query some of the segmented comments in PLSQL to see if the problem is in **ah, and you can't see the problem roughly.

In addition, your writing is too complicated, can't you use join query and decode:

select ,decode(nvl(, 0), 0, 'Not turned on', 'Turned on') as status,decode(nvl(, 0), 1, 'Monthly', 'By strip') as ifbag,nvl(, 0) as addfee

from zdaddtion zd, advanceaddtion aa

where =

and = 12

select ,case

when (nvl((select

from advanceaddtion aawhere =

and=12),0))=0 then is not on'else

Turned on'end as status,casewhen (nvl((select advtypefrom advanceaddtion aawhere zdaddtionid =

and = 12),0)) = 1 then'else

By strip'end as ifbag,nvl((select feefrom advanceaddtion aawhere zdaddtionid =

and = 12),0) as addfeefrom zdaddtion zd

Grammatical errors.

This should be no problem.

select ,case nvl( ,0)

when 0 then 'Not turned on'

else 'Turned on'

end as status,case nvl( ,0)

when 1 then 'Monthly'

else 'By strip'

end as ifbag,nvl( ,0) as addfee

from advanceaddtion aa ,zdaddtion zd

where zdaddtionid= and = 12 helped you sort it out, just see for yourself!

select ,case

when (nvl((select

from advanceaddtion aawhere =

and = 12),0)) = 0 then

Not turned on'else

Turned on'end as status,case

when (nvl((select advtypefrom advanceaddtion aawhere zdaddtionid =

and = 12),0)) = 1 then

Monthly'else

By strip'end as ifbag,nvl((select fee

from advanceaddtion aawhere zdaddtionid =

and = 12),0) as addfee

from zdaddtion zd

What are you trying to do? Create a new biaoming table with the same structure as biao??

create table biaoming as select * from biao where 1 = 2;

That's it.

where is the property name behind there? Attribute name 1?

In oracle, number(m,n) can be used to achieve double precision, or double can be changed to double precision. Hope it helps.

Why not use the number type?

Please check the information below.

1. There is no dept in this table.

2, dept this table is not deptno field 3, dept table in the deptno field is the primary key 4, reference is written wrong, it should be references

If you write it wrong, you want to write it as a sql statement, but you wrote pl sqlselect sal, case when sal <1000

then 'This is a salary of less than 1000. '

when sal >=1000 and sal <1500then 'This is a salary between 1000 - 1500. '

when sal >=1500 and sal <2000then 'That's a salary between 1500-2000. '

when sal >=2000 and sal <2500then 'That's a salary between 2000 and 2500. '

when sal >=2500 and sal <3000then 'That's a salary between 2500-3000. '

when sal >= 3000

then 'This is a salary greater than or equal to 3000. '

else error'

end) as saldesc

from emp;It should be written like this, remember to add points.

I suggest you relearn PL SQL programming, what you wrote doesn't make sense.

end if;This place is not additional";"No. If you add it, it means that the SQL statement you wrote is two SQL statements.

In MySQL, the system adds a virtual table mechanism that returns only one row by default, while in Oracle the implementation is to make a default display virtual table:

select

asidfrom

dual;

There are a lot of commas missing from your SQL statement, take a closer look at the before and after case when.

Is it a field or t2 is a table, and there is a case when .end should be followed by a comma.