The select statement output 'It' s OK! Several methods of '

CodePudding user response:

Select 'OK' from dual


Dbms_output. Put_line (' OK ');

CodePudding user response:

SQL> Select 'It' s OK from dual;

'IT' ' 'SO
-- -- -- -- -- -- --
It's OK

CodePudding user response:

SQL> Select concat (' It ' 's' and 'OK') from dual;

CONCAT ('
-- -- -- -- -- -- -- --
It 's OK



SQL> Select the 'It' 's' | | 'OK' from dual;

'IT' 'S' |
-- -- -- -- -- -- -- --
It 's OK

CodePudding user response:

reference 1st floor wmxcn2000 response:

select 'OK' from dual


Dbms_output. Put_line (' OK ');