| Use of q' In Oracle | Q' in Oracle | Alternative Quoting Mechanism in Oracle

Описание

In This Video We will understand Quoting Mechanism in Oracle and the use of Q'

Scripts are Given below
--------------------------------------
Use of q' in oracle
-----------------------------
It's a dog. you aren't good.They'll come tomorrow.I don't want to play chess.

select 'It''s a dog. you aren''t good.They''ll come tomorrow.I don''t want to play chess' from dual;

select q'{It's a dog. you aren't good.They'll come tomorrow.I don't want to play chess}' from dual;

select q'(It's a dog. you aren't good.They'll come tomorrow.I don't want to play chess)' from dual;

select q'[It's a dog. you aren't good.They'll come tomorrow.I don't want to play chess]' from dual;

create table str_values(value_list varchar2(1000));

insert into str_values values ('It''s a dog. you aren''t good.They''ll come tomorrow.I don''t want to play chess');

insert into str_values values (q'{It's a dog. you aren't good.They'll come tomorrow.I don't want to play chess}');

commit;

select * from str_values;

LIKE THE FACEBOOK PAGE - https://www.facebook.com/Oracle-Tutorials-108483330680405/
FOLLOW ON Instagram - https://www.instagram.com/nihar8308/
FOLLOW ON LinkedIn - https://www.linkedin.com/company/oracle-tutorials/?viewAsMember=true
FOLLOW ON TWITTER - https://twitter.com/NIHARRA59094760

Email Id: nihar.tution@gmail.com
Phone No- 8018319781

#Use_of_Q'
#Oracle_Alternative_Quoting
#Oracle_SQL_PLSQL_Concept