PL/SQL tutorial 5: PL/SQL Constants in Oracle Database By Manish Sharma RebellionRider.com

[@priyadharshiniak1554]

You are making the concepts CRYSTAL CLEAR :-)

[@AbhishekYadav-rt8kh]

Thanks sir, due to you I am able to understand pl/sql code otherwise I was totally not interest in pl/sql. Again thank to you.

[@mohinisonawane991]

....your all tutorials are very usefull..... but please upload more about pl/sql....

[@indranilgoswami3042]

Excellent tutorial Sir ..great work

[@priyadarshaniswain7840]

can we only initialize a constant value using default keyword or it also works with variables

[@Naruto-wx3jn]

To perform operations (pl/sql) on students table or any table firstly should we create table for students i.e in sql ?

[@kadel2322]

Good day! Im new with pl/sql may i ask a question about the data width, why is it 2 values? "(7,6)" Is it range?

[@manish9589]

Thanks again! Waiting for new one, till then no study :-).

[@marukurthiharikrishna-ih6zv]

Bro I want to practice this queries so please suggest me a Android compiler to practice them

[@akashdeshmukh8883]

short and awesomely explained

[@priyankajain9587]

Question 1) if I don't assign any value to constant what will happen at time of Accessibg those value in dbms_output statement exccution 2) what is difference between default and := in cobtext of constant 3) what happen if I try to assign null to not null 4) what happen if I don't assign value to not null constant

[@ananyieie]

Thankyou so much sir!!

[@soumyajitbanerjee1440]

Hello, Pl-sql commands are not working in oracle 10g express edition,Why??

[@harshjain1207]

Can you please explain "number(7,6)" . What does 7 and 6 stand for??

[@AmitKumar-ux1mz]

Harsh Jain 7 means, the number is 7 digits long. 6 implies that 6 digits of the total 7 are after(right) of the decimal point!

[@chammarasilva]

Thank you Amit Kumar :)

[@sarmisthabhowmick9774]

​@@AmitKumar-ux1mzThank you so much 😊

[@rajraj-rv6ii]

Hi Manish, Your videos are too good and easily understandable. I also want to upload some tutorials into youtube but whenever i record videos i am getting background noise like Vehicles outside, system noise , click noise etc., . Please provide me suggestions in developing quality videos like you do Thanks in advance

[@ahmadfaiaz3427]

SET SERVEROUTPUT ON; is not working in my sqldeveloper where it work on sql command line

[@edwinsuarez5057]

Friend Manish, nice to meet you. First of all I want to thank you for sharing your knowledge, they have been of great help to me in my learning process ... In this video of the constant, I make the example and the procedure runs perfectly, except that it does not show me the content of the variable v_pi, it is as if the command DBMS_OUTPUT.PUT_LINE (v_pi); it will not work

[@kavyasingh455]

that happens when youre not using set serveroutput on

[@AakashPanditOfficial]

Why the (7,6) for during declaration?

[@priyadarshaniswain7840]

what is the meaning of datatype(4 , 7)

[@guicsou]

if a constant can not be changed on execution time, why should we prevent assign null values using the 'NOT NULL' statement? i know, the propose of this video is knowledge and we can use it in all types of variables, but, how is this usefull, on a constant, in a real exemple?

[@sridhardurairaj2317]

super video and easy understandle

[@gurpreet092]

One question-Can we use Default while assigning value to variable?

[@azhagujayanthi]

Same question can anyone answer

[@harishkataria11]

Sir aapke dwara likhi gyi koi pdf file mil Sakti h kya

[@sreenathreddy8747]

is it oracle 10g

[@gangadharmalana6932]

what is the use of default keyword pls can anyone explain....

[@shaheenshaikh6701]

Sir can u plz explain how to add column in table

[@gummadinagalakshmi4083]

By using alter command we can add a columns in pl/sql

[@hakimuddinr4693]

what is data width after data type? number(7,6)

[@Simmlex]

It's how you define a non whole number. 7 is the full length of the number and 6 is the length of the fraction.

[@anusuyaperumal2155]

@@Simmlex thank you

[@harmanbawa19]

Thanks

[@Naruto-wx3jn]

To perform operations (pl/sql) on students table or any table firstly should we create table for students i.e in sql ?

[@Naruto-wx3jn]

To perform operations (pl/sql) on students table or any table firstly should we create table for students i.e in sql ?

[@Naruto-wx3jn]

To perform operations (pl/sql) on students table or any table firstly should we create table for students i.e in sql ?

[@Naruto-wx3jn]

To perform operations (pl/sql) on students table or any table firstly should we create table for students i.e in sql ?