A 5 minute video. *A FIVE MINUTE VIDEO TEACHED ME THE SYNTAX OF ORCALE SQL, SOMETHING MY UNI LECTURERS HAVE NOT DONE IN THE ENTIRE COURSE WHERE I HAVE AN ASSIGMENT NOW DUE IN WHICH I'M PAYING OVER 9000 USD A YEAR FOR.* Thank you Caleb.
from what i know VARCHAR will take the whole space for 50 character meaning if you have a name thats 7 characters long their will be 43 empty space after in that column , VARCHAR2 will end after 7 character not leaving behind any empty spaces after. its more neat
VARCHAR is reserved by Oracle to support distinction between NULL and empty string in future, as ANSI standard prescribes. VARCHAR2 does not distinguish between a NULL and empty string, and never will. ... VARCHAR can store up to 2000 bytes of characters while VARCHAR2 can store up to 4000 bytes of characters.
You are able to put whatever columns that you want. The distinction between lower case and upper case helps us determine which things are keywords, and which things are made by us. The user_id is a column that I decided to make. I could have just as easily added a column such as birthdate, birthday, or age. By convention, every column is given an ID if we are using surrogate primary keys (in this case, we are). That means we will tell the database that it can generate a number for us for each row that has no real world meaning (outside of the database, that is).
A 5 minute video. *A FIVE MINUTE VIDEO TEACHED ME THE SYNTAX OF ORCALE SQL, SOMETHING MY UNI LECTURERS HAVE NOT DONE IN THE ENTIRE COURSE WHERE I HAVE AN ASSIGMENT NOW DUE IN WHICH I'M PAYING OVER 9000 USD A YEAR FOR.*
Thank you Caleb.
amen
can relate
rel
School for computer science fucking sucks. Or at least it does for me. If it weren't for that piece of paper that said I graduated I wouldn't be here.
from what i know VARCHAR will take the whole space for 50 character meaning if you have a name thats 7 characters long their will be 43 empty space after in that column , VARCHAR2 will end after 7 character not leaving behind any empty spaces after. its more neat
VARCHAR is reserved by Oracle to support distinction between NULL and empty string in future, as ANSI standard prescribes. VARCHAR2 does not distinguish between a NULL and empty string, and never will. ... VARCHAR can store up to 2000 bytes of characters while VARCHAR2 can store up to 4000 bytes of characters.
You are very good at teaching and catching my attention, thank you.
What a comprehensive video!!!!! thank you so much! Keep on posting such informative videos please
Thanks buddy, you are awesome.. Your teaching pattern or style is supperb. ❤ from India
Thanks for your videos.. learning database was never this fun
That's a realy good start, and i love this video ta.
Good explanation , thanks !
Thanks for all these great videos. Well done!
Thank you for making this video.
Excellent video, man. Thank you
where do i find the beginning of this tutorial? im trying to start from the first lesson but cant find it
nice job bro!!
thanks:)
thankyou!!!!!!!!!!!!!
For the *CREATE TABLE* keyword, can we only make use of the following: name_id, username, first_name, etc. Or do we create our own unique ones?
You are able to put whatever columns that you want. The distinction between lower case and upper case helps us determine which things are keywords, and which things are made by us. The user_id is a column that I decided to make. I could have just as easily added a column such as birthdate, birthday, or age.
By convention, every column is given an ID if we are using surrogate primary keys (in this case, we are). That means we will tell the database that it can generate a number for us for each row that has no real world meaning (outside of the database, that is).
CalebTheVideoMaker2 Thanks, that's really helpful. :)
No problem!
can you please post the exact link for downloading that particular vesion of oracle?
hi, does it is important to form different table for entities from EER model.
Is this oracle procedural language?
SELECT 'YAY! So fun!' FROM DUAL
How To CREATE TABLE using graphical interface in oracle 12c
constraint?
if I change "varchar2" to " text"
hello sir, I have created an acount for installing oracle but i can not sign in i dont know wt the reason
I don't think you need to create an account. Check out the video in the beginning of this series on how to install Oracle.
You need to confirm your account through your email for verification
is this tutorial for oracle 11g or 10
11g +
stackoverflow.com/questions/1171196/what-is-the-difference-between-varchar-and-varchar2
This is the answer for using 'VARCHAR2'
Step by step ja n
Bhokat ja