Table Create in SQL and How insert data into table
- Get link
- X
- Other Apps
Table Create in SQL and How insert data into table
we can use notepad open notpad and save file as it is which is table name like your table is "DEPT"
if you not idea about show ss in below:
create table DEPT
(
DEPTNO number(2),
DNAME varchar2(14),
LOC varchar2(13)
);
code is end here.
You can directly paste this code on sql RUN COMMAND LINE and enter. if need to make table permanently save table so after table create enter COMMIT; command with semicolon.
Above table is create without constraint.we can see another post.Now here we can see how to display created table non commad prompt or sql run command line.
Using cmd prompt enter in cmd and type "SQLPLUS" enter and ask you to enter USERNAME AND PASSWORD.during installation set password by you enter.
Here i enter USERNAME=> SYSTEM and PASSWORD=>ORACLE and enter.
You can understand following below image:
Now display table table creation.
in prompt this command write SELECT * FROM DEP; and enter if you not insert any type of data so its look like it in below image
DESC is describe table struture it use when you not insert any data into table.
- Get link
- X
- Other Apps
Popular posts from this blog
What is Python ? Intoduction of Python
Introduction of Python Python is the most used high-level programming language it's created by GUIDO VAN and first introduced in 1991. Python is contain object-oriented programming feature like java,c++ etc.Also in current time python is used for Data Science, hacking security applications and many other major areas in IT. Python used to execute the command in your terminal, using an interpreter so python use interpreter for run program. Python is open source and python is available for any Operating System like Linux, Unix, Window, MAC, Linux many more. Python is developed in the C++ Object-oriented programming language comparing other language python give you sample code and easy to understand in such are variable creation, define the function, object creation, many other areas.sum sample Arithematic operation in other languages with large and complex logic codes then Python gives this operation with small and sample logic with faster output. How v...
In Python Calculation addition,subtractions,multiplication,division,and ...
Programming in C learn sample Program
Sample program of C language with structure explanation C language is a general-purpose programming language in old-time c is know as B language that means Basic combine Programming language (BCPL). C language is found by Denis Ritchie in 1972 something and C is used Compilers for debug and run c program it is very fast executed and compile. C language generally says it is OOP means object-oriented programming language but c support some OOP concept but it is a not pure Object-oriented programming language. Basically, there are three types of Programming Languages..(1) Procedural Programming Language ...
Comments
Post a Comment
Thank you for comment and your feedback.