Home
Search results “Tables dba oracle”
Oracle DBA - Tables
 
04:27
http://oracledbazerotopro.com This tutorial talks about tables and table types.
Views: 15107 HandsonERP
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: 165090 Manish Sharma
Oracle DBA - Tablespaces
 
10:54
http://oracledbazerotopro.com This tutorial explains Oracle Tablespaces.
Views: 80637 HandsonERP
Oracle - using External Tables
 
06:02
Learn how to use External table to load TXT and XML files. More videos: http://www.learn-with-video-tutorials.com/oracle-working-with-external-files
What is an Oracle Schema - Database Tutorial 58 - Oracle DBA Tutorial
 
10:48
What is an Oracle Schema - Database Tutorial 58 - Oracle DBA Tutorial An Oracle Schema is a generic user which is used to store the data. It starts as an user. But once the objects are created beneath this user, then this user becomes a schema. Other Oracle users will be given access to these schema objects so that they can work with these objects.
Views: 25930 Sam Dhanasekaran
Oracle Interview Questions: Dual table in Oracle
 
08:10
This video is the 2nd video in the video series Oracle Interview questions.It explains dual table in oracle along with the advantages that it offers. Below tutorial explains how you can generate test data in oracle using oracle table and hierarchical queries. https://www.youtube.com/watch?v=Lf8m9lXNPnc&t=25s
Views: 1539 Tech Coach
Oracle DBA   Tables
 
04:27
Views: 12 Vinod Kumar
Oracle DBA, 1e22 -How to undrop a table in Oracle 11 g
 
06:31
The video will describe how to undrop table in Oracle 11g using flashback
Views: 518 hammadshams
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: 101582 Lecture Snippets
Oracle Administration Tutorial - Understanding Tablespaces and Datafiles (Theory).mp4
 
09:03
Oracle Administration Tutorial - Understanding Tablespaces and Datafiles
Views: 43450 maurice ford
CREATE TABLE and INSERT Records into TABLE
 
08:28
The Best Site to Learn SQL Online.
Views: 65945 TechnicalSkills
Oracle - Tables - Advanced
 
16:43
Oracle - Tables - Advanced
Views: 2396 Chris Ostrowski
How to work with Tablespaces in Real-Time? Tablespace Administration
 
01:00:59
https://dbagenesis.com/p/oracle-11g-advanced-dba Oracle tablespace administration - Learn how to work on tablespaces in real-time. - Tablespace management tasks - Tablespace utilization - Add space to tablespace - Add new tablespace - Tablespace best practices - Drop tablespace A tablespace is constructed by Oracle from one or more operating system files through the use of the CREATE TABLESPACE command. Every Oracle database consists of at least one tablespace, called SYSTEM.
Views: 13565 DBA Genesis
Oracle 18c New Feature Focus - Private Temporary Tables
 
31:38
Oracle 18c brings us Private Temporary Tables. A Private Temporary Table is stored in memory and is visible only to the session that created it and is dropped at the end of the session or transaction depending on the setup. In this webinar OCP DBA John Mullins will cover the creation and management of Private Temporary Tables along with their benefits and restrictions. In addition, Private Temporary Tables will be compared to Global Temporary Tables. Get the slides from this and other webinars at: https://www.themisinc.com/webinars
Views: 19 Themis Education
Creating a table in oracle 10g - wingslive
 
02:12
creating a table in SQL*PLUS.
Views: 8703 wingslive
Oracle Data Integrator 12c - Creating a Project and Mapping: Flat File to a Table (Recorded Webcast)
 
55:39
This is the second in a series of three OLL Live recorded webcasts in the Oracle Data Integrator 12c: Getting Started series. The tutorials are located at https://apex.oracle.com/pls/apex/f?p=44785:24:0::::P24_CONTENT_ID,P24_PREV_PAGE:7952,1. There are many ways to get a flat file of data into an Oracle Database. For example, SQL*Loader is one of the proprietary tools included in many versions of Oracle Database. The problem is that other versions of other databases (such as IBM DB2, or Microsoft SQL Server) use different proprietary tools. ODI provids one standard way of importing files into many different databases. Furthermore, SQL*Loader is designed to take the data in unmodified, whereas ODI is designed to transform the data while it is being loaded. This webcast walks you through the steps that are needed to use Oracle Data Integrator Studio (ODI Studio) graphical tools to export an ASCII flat file of columnar data to an Oracle Database 12c relational table. Copyright © 2013 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
Table Compression Enhancement in Oracle Database 11g R2
 
05:00
Table Compression: Overview Oracle Database supports three methods of table compression: 1.Basic table compression 2.OLTP table compression Oracle Corporation recommends to compress all data to reduce storage costs. The Oracle database can use table compression to eliminate duplicate values in a data block. For tables with highly redundant data, compression saves disk space and reduces memory use in the database buffer cache. Table compression is transparent to database applications. The table_compression clause is valid only for heap-organized tables. The COMPRESS keyword enables table compression. The NOCOMPRESS keyword disables table compression. NOCOMPRESS is the default. With basic compression, the Oracle database compresses data at the time of performing bulk load using operations such as direct loads or CREATE TABLE AS SELECT. With COMPRESS FOR OLTP, the Oracle database compresses data during all DML operations on the table.
Views: 2230 Saurabh Joshi
Oracle Tablespaces - Database Tutorial 56 - Oracle DBA Tutorial
 
07:56
Oracle Tablespaces - Database Tutorial 56 - Oracle DBA Tutorial This video explains about Oracle Tablespaces. Oracle Tablespaces are the storage containers where the objects such as Tables, Indexes etc will be stored. A Tablespace is formed using one or mode data files. A Data file can belong to only one Tablespace. But a Tablespace can have multiple data files.
Views: 1266 Sam Dhanasekaran
Global Temporary Tables in Oracle Database - DBArch Video 21
 
16:02
Learn about Global Temporary Tables in Oracle Database. You will learn the internals of Global Temporary tables in Oracle database, and also a demo for the same. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 3987 Ramkumar Swaminathan
Oracle DBA | How To Export & Import Tables/Schema/Database | Conventional Backup | Bangla | DBA2-02
 
12:34
Oracle DBA | How To Export & Import Tables/Schema/Database | Conventional Backup | Bangla | DBA2-02 To See More DBA part-01 Tutorial Click here https://www.youtube.com/playlist?list=PLXXvCMuixAJUO3yQq7-LLdfQb5HpsQKNg To See More DBA part-02 Tutorial Click here https://www.youtube.com/playlist?list=PLXXvCMuixAJUviefN3-ZzKDVgbIH0RoaS To See More Reports Tutorial Click here https://www.youtube.com/watch?v=y_0f_iILlmY&list=PLXXvCMuixAJUfU4ZISmPtHrmKe5qRvyVY To See More Forms Tutorial Click here https://www.youtube.com/watch?v=Zsu4CWo_vwk&list=PLXXvCMuixAJU3Ap_FE2zSEBicv8IC5kDU Dear viewer, In this tutorial you will learn How To Export & Import Tables or Schema or Database in Oracle Database. Step1: User Creation: command - sql-create user asd identified by asd; sql-grant dba to asd; Step2: Export/Backup: Run cmd command- exp Step3: Import/Restore: Run cmd command- imp To Get more Tutorial Subscribe The Channel click here https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?sub_confirmation=1 To Get All Post Like The Facebook Page Click here https://www.facebook.com/oracledbsolutions Follow us: Facebook: https://www.facebook.com/oracledbsolutions Youtube link: https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?view_as=subscriber Facebook Group: https://www.facebook.com/groups/465557066961548 Contact us: email: [email protected] Skype: oracle26solutions Mob: 01734557080, 01627422780
Views: 61 OracleDB Solutions
SQL Tutorial - 9: Create Table Statement
 
07:48
In this tutorial we'll learn to create tables in SQL using the CREATE TABLE Statement.
Views: 274046 The Bad Tutorials
Simplified DBA-011-How to see Structure of a Table in SQL Developer
 
02:23
we will create a table inset some rows explore table structure Table creation script: CREATE TABLE PROFESSIONALS( ID number(5) primary key, NAME varchar2(20), PROFESSION varchar2(30) ); Data entry script: INSERT into PROFESSIONALS values (1001, 'Ansari' , 'Oracle DBA'); INSERT into PROFESSIONALS values (1002, 'Raheemuddin' , 'System Administrator'); INSERT into PROFESSIONALS values (1003, 'Moin' , 'System Engineer'); COMMIT;
Exports - Imports Utility step by step
 
22:22
In this video i'm going to show you how to use Exports - Import Utility, Schema lever, Table Level and Full Database Level step by step.
Views: 26182 OCP Technology
Oracle DBA - Solve Long Running Query & TX Row Lock Contention | Performance Tuning
 
09:19
How to Solve Row Lock Contention in Oracle Database - Performance Tuning - Oracle DBA Solve Row Lock Contention & Long Running Query in Oracle Database - Performance Tuning Oracle DBA - Performance Tuning Row Lock Contention Please Like, Comment, Subscribe and Share... Boxcut Media.
Views: 4455 BoxCut Media
Database Tutorial 62 - SQL CTAS method - Oracle DBA Tutorial
 
05:16
Database Tutorial 62 - SQL CTAS method - Oracle DBA tutorial, Oracle Database Tutorial This video explains about CTAS (Create Table As Select) method.
Views: 1577 Sam Dhanasekaran
Locating Table Storage in Oracle
 
08:58
How to locate the file (or files) in which a table has been stored using the Oracle system catalog views.
Views: 678 Stephen Frein
Oracle DBA, Export  data as CSV file, 1e19
 
06:30
How to export data as a CSV (comma separated value) file using SQLPLUS utilih
Views: 9546 hammadshams
How DBA FLASHBACK TABLES Hands-on STEP by STEP
 
10:33
Please watch: "R language 2018" https://www.youtube.com/watch?v=Ws12M1sNZBM --~-- http://www.zulqarnainhayat.com https://www.udemy.com/oracle-12c-backup-and-recovery-zero-to-hero/?couponCode=ORABACKUP_PROMO Learning Windows Server 2016 with Hands-On Experience https://www.udemy.com/learning-windows-server-2016-with-hands-on-experience/?couponCode=WIN2016_ADV Learning vSphere 6.0 VCP Lab with VMware Workstation Hand-On https://www.udemy.com/learning-vsphere-60-vcp-lab-with-vmware-workstation-hand-on/?couponCode=VCP_2018 ORACLE 12C:Oracle Real Application Cluster https://www.udemy.com/oracle-12coracle-real-application-cluster/?couponCode=ORA_12CRAC Learning Linux Advanced Disk Systems: RHCE CERT Prep https://www.udemy.com/learning-linux-advanced-disk-systems-rhce-cert-prep/?couponCode=LINUX7_DISKLVM Oracle Database 12c : Basic SQL Hand-On Step by Step https://www.udemy.com/oracle-database-12c-basic-sql-hand-on-step-by-step/?couponCode=ORAC12_SQL Oracle Database 12c Cloud: Advanced SQL Hands-On https://www.udemy.com/oracle-database-12c-cloud-advanced-sql-hands-on/?couponCode=ORACLE_ADV2018 Microsoft SQL Server 2017: Linux, Docker and macOS Hands-On https://www.udemy.com/microsoft-sql-server-2017-linux-docker-and-macos-hands-on/?couponCode=SQL2017_MAC2018 Oracle Database 12C Security:Data Protection and Encryption https://www.udemy.com/oracle-database-12c-securitydata-protection-and-encryption/?couponCode=ORAC12C_SEC Oracle 12C: Backup and Recovery Zero to Hero Microsoft SQL Server Databases 2016 From Zero to Hero https://www.udemy.com/microsoft-sql-server-databases-2016-from-zero-to-hero/?couponCode=SQL2016_PROM2018 Oracle Cloud Database Release 2 on Oracle Cloud https://www.udemy.com/oracle-cloud-and-oracle-12c-database-release-2-new-features/?couponCode=ORACLOUD12C_PROMO CentOS 7 Linux Administration: Go from Beginner to Advanced https://www.udemy.com/centos-7-administration-go-from-beginner-to-advanced/?couponCode=CENTOS2018 Oracle 12C Database Administration With Hands on Experience https://www.udemy.com/oracle-12c-database-administration-with-hands-on-experience/?couponCode=ORACLE_12CDBA Hands on Linux 7 setup for Oracle 12C Database Zero to Hero https://www.udemy.com/hands-on-linux-7-setup-for-oracle-12c-database-zero-to-hero/?couponCode=ORACENV2018
Views: 19 Zulqarnain Hayat
Oracle DBA Justin - How to re-create the special table dual in an Oracle database # 1 of 2
 
13:47
How to re-create the special table dual in an Oracle database
Views: 2853 jbleistein11
Creating  Managing  Droping Oracle Database Tablespaces
 
12:10
Creating Managing Droping Oracle Database Tablespaces select tablespace_name,block_size,status,contents,logging from dba_tablespaces; create tablespace mytbs datafile 'd:\oradata\dbrdbms\mytbs01.dbf' size 10m; alter tablespace mytbs add datafile 'd:\oradata\dbrdbms\mytbs02.dbf' size 10m; alter tablespace mytbs drop datafile 'd:\oradata\dbrdbms\mytbs02.dbf'; desc v$datafile; desc ts#,name from v$datafile; select ts#,name from v$tablespace; select v$datafile.ts#,v$datafile.name,v$tablespace.name from v$datafile,v$tablespace where v$datafile.ts#=v$tablespace.ts# and v$tablespace.name='MYTBS'; alter database datafile 'd:\oradata\dbrdbms\mytbs01.dbf' resize 20m; ALTER DATABASE DEFAULT TABLESPACE mytbs; select ts#,name from v$tablespace; select ts#,name from v$datafile; select ts#,name from v$tablespace; drop tablespace mytbs; drop tablespace mytbs ialtncluding contents and datafiles; drop tablespace mytbs including contents and datafiles cascade; alter tablespace mytbs read only; alter tablespace mytbs read write; alter tablespace mytbs force logging; alter tablespace mytbs nologging; alter tablespace mytbs flashback on; alter tablespace mytbs flashback off; purge tablespace mytbs user myuser;
Views: 20236 Abbasi Asif
Oracle Indexes - Beginner
 
12:12
Oracle Indexes - Beginner
Views: 63274 Chris Ostrowski
Oracle DBA Justin - How to re-create the special table dual in an Oracle database # 2 of 2
 
03:33
How to re-create the special table dual in an Oracle database
Views: 1449 jbleistein11
Securing a Schema from DBA Access on Oracle Database 12c
 
03:54
In this video, you create a simple security configuration for a sample Oracle database schema. The EMPLOYEES table has information that should be hidden from most employees in the company. To accomplish this, add the secured objects to a realm. Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
Finding Database Columns By Name in Oracle SQL Developer
 
05:11
How to find all columns in your Oracle Database by searching on the name.
Views: 5139 Jeff Smith
Tablespace Management
 
15:02
Tablespace management Tasks
Views: 34856 DbaRocksOracle
How to Create database,table,insert,update,delete in Sql server 2008 R2
 
14:23
How to Create database,table,insert,update,delete ,through sql query How to insert data in table
Views: 238101 Programming School
Oracle SQL Developer Web: CREATE and EDIT TABLEs
 
13:03
Demonstration of using Oracle SQL Developer Web's GUIs for creating a new table or editing an existing table - all in your browser.
Views: 554 Jeff Smith
MySQL DBA Training 21 Partitioned Tables in MySQL
 
14:37
MySQL DBA Training Agenda of the Session Includes MySQL Partitioning concepts, Horizontal partitioning in MysQL, Vertical partitioning in MySQL, Choosing a Partitioning Method, MySQL Partitioning Range partition, MySQL Partitioning List Partition, MySQL Partitioning Hash Partition, MySQL Partitioning - Key Partition Partition Management Commands. To Learn or Teach Linux visit www.theskillpedia.com, A Marketplace for Learners and Trainers. To know about me visit my profile at www.rnsangwan.com. I deliver online training on Business Analysis, Linux, Unix, MySQL, Sybase, SQL Server, Perl, Python, R Data Analysis, Scala etc,
Views: 1864 TheSkillPedia
dba interview questions & answer in oracle | Ten Minute Code
 
05:04
Top Oracle DBA Interview Questions & Answer 1. Oracle DBA Characteristics Criteria Result Main storage structures Logical and Physical Architecture Grid architecture ACID Compliance Fully compliant Data stored as Data blocks, extents, segments and table spaces 2. What is Oracle? Oracle is a company. Oracle is also a database server, which manages data in a very structured way. It allows users to store and retrieve related data in a multi user environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery. A standby database is a database replica created by taking a backup of a primary database. 3. What is a Oracle Database? Oracle provides software to create and manage the Oracle database. The database consists of physical and logical structures in which system, user, and control information is stored. The software that manages the database is called the Oracle database server. Collectively, the software that runs oracle and the physical database are called the Oracle database system. A database buffer cache stores the data in memory for quicker access. The redo logs track and store all the changes made to the database. A Data Guard ensures data protection and high availability of data and control file records the physical structure of the database. Click on the above link to read more and to become a Oracle DBA. 4. What are the roles of DBA? DBA has the authority to create new users, remove existing users or modify any of the environment variables or privileges assigned to other users. • Manage database storage • Administer users and security • Manage schema objects • Monitor and manage database performance • Perform backup and recovery • Schedule and automate jobs 5. What are different Oracle database objects? • TABLES • VIEWS • INDEXES • SYNONYMS • SEQUENCES • TABLESPACES 6. What are the benefits of ORDBMS? The objects as such can be stored in the database. The language of the DBMS can be integrated with an object- oriented programming language. The language may even be exactly the same as that used in the application, which does not force the programmer to have two representations of his objects. 7. What is an Oracle index? An index is an optional structure associated with a table to have direct access to rows, which can be created to increase the performance of data retrieval. Index can be created on one or more columns of a table. 8. What are the Common Oracle DBA Tasks? As an Oracle DBA, you can expect to be involved in the following tasks: • Installing Oracle software • Creating Oracle databases • Performing upgrades of the database and software to new release levels • Starting up and shutting down the database • Managing the database’s storage structures • Managing users and security • Managing schema objects, such as tables, indexes, and views • Making database backups and performing recovery when necessary • Proactively monitoring the database’s health and taking preventive or corrective action as required • Monitoring and tuning performance In a small to midsize database environment, you might be the sole person performing these tasks. In large enterprise environments, the job is often divided among several DBAs, each with their own area of specialty, such as the database security administrator or database tuning expert. 9. List out the Tools for Administering the Database? The following are some of the products, tools, and utilities you can use in achieving your goals as a database administrator. -Oracle Universal Installer (OUI) The Oracle Universal Installer installs your Oracle software and options. It can automatically launch the Database Configuration Assistant to install a database. -Database Configuration Assistant (DBCA) The Database Configuration Assistant creates a database from templates that are Oracle supplied, or you can create your own. It enables you to copy a preconfigured seed database, thus saving the time and effort of customizing and generating a database from scratch. -Database Upgrade Assistant This tool guides you through the upgrade of your existing database to a new Oracle release. -Oracle Net Manager This tool guides you through your Oracle Net network configuration. -Oracle Enterprise Manager The primary tool for managing your database is Oracle Enterprise Manager, a web-based interface. After you have installed the Oracle software, created or upgraded a database, and configured the network, you can use Oracle Enterprise Manager as the single interface for managing your database. In addition, Oracle Enterprise Manager also provides an interface for performance advisors and an interface for Oracle utilities such as SQL*Loader and Recovery Manager.
Views: 295 10 Minute Code
PL/SQL tutorial 16: Table Auditing using DML Triggers in Oracle PL/SQL
 
09:55
Learn Table Auditing using DML Triggers in Oracle Database and Increase the level of security by keep an eye on user tempering your table data. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/table-auditing Previous Tutorial ► DML Triggers with Examples https://youtu.be/-OR7zLzCh_I ► Select-Into Statement: https://youtu.be/F5eMJhwmCQs ►Sysdate Blog : http://bit.ly/sysdate-in-oracle-by-rebellionrider ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►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 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/rebellionrider/ You can also Email me at for E-mail address please check 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: 63538 Manish Sharma
SQL with Oracle 10g XE - Table Overview and Basic Data Types
 
05:34
In this video I take a look at the structure of tables I plan on using for my database and point on the relational links between the tables. I also discuss the primary key of the table as well as using it as a foreign key in a related table. I take a look at a few basic data types for field columns to include: CHAR = 255 characters VARCHAR = 255 characters SMALLINT = -32,768 to 32,767 INT = -2,147,483,648 to 2,147,483,647 DECIMAL = Numbers with a decimal value Date = In the format DD-MMM-YYYY 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: 17116 Lecture Snippets
How to backup the tables from ORACLE Part-I
 
05:20
This video will explain you how to backup the tables from oracle...!
Views: 607 Thamizh arasaN
Oracle SQL Developer Tutorial For Beginners  12   What is a Table
 
02:00
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 2878 Sam Dhanasekaran
Oracle DBA | Adding Data File Existing Table Space | Bangla | DBA1-15
 
04:01
Oracle DBA | Adding Data File Existing Table Space | Bangla | DBA1-15 To See More DBA part-01 Tutorial Click here https://www.youtube.com/playlist?list=PLXXvCMuixAJUO3yQq7-LLdfQb5HpsQKNg To See More DBA part-02 Tutorial Click here https://www.youtube.com/playlist?list=PLXXvCMuixAJUviefN3-ZzKDVgbIH0RoaS To See More Reports Tutorial Click here https://www.youtube.com/watch?v=y_0f_iILlmY&list=PLXXvCMuixAJUfU4ZISmPtHrmKe5qRvyVY To See More Forms Tutorial Click here https://www.youtube.com/watch?v=Zsu4CWo_vwk&list=PLXXvCMuixAJU3Ap_FE2zSEBicv8IC5kDU Dear viewer, In this tutorial you will learn Adding Data File Existing Table Space Adding Data File: Command: Connect sysdba SQL-alter tablespace test1 add datafile 'E:\app\Administrator\oradata\orcl\dfile2.dbf' size 500m; To Get more Tutorial Subscribe The Channel click here https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?sub_confirmation=1 To Get All Post Like The Facebook Page Click here https://www.facebook.com/oracledbsolutions Follow us: Facebook: https://www.facebook.com/oracledbsolutions Youtube link: https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?view_as=subscriber Facebook Group: https://www.facebook.com/groups/465557066961548 Contact us: email: [email protected] Skype: oracle26solutions Mob: 01734557080, 01627422780
Views: 47 OracleDB Solutions
What is Index Scan ,Index Seek and Table Scan?
 
06:34
An index scan or table scan is when SQL Server has to scan the data or index pages to find the appropriate records. index seek happens when data is searched among the index.Please watch full video for detail.
Views: 16210 SqlIsEasy
01. SELECT - ORACLE DBA TAMIL TUTORIAL
 
07:57
BASIC SELECT STATEMENT IN ORACLE
Views: 2430 ORACLE DBA TAMIL
Importing Data from Excel into Oracle Database using SQL Developer 4.1
 
02:23
One of SQL Developer’s most popular features has undergone a significant upgrade. Users can quickly define and recall delimited or Excel files to be imported to a new or existing Oracle table. Data preview and validation is provided for each column, as well as ‘best guess’ data type and date format mask mapping. This process can now be automated via the SQL Developer command line interface (SDCLI) ‘Import’ command. NOTE: This is a video only. There is no audio. Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.