HomeОбразованиеRelated VideosMore From: way2study

SQL with Oracle 10g XE #1 Creating Student Database!!!

39 ratings | 6032 views
hello guys I will show you how to create student database in oracle database software thank you so much for watching don't forget to like share comment and subscribe code part: create table studentdb(regno number(10) primary key, name varchar(20), dob date, marks number(10)); desc studentdb; alter table studentdb drop column marks; desc studentdb; alter table studentdb modify regno varchar2(20); desc studentdb; alter table studentdb add phoneno number(10); desc studentdb; insert into studentdb values (001,'kiran','06-aug-1991',8899007766); insert into studentdb values (002,'anbu','07-aug-1991',8899007755); insert into studentdb values (003,'prabhu','08-aug-1991',8899007744); insert into studentdb values (004,'nigam','09-aug-1991',8899007733); insert into studentdb values (005,'suraj','10-aug-1991',8899007722); select * from studentdb; please type commands carefully if you face any doubt don't feel shy to ask me thank you so much guys
Html code for embedding videos on your blog
Text Comments (8)
Mehwish Shaikh (1 month ago)
Yeh toh backend naw, nd this is type of coding but how to connect it with the frontend application ??? How to represent the output of the project
way2study (30 days ago)
Sql is a backend Language if you wanna connect it with frontend you need frontend tool to connect like visual basic or java tools.in that you will find exe option to create a project
Asad Javed (2 months ago)
Please help me sir ,how i can add bar code in oracle 6i reports
Asad Javed (2 months ago)
when your came you new video ? which using barcode ?
Asad Javed (2 months ago)
thanks and how to get price item and print bill slip
way2study (2 months ago)
THANK YOU WATCHING MY VIDEO I WILL TELL YOU HOW TO ADD BAR CODE I ORACLE 6I IN MY NEXT VIDEO PLEASE SUBSCRIBE MY CHANNEL
Piyush Verma (11 months ago)
How to add this back end with the front end in JAVA
way2study (11 months ago)
this is very simple you need to go inside oracle software and use reference option and refer to java file I will automatically save data base from java to oracle.i will make a video about this soon...thank you so much for watching if u didn't subscribed yet please subscribe and press bell icon to don't miss my new videos

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.