Home
Search results “Show tables oracle sqlplus”
SQLPLUS: LineSize & PageSize
 
03:49
In this tutorial, you'll learn how to set linesize and pagesize . PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 13162 radhikaravikumar
Oracle Database11g tutorials 14 : How to CREATE TABLE using sql developer and command prompt
 
08:36
Oracle Database11g tutorials 14 How to Create table using command prompt and Create table using sql developer Blog Link http://bit.ly/1TkY4Oe Time Line 0:25 Introduction of Tables in Database 1:03 What is Create Table (Introduction of create table) 1:30 Syntax of Create Table 2:08 How to create table using Command Prompt 4:55 How to create table using SQL Developer Links for Oracle Database tutorials 4: database connectivity using SQL developer and command prompt http://youtu.be/wSqoXRlXDUU You can have indepth knowledge about SQL create table here http://www.rebellionrider.com/sql-create-table.html Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com Today in this oracle database tutorial we will see How to CREATE A TABLE. if we have to define a table in layman language then we can say that Tables are just a collection of Rows and Columns but In RDBMS tables are database objects which help in organizing data into ROWS and COLUMNS. We can also say that SQL tables are kind of data structure which are used by database for efficient storage of data. To create a table in our database we use SQL CREATE TABLE command. SQL CREATE TABLE is a type of DATA DEFINITION LANGUAGE also known as DDL. To Create a table in your schema you will require CREATE TABLE system privilege. In our future videos we will see what are system and object privileges and how to grant them to a user. Today for this video we will be using Sample schema HR which already has all the necessary privileges. Ohk Let's see the syntax. CREATE TABLE table name ( column name1 Data-Type(size), column name2 Data-Type(size), ..... ); CREATE TABLE is an oracle reserved word or say an Oracle key word whereas There are 3 different ways of creating a table in Oracle database. Creating a table using Command Line Interface (CLI) in Oracle database For demonstrating how to create table in oracle database using CLI, I'll be using Command prompt. Thats how we create table using command prompt. you can check your table structure by DESCRIBE command for that just write DESC and your table name. Like this Another way of creating a table is by using Graphic user interface (GUI) in Oracle database To demonstrate how to create table using GUI we will use SQL developer. Lets open our SQL developer I am connected to HR schema if you do not know how to create a connection to database using SQL developer please watch my oracle database tutorial 4 that explains database connectivity using SQL developer and command prompt. Link for this video is in the description below. So lets create a table. Creating a table using SQL developer is very easy we do not have to fire any query here. Let's start First of all right click on your connection in which you want to create a table and choose schema browser. This will open a separate schema browser pane or you can expend your connection by clicking this + sign and then right click on table and choose New Table. However I prefer working with schema browser so let's skip to schema browser pane here from the first drop-down list you can choose connection name and in the second drop down list you can choose what database objects you want to work with we want to create a table thus I'll choose table and then click this arrow here and choose option for new table Ok we have created a table wizard first of all give a unique name to your table and add some column as well. For this, click the green plus button. Now we already have a column so give it some name. Also choose a datatype from the list and specify any size you can check this not null column if in case you want to make this a mandatory column you can also specify default value and constraint If you want to make this column a primary key you can click here In my future video i'll show you what are these constraints and different ways of applying them on a column in a table. for this video we will concentrate on create table only so when you are done with all your columns click ok Thats your table You can double click on your table here and can see its structure. Thats it
Views: 157068 Manish Sharma
Oracle Tutorial 1 - Part 3
 
13:16
This video shows you have to check your Oracle 11g install to make sure everything is installed correctly. You will also see how to access the SQL*Plus Window, Login and create your first table. SQL syntax and language will be discussed in the next lecture.
Views: 93652 Barbara Hecker
Oracle Database: How-To: Insert values into a Table
 
07:01
The Best Site to Learn SQL Online
Views: 31431 TechnicalSkills
PL/SQL tutorial 51: How To Create Nested Table collection in PL/SQL Block
 
07:54
RebellionRider presents PL/SQL tutorial 51 on how to create a Nested table in Oracle Database by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/nested-table-1 Previous Tutorial ► For Loop: https://youtu.be/DfAmnj2j7WI ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 17433 Manish Sharma
Tutorial Create table in SQL plus
 
02:11
Tutorial Create table in SQL plus
Views: 17550 DatabaseIAP
Oracle tutorial : How to connect oracle database using sqlplus command line
 
02:20
Oracle tutorial: How to connect oracle database using sqlplus command line sqlplus tools to connect to oracle database In this tutorial you can see using SQLPLUS commands how we can connect the oracle database . After connecting the oracle database you can able execute the sql query.
Views: 14046 Tech Query Pond
How To Insert data in Table Oracle Database Using Sqlplus [Hindi/Urdu].
 
09:28
Hi Friends !!!!! In This Video We will Show The Insert The Data Using This Commands Oracle Databse- How To Insert Values Into a Table. Insert Method_1 a) Open The Sqlplus. b) Connect The Workspace. c) Show Your Tables. Query : Select * from tab; d) Select The Table Where you want to insert data in table. e) If You Show The Coulumn Name in Your Table to follow the Query. Query : desc [Table Name]. f) Insert Data Query is : insert into [table name](Coulumn Name 1,Coulumn Name 2,......n) values('column 1 values1,' 'column1 values2',.....n); Your Row is Created. g) For Show the Table Rows Type Query : Select * from [Table Name]; Your Rows insert sucessfully. Insert Method_2 Query : Insert Into [table Name] values ('column1 values','column2 values',.......); Insert Method_3 Query : Insert Into [table Name] values ('&column1 name','&column2 name',.......); Related video Links : How to Install Java Netbeans IDE in Windows 7, 8.1, 10 [Hindi/Urdu]: https://youtu.be/jOYMNognZXM How To Install Java On Window 10, 8.1, 7 64 bit Operating System [Hindi/Urdu] : https://youtu.be/y2-g09nY33A How to install Windows 7, 8.1,10 from a flash drive or Pandrive . [Hindi/Urdu] : https://youtu.be/s4kNcirxWrc How to Make Bootable Your Pandrive [Hindi/Urdu] : https://youtu.be/BPx_Ua_aCfY How to install Oracle 11G XE On Windows 10, 8.1, 7 Operating System in [Hindi/Urdu] : https://youtu.be/-2k4QCIpIOs How to Create Table Oracle Datbase Using Sqlplus [Hindi/Urdu] : https://youtu.be/EHnAebRP6Yw How To Insert Table Oracle Database Using Sqlplus [Hindi/Urdu]: https://youtu.be/Fu0tlCml8F8 How TO DELETE ROW, MODIFY, UPDATE COLUMN, DROP TABLE in Oracle SQL Using Cmd [Hindi/Urdu]: https://youtu.be/prz9Pr0PFEg How to recover format or delete Pandrive, Sdcard, Memory Card Or Harddisk Data [Hindi/Urdu] : https://youtu.be/0GGDHVTxDh0 How to install Oracle SQl Developer And How to Connect Your Database Sql Developer[Hindi/Urdu] : https://youtu.be/608nx3mT10c How to use SQL Distinct Keyword in Cmd Or Oracle SQL Developer [Hindi/Urdu] : https://youtu.be/ofLLZ9-EG_E How to use SQL AND Or OR operator [Hindi/Urdu] : https://youtu.be/zzqDp7U3rC8 How To Use SQL Where Operation using CMD [Hindi/Urdu] : https://youtu.be/EHmL0Wa14UY How To Use SQL ASC and DESC Operation using cmd [Hindi/Urdu] : https://youtu.be/UI0hat_RMX0 For Any Query Email Add : [email protected] Facebook Page link : https://www.facebook.com/Technical-Education-4-You-144220269545756/?ref=nf&hc_ref=ART3p2EX_iIdZHm96Uz36P99q7xfycGfo54RJafY-f0O4n1bdvWU_5xGHpPrOpLepi4
SQL with Oracle 10g XE - Using DESCRIBE to View the Table Structure
 
02:44
In this video I use the DESCRIBE command to view the structure of the tables I created in a earlier video. This will show the columns and their data types. It also show the columns that are set as the primary key and fields that can except null data. This video is part of a series of videos with the purpose of learning the SQL language. For more information visit Lecture Snippets at http://lecturesnippets.com.
Views: 14565 Lecture Snippets
How to create and use database link in Oracle
 
15:50
Database link are used to connect to database which is on different host and different instance, where you cannot use schema.table_name. But it gives you the freedom to manipulate the remote database table as if they are located in you own schema. This is the first part of database link video, on next videos will show you how database link can be used in datawarehousing.
Views: 2280 Subhroneel Ganguly
Sql Tutorial - How to create Views in oracle database
 
22:59
Hi friends in my today scenario i explaining how to create view in SQL and how view help to improve performance of SQL query. Oracle database Unbeatable,Unbreakable Platform..
Views: 4662 Oracle World
List all tables in a sql server database using a query  Part 65
 
05:38
Text version of the video http://csharp-video-tutorials.blogspot.com/2013/06/part-65-list-all-tables-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-65-list-all-tables-in-sql-server.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss, writing a transact sql query to list all the tables in a sql server database. This is a very common sql server interview question. Object explorer with in sql server management studio can be used to get the list of tables in a specific database. However, if we have to write a query to achieve the same, there are 3 system views that we can use. 1. SYSOBJECTS - Supported in SQL Server version 2000, 2005 & 2008 2. SYS.TABLES - Supported in SQL Server version 2005 & 2008 3. INFORMATION_SCHEMA.TABLES - Supported in SQL Server version 2005 & 2008 -- Gets the list of tables only Select * from SYSOBJECTS where XTYPE='U' -- Gets the list of tables only Select * from SYS.TABLES -- Gets the list of tables and views select * from INFORMATION_SCHEMA.TABLES To get the list of different object types (XTYPE) in a database Select Distinct XTYPE from SYSOBJECTS Executing the above query on my SAMPLE database returned the following values for XTYPE column from SYSOBJECTS IT - Internal table P - Stored procedure PK - PRIMARY KEY constraint S - System table SQ - Service queue U - User table V - View Please check the following MSDN link for all possible XTYPE column values and what they represent. http://msdn.microsoft.com/en-us/library/ms177596.aspx
Views: 82291 kudvenkat
Oracle tutorial : Oracle DBA  How to execute sql script  using sqlplus command line
 
04:59
Oracle tutorial : Oracle DBA How to execute sql script using sqlplus command line oracle tutorial for beginners This Oracle tutorial video will show you how to run sqlplus script from command line. You can execute the script from an external file using sqlplus commands. To run a script from command line you have to path of the script file.
Views: 3668 Tech Query Pond
1.Introduction to basic SQL*Plus and SQL commands in oracle 9i
 
20:41
A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as invented by E. F. Codd, of IBM's San Jose Research Laboratory. Many popular databases currently in use are based on the relational database model.RDBMSs have become a predominant choice for the storage of information in new databases used for financial records, manufacturing and logistical information, personnel data, and much more since the 1980s. Relational databases have often replaced legacy hierarchical databases and network databases because they are easier to understand and use. However, relational databases have been challenged by object databases, which were introduced in an attempt to address the object-relational impedance mismatch in relational database, and XML databases. Object-relational database management system (ORDBMS) ============================================ An object-relational database can be said to provide a middle ground between relational databases and object-oriented databases (OODBMS). In object-relational databases, the approach is essentially that of relational databases: the data resides in the database and is manipulated collectively with queries in a query language; at the other extreme are OODBMSes in which the database is essentially a persistent object store for software written in an object-oriented programming language, with a programming API for storing and retrieving objects, and little or no specific support for querying. Object-relational database management systems grew out of research that occurred in the early 1990s. That research extended existing relational database concepts by adding object concepts. The researchers aimed to retain a declarative query-language based on predicate calculus as a central component of the architecture. Probably the most notable research project, Postgres (UC Berkeley), spawned two products tracing their lineage to that research: Illustra and PostgreSQL. Many of the ideas of early object-relational database efforts have largely become incorporated into SQL:1999 via structured types. In fact, any product that adheres to the object-oriented aspects of SQL:1999 could be described as an object-relational database management product. For example, IBM's DB2, Oracle database, and Microsoft SQL Server, make claims to support this technology and do so with varying degrees of success. SQL(Structures Query Language) ======================== SQL was initially developed at IBM by Donald D. Chamberlin and Raymond F. Boyce in the early 1970s. This version, initially called SEQUEL (Structured English Query Language), was designed to manipulate and retrieve data stored in IBM's original quasi-relational database management system, System R, which a group at IBM San Jose Research Laboratory had developed during the 1970s.The acronym SEQUEL was later changed to SQL because "SEQUEL" was a trademark of the UK-based Hawker Siddeley aircraft company. SQL*Plus ======= SQL*Plus is a command line SQL and PL/SQL language interface and reporting tool that ships with the Oracle Database Client and Server software. It can be used interactively or driven from scripts. SQL*Plus is frequently used by DBAs and Developers to interact with the Oracle database. If you are familiar with other databases, sqlplus is equivalent to: "sql" in Ingres, "isql" in Sybase and SQL Server, "sqlcmd" in Microsoft SQL Server, "db2" in IBM DB2, "psql" in PostgreSQL, and "mysql" in MySQL.
Views: 41373 DASARI TUTS
SQL: Explain Plan for knowing the Query performance
 
05:17
In this tutorial, you'll learn how to compare queries to know the better performance query..
Views: 88416 radhikaravikumar
How to access data from file - External Table - Oracle - Query Data from flat files
 
11:48
In this video we can see what is the external table, how can we use it.... How to access table from a flat file? We can access data from any type of format loaded by SQL*Loader. Code: create or replace directory External_Dir as 'D:\External'; create table External_Table ( v_num number(5), v_name varchar2(20) ) ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY External_Dir Access parameters ( RECORDS DELIMITED BY NEWLINE FIELDS TERMINATED BY ',' ) LOCATION('Sample_File.txt') );
SQL Error ORA-00942 Table or View Does Not Exist in Oracle Database
 
05:03
How to use Tab View (Data Dictionary) of Oracle Database to solve the SQL Error ORA-00942 Table or View Does Not Exist error in Oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/ora-00942 Previous Tutorial ► ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 3814 Manish Sharma
8. CREATE, INSERT and SELECT commands
 
15:42
In this video you will learn how to execute CREATE, INSERT and UPDATE commands. I will show you by executing these command and you will understand it easily. We will also cover its theory part before demo. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 113284 ITORIAN
7. Create Table in SQL (Hindi)
 
09:40
Please Subscribe Channel Like, Share and Comment Visit : www.geekyshows.com
Views: 86008 Geeky Shows
How to Connect with SQLPLUS in Oracle 11g?
 
08:25
how to open and connect with SQLPLUS in Oracle 11g? Hi friends.. In last video..we have seen , How to install oracle 11g database in windows 7 system.. Now ,we are going to know how to open and connect sqlplus... Generally Sqlplus is coming with oracle database software so we no need to install seperately... actually sqlplus provides development environment of sql/plsql... now I show u and how open and connect with sqlplus with different users.. First of all ,to open sqlplus--go to start menu-All programs--oracle db home-application development-sqlplus. as shown in video... now I connected my sqlplus with system user... now i want to connect with scott user.. Eg:connect scott/tiger... so guys ...this is the way to open and connect the sqlplus with different users... thank u ...... please watch n subscribe and like my channel https://www.youtube.com/user/prasadamudalapalli how to create Hibernate App and Save data in data table? how to download Eclipse-oxygen in windows7? how to uninstall oracle 11g in windows 7? how to download oracle 11g 64 bit in windows 7? how to step java project in Eclipse oxygen? how to configure tomcate server 9.0 in Eclipse oxygen? how to open and connect sqlplus in windows7? how to download ,install and connect sqldeveloper? how to create ,drop ,modifer user in oracle 11g?
Views: 5077 Hariprasad A
Oracle username and password and Account unlocking
 
08:37
all education purpose videos
Views: 252240 Chandra Shekhar Reddy
23. Grant, Revoke and Grant Table View to other user in Oracle
 
09:44
In this video you will learn many things in simple and easy way. Create User, Create Role, Grant Permission on Role, Pass role to user, Pass table to other user, Grant Table permissions to other user for table access etc are the points you will learn here. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 35326 ITORIAN
creating employee table in Oracle
 
04:37
employee table creation in oracle and the download link is given below:- http://clicknupload.com/ufsxmjklo6or
Views: 6329 Mohammed Abdul Farhan
Oracle tutorial : Pivot In Oracle PL SQL
 
09:06
Oracle tutorial : Pivot In Oracle PL SQL This tutorial will explain you how to use PIVOT clause in oracle. It will show you how oracle convert rows to columns dynamically oracle pivot multiple columns example of pivot table #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond
Views: 3835 Tech Query Pond
DESCRIBE or DESC Keyword in Oracle | Oracle Tutorials for Beginners
 
07:09
DESCRIBE or DESC Keyword in Oracle | Oracle Tutorials for Beginners DESCRIBE Keyword in Oracle DESC Keyword in Oracle DESCRIBE Keyword in Oracle SQL DESC Keyword in Oracle SQL DESCRIBE Keyword in SQL DESC Keyword in SQL Oracle Tutorials for Beginners Oracle SQL for Beginners Oracle Database for Beginners Oracle SQL Tutorials for Biners Oracle Database tutorials for Beginners oracle describe table structure desc table in sql server descending order in oracle how to see table structure in oracle sql developer desc command in mysql pl sql describe table desc command in sql example describe table in sql query how to see table structure in oracle sql developer desc table in sql server sql query to view table structure in oracle oracle describe table invalid sql statement describe table in sql query oracle desc table order by column name describe not working in oracle oracle show tables how to see table structure in oracle sql developer how to get table structure in oracle 11g sql query to list all tables in a database describe table in oracle sql developer sql query to view table structure in sql server oracle get list of tables in schema oracle show tables describe table structure in sql server
Views: 158 Oracle PL/SQL World
Oracle DBA Justin - How to execute sql and Sqlplus commands from an external script
 
09:33
How to execute sql and Sqlplus commands from an external script
Views: 78466 jbleistein11
SQL Tutorial - 55: The ALTER TABLE Command
 
05:30
In this tutorial we'll see how we can modify the structure of a table through the ALTER TABLE command in SQL. The command allows us to add, drop or modify fields in a table. Thanks for watching!
Views: 52211 The Bad Tutorials
Oracle Data Export and Import using DataPump expdp and impdp
 
09:38
Oracle Data Export and Import using DataPump expdp and impdp
Views: 166128 Abbasi Asif
SQL: Check Constraint
 
05:11
In this tutorial, you'll learn how to make use of check constraint. PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 9961 radhikaravikumar
SQL tutorial 41: How to UNLOCK USER in oracle Database
 
04:13
SQL tutorial on How to unlock user or schema in oracle database or how to unlock hr account/user/schema in oracle database using alter user SQL command. you can use the steps to change the password of any user in oracle database explained in detail. Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------- Blog Link: http://bit.ly/unlock-user-in-oracle -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/ Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 34321 Manish Sharma
SQL: Foreign Key Creation
 
05:56
In this tutorial, you'll learn how to create a foreign key column ....
Views: 32793 radhikaravikumar
Oracle Database11g tutorials 5:  how to retrieve Data Using SQL SELECT statement || SQL tutorials
 
05:13
This SQL tutorial and Oracle database 11g tutorial for beginners will show how to retrieve data using SQL SELECT statement. Tool used in this tutorial is SQL developer. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 You can download the Script which is used in this SQL tutorial from this link https://copy.com/yDQ46Tb64efm Contacts Email [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/RebellionRider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from The Code makers
Views: 182950 Manish Sharma
Oracle userName and password reset
 
01:41
Reset your Oracle user password .
Views: 44118 brijesh kumar
Oracle(How to create a spool file or list file in Oracle)
 
03:33
how to create a list file or spool file in oracle ...
Views: 10947 sreetheja amilineni
How TO DELETE ROW, MODIFY, UPDATE COLUMN, DROP TABLE in Oracle SQL Using Cmd [Hindi/Urdu].
 
08:03
Hi Friends !!!!! In this Video we show the How to delete table, row, update etc. Oracle Databse- a) Open The Sqlplus. b) Connect The Workspace. c) Show Your Tables. Query : Select * from tab; d) Select the table where you want to delete row. Query : Delete From [Table Name] Where id=?; e) Show Your Tables. Query : Select * from tab; 1 row delete sucessfully. f) If You Modify Your Table to follow this Query : Alter table [Table Name] modify [Column Name] varchar2(10); Your table column is modified. g) If You Update row data follow this Query Update [Table Name] set [Column Name]='row data of column' where id=?; If you delete the table follow the Query : Drop Table [Table Name]; Your table is deleted sucessfully. Related video Links : How to Install Java Netbeans IDE in Windows 7, 8.1, 10 [Hindi/Urdu]: https://youtu.be/jOYMNognZXM How To Install Java On Window 10, 8.1, 7 64 bit Operating System [Hindi/Urdu] : https://youtu.be/y2-g09nY33A How to install Windows 7, 8.1,10 from a flash drive or Pandrive . [Hindi/Urdu] : https://youtu.be/s4kNcirxWrc How to Make Bootable Your Pandrive [Hindi/Urdu] : https://youtu.be/BPx_Ua_aCfY How to install Oracle 11G XE On Windows 10, 8.1, 7 Operating System in [Hindi/Urdu] : https://youtu.be/-2k4QCIpIOs How to Create Table Oracle Datbase Using Sqlplus [Hindi/Urdu] : https://youtu.be/EHnAebRP6Yw How To Insert Table Oracle Database Using Sqlplus [Hindi/Urdu]: https://youtu.be/Fu0tlCml8F8 How TO DELETE ROW, MODIFY, UPDATE COLUMN, DROP TABLE in Oracle SQL Using Cmd [Hindi/Urdu]: https://youtu.be/prz9Pr0PFEg How to recover format or delete Pandrive, Sdcard, Memory Card Or Harddisk Data [Hindi/Urdu] : https://youtu.be/0GGDHVTxDh0 How to install Oracle SQl Developer And How to Connect Your Database Sql Developer[Hindi/Urdu] : https://youtu.be/608nx3mT10c How to use SQL Distinct Keyword in Cmd Or Oracle SQL Developer [Hindi/Urdu] : https://youtu.be/ofLLZ9-EG_E How to use SQL AND Or OR operator [Hindi/Urdu] : https://youtu.be/zzqDp7U3rC8 How To Use SQL Where Operation using CMD [Hindi/Urdu] : https://youtu.be/EHmL0Wa14UY How To Use SQL ASC and DESC Operation using cmd [Hindi/Urdu] : https://youtu.be/UI0hat_RMX0 For Any Query Email Add : [email protected] Facebook Page link : https://www.facebook.com/Technical-Education-4-You-144220269545756/?ref=nf&hc_ref=ART3p2EX_iIdZHm96Uz36P99q7xfycGfo54RJafY-f0O4n1bdvWU_5xGHpPrOpLepi4
Simple SQL statements Create,insert into, delete ,update table myslq command line
 
07:30
Perform some basic data manipulation statements with mysql database, Show databases; create database create table describe table insert into Select delete update
Views: 66813 ITStart2000
How to Create Table Oracle Datbase Using Sqlplus [Hindi/Urdu].
 
04:22
Hi Friends !!!!! In this video we will show the how the create table using sqlplus usin this command. Open cmd type Sqlplus enter First connect the Database Enter workspace name entre password Show of all the table in your database is query is a) Select * from tab; Create table Query is b) Create table Student_Information( E_name varchar2(25), E_ID number(10), E_Designation varchar2(20)); Where Student_Information is table name Related video Links : How to Install Java Netbeans IDE in Windows 7, 8.1, 10 [Hindi/Urdu]: https://youtu.be/jOYMNognZXM How To Install Java On Window 10, 8.1, 7 64 bit Operating System [Hindi/Urdu] : https://youtu.be/y2-g09nY33A How to install Windows 7, 8.1,10 from a flash drive or Pandrive . [Hindi/Urdu] : https://youtu.be/s4kNcirxWrc How to Make Bootable Your Pandrive [Hindi/Urdu] : https://youtu.be/BPx_Ua_aCfY How to install Oracle 11G XE On Windows 10, 8.1, 7 Operating System in [Hindi/Urdu] : https://youtu.be/-2k4QCIpIOs How to Create Table Oracle Datbase Using Sqlplus [Hindi/Urdu] : https://youtu.be/EHnAebRP6Yw How To Insert Table Oracle Database Using Sqlplus [Hindi/Urdu]: https://youtu.be/Fu0tlCml8F8 How TO DELETE ROW, MODIFY, UPDATE COLUMN, DROP TABLE in Oracle SQL Using Cmd [Hindi/Urdu]: https://youtu.be/prz9Pr0PFEg How to recover format or delete Pandrive, Sdcard, Memory Card Or Harddisk Data [Hindi/Urdu] : https://youtu.be/0GGDHVTxDh0 How to install Oracle SQl Developer And How to Connect Your Database Sql Developer[Hindi/Urdu] : https://youtu.be/608nx3mT10c How to use SQL Distinct Keyword in Cmd Or Oracle SQL Developer [Hindi/Urdu] : https://youtu.be/ofLLZ9-EG_E How to use SQL AND Or OR operator [Hindi/Urdu] : https://youtu.be/zzqDp7U3rC8 How To Use SQL Where Operation using CMD [Hindi/Urdu] : https://youtu.be/EHmL0Wa14UY How To Use SQL ASC and DESC Operation using cmd [Hindi/Urdu] : https://youtu.be/UI0hat_RMX0 For Any Query Email Add : [email protected] Facebook Page link : https://www.facebook.com/Technical-Education-4-You-144220269545756/?ref=nf&hc_ref=ART3p2EX_iIdZHm96Uz36P99q7xfycGfo54RJafY-f0O4n1bdvWU_5xGHpPrOpLepi4
SQL with Oracle 10g XE - Using CREATE TABLE to Build a Table
 
08:17
In this video I use the CREATE TABLE command to create three tables: Books, Publisher, and Author. I use these three tables as sample data. The code I entered in is: CREATE TABLE BOOK ( BOOK_ID VARCHAR(4) PRIMARY KEY, ISBN_10 VARCHAR(10), ISBN_13 VARCHAR(13), TITLE VARCHAR(50), CATEGORY VARCHAR(15), PRICE DECIMAL(6,2), BINDING VARCHAR(1), PUB_DATE VARCHAR(4), AUTHOR_ID SMALLINT, PUBLISHER_ID SMALLINT ); CREATE TABLE PUBLISHER ( PUBLISHER_ID SMALLINT PRIMARY KEY, PUBLISHER_NAME VARCHAR(40) ); CREATE TABLE AUTHOR ( AUTHOR_ID SMALLINT PRIMARY KEY, AUTHOR_LAST VARCHAR(25), AUTHOR_FIRST VARCHAR(20) ); I have to create each table individually in the SQL commands window. This video is part of a series of videos with the purpose of learning the SQL language. For more information visit Lecture Snippets at http://lecturesnippets.com.
Views: 97892 Lecture Snippets
How to Create SCOTT Schema and default tables in Oracle Database 11g
 
04:31
Looking for a best Webhosting Company at low and Best Service click this link:https://www.ipage.com/join/index.bml?AffID=739220 From Last Few Months I Was Looking For Best Webshosting Company Where I Can Host My 100 Of Website At Low Price And With Best Quality Service , And Then I Came To Know About https://www.ipage.com/join/index.bml?AffID=739220 A Hosting Company Where I Get Hosting For Unlimited Domains At Just 1.6$ Per Month With Control Panel , 24hrs Support And All In All A Best Platform To Host Any Website( one-click install wordpress option) .Dont Be Late Offer Valid Till 25th October 2014 , Host Your WebSite With Best Service Provider Today By Clicking The Link Above Or Here: https://www.ipage.com/join/index.bml?AffID=739220 To get a responsive and Modern design contact http://www.variabletips.com and get at just 20$ Now !!! Check my Website: http://variabletips.com for more details. If there is no Oracle default scott schema is available after the installation of Oracle 11g database in windows, Then how to create the scott schema and the default tables like emp , dept, bonus, salgrade in database. Here is a easy step by step tutorial to create it in your database. Open the sql plus in your system. Login as username : sys as sysdba and the password which is given at the time of installation. After connected to Oracle database you need to create the scott schema. Run this script: CREATE USER scott IDENTIFIED BY tiger; scott is the user tiger is the password. Grant all access to user scott,run this script: GRANT ALL PRIVILEGES TO scott; Download the Oracle default tables file: https://www.dropbox.com/s/m9lr8cnc00vqy3i/oracle.zip https://drive.google.com/file/d/0BxJYa0O21A_udlZqQmNZaFBvNTA/edit?usp=sharing Extract the downloaded file in your system. Then Connect to Scott user as: CONNECT scott Password: tiger Then type this in your sql command prompt: @(extract file path)\oracle.sql; for example: @C:\Users\ABC\oracle\oracle.sql; Now you done all the steps completely and you can work with scott schema and all the default tables. Check This in your system to show all the tables in scott user: Select * from tab; After that you can see all the default table in scott user. Just run it to show the default data inside the tables. Select * from emp; If 14 row selected....Then You sucessfully Created the scott schema and the default Oracle tables in your system. Like and subscribe this video: http://www.youtube.com/watch?v=vHcAs7k93AQ
Views: 16837 variabletips
Oracle Database 12c R2 - SQL*Plus History Command
 
03:41
Oracle Database 12c Release 2 New Features for DBAs and Developers
Views: 377 Mahir M. Quluzade
Oracle Tutorial | Oracle SQL Data Dictionary
 
07:06
This Oracle tutorial demonstrates how to issue SQL statements to find metadata about the tables you own. We'll take a look at the USER_TABLES, USER_CONSTRAINTS, and USER_CONS_COLUMNS data dictionary views. We'll be using SQL*Plus as our interface rather than a graphical tool such as Toad or SQL Developer. Get certified in Oracle by taking an Oracle training course with Firebox. https://www.fireboxtraining.com/oracle
Views: 2190 Firebox Training
How to create an user and to grant all privileges to them in Oracle database
 
03:52
This video shows you how to create a new user and to grant privileges to them. Syntax to create a new user: create user username identified by password
Views: 30976 Thamizh arasaN
SQL Server join :- Inner join,Left join,Right join and full outer join
 
08:11
For more such videos visit http://www.questpond.com See our other Step by Step video series below :- Learn Angular tutorial for beginners https://tinyurl.com/ycd9j895 Learn MVC Core step by step :- http://tinyurl.com/y9jt3wkv Learn MSBI Step by Step in 32 hours:- https://goo.gl/TTpFZN Learn Xamarin Mobile Programming Step by Step :- https://goo.gl/WDVFuy Learn Design Pattern Step by Step in 8 hours:- https://goo.gl/eJdn0m Learn C# Step by Step in 100 hours :- https://goo.gl/FNlqn3 Learn Data structures & algorithm in 8 hours :-https://tinyurl.com/ybx29c5s Learn SQL Server Step by Step in 16 hours:- http://tinyurl.com/ja4zmwu Learn Javascript in 2 hours :- http://tinyurl.com/zkljbdl Learn SharePoint Step by Step in 8 hours:- https://goo.gl/XQKHeP Learn TypeScript in 45 Minutes :- https://goo.gl/oRkawI Learn webpack in 50 minutes:- https://goo.gl/ab7VJi Learn Visual Studio code in 10 steps for beginners:- https://tinyurl.com/lwgv8r8 Learn Tableau step by step :- https://tinyurl.com/kh6ojyo Preparing for C# / .NET interviews start here http://www.youtube.com/watch?v=gaDn-sVLj8Q In this video we will try to understand four important concepts Inner joins,Left join,Right join and full outer joins. We are also distributing a 100 page Ebook ".Sql Server Interview Question and Answers". If you want this ebook please share this video in your facebook/twitter/linkedin account and email us on [email protected] with the shared link and we will email you the PDF.
Views: 754128 Questpond
How to create a new user in SQL command line,Granting privileges & Revoking privileges from the user
 
14:31
Title: How to create a new user in SQL command line,Assigning Privileges(Granting)(Select,Insert,Update,Delete) to the user and Removing privileges(Revoke) from the user. Created by: Hardik M.Parmar, Lecturer,Computer Engg.Dept., J.H.Desai Polytech,Palsana
Views: 23729 Hardik Parmar
SQL, copy table from  one user to another user, lesson 13
 
05:39
How to copy a table from one user to another user or from one database to another database in oracle
Views: 8742 hammadshams
Unix tutorial : Unix Shell Script to connect Oracle database
 
05:00
Unix tutorial : Unix Shell Script to connect Oracle database This tutorial will show you how to connect oracle database using the command line in Unix. Here Unix shell scripting is used to connect the database using the sqlplus command. And you can see how to retrieve data from database using the shell script 1)Oracle tutorial : How to connect oracle database using sqlplus command line https://www.youtube.com/watch?v=N2DAK2ty8Gc 2)Job In Oracle : pl sql create job in Oracle Scheduler https://www.youtube.com/watch?v=Nwmt5S4Mod8&t=248s You can learn useful shell scripts for oracle dba oracle scripts for dba in unix oracle dba scripts Subscribe on youtube: https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA For more tutorial please visit #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond
Views: 18204 Tech Query Pond