Home > database >  Oracle fetch column dynamic alias
Oracle fetch column dynamic alias

Time:09-16

The select sysdate as April from dual

As of April to dynamic, now is April points is displayed if the system time behind in May as we shall show in May

CodePudding user response:

1, according to the system time set variables (judgment is April or may)
2, the dynamic SQL to run your statement to execute

CodePudding user response:

Judging from the front desk is not better?

CodePudding user response:

Content and the field name that is to say, show should agree, what is the point, this to implement but difficult,

CodePudding user response:

As defined as the name of the variable and then behind the front, to obtain the value of this variable later on as
  • Related