Home
Search results “Oracle current schema”
Oracle DBA Justin - How to set the current session's schema.
 
15:38
How to set the current session's schema
Views: 2667 jbleistein11
Oracle Database Performance Tuning - Optimizer Statistics Gathering - 11g, 12c
 
04:51
Oracle Database Performance Tuning - Optimizer Statistics Gathering - 11g, 12c In this video we explain how to gather the database optimizer statistics #performancetuning, #oracledatabase, #oracle, #database, #optimizerstatistics, #learning, About Optimizer Statistics Collection In Oracle Database, optimizer statistics collection is the gathering of optimizer statistics for database objects, including fixed objects. The database can collect optimizer statistics automatically. You can also collect them manually using the DBMS_STATS package. Oracle Database Performance Tuning - Optimizer Statistics Gathering - 11g, 12c Purpose of Optimizer Statistics Collection The contents of tables and associated indexes change frequently, which can lead the optimizer to choose suboptimal execution plan for queries. To avoid potential performance issues, statistics must be kept current. To minimize DBA involvement, Oracle Database automatically gathers optimizer statistics at various times. Some automatic options are configurable, such enabling AutoTask to run DBMS_STATS. Oracle Database Performance Tuning - Optimizer Statistics Gathering - 11g, 12c Stats collection Stats gathering database performance tuning, 10g, 11g 12c database administration
Views: 629 KINGS TUBE
how to copy all table of a schema to other schema in oracle
 
09:06
create user grant privilege copy all table of a schema to a new schema
Oracle username and password and Account unlocking
 
08:37
all education purpose videos
Views: 290480 Chandra Shekhar Reddy
Oracle Training - Oracle Video Tutorial | Installing the SCOTT schema | Oracle Tutorials
 
06:51
Learn how to how to install the SCOTT schema. https://fireboxtraining.com/blog/ . This free Oracle video tutorial is on Installing the SCOTT schema on an Oracle database running on Windows. Learn how to install the SCOTT schema on Oracle 8i, 9i, 10g, or 11g. See more IT training Videos at https://www.fireboxtraining.com/blog. Firebox Training offers a wide variety of Oracle Training, including Weblogic Administration 10g ---------- Oracle 11g Database OCA Oracle 11g Administration OCP Oracle 11g New Features Oracle 10g Database Admin Oracle 10g New Features Workshop Oracle 10g RAC Admin ---------- Oracle BI Building Repositories OBIEE Reports & Dashboards ---------- Oracle 11g Intro to Programming Oracle 11g Intro to SQL Oracle 11g - Intro to PL/SQL Oracle 11g ADF ---------- Oracle 10g Intro to Programming Oracle 10g Intro to SQL Programming Oracle 10g Advanced SQL Oracle 10g SQL Oracle 10g Intro to PL/SQL Oracle 10g PL/SQL Oracle 10g Advanced PL/SQL Oracle Apex 3.1 ----------- Oracle 10g ADF Read the course outlines at https://www.fireboxtraining.com/oracle-training-bootcamps-courses
Views: 13626 Firebox Training
How to find out the SID and DB Home in Oracle Database by Manish Sharma
 
05:10
What is my SID, Where is my DB Home in Oracle Database? Are these questions haunting you? Here's How to find out the SID and DB Home in Oracle Database by Manish Sharma from RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/sid_dbHome Previous Tutorial ► How to connect to your Pluggable Database using SQL Developer https://youtu.be/1gvN1A6xnxU ------------------------------------------------------------------------- ►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 #Oracle18cByRebellionRider #RebellionRider
Views: 1926 Manish Sharma
System Change Number in Oracle Database - SCN - DBArch Video 26
 
02:45
In this video you will understand what is System Change Number in an Oracle Database, and get to know about some of the uses of it. . 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: 6293 Ramkumar Swaminathan
Source Control Oracle Schemas
 
02:14
Schema Compare for Oracle enables you to store the structure of your schemas in your version control system. In a few clicks you can generate creation scripts for each object and store the files in your version control system. You and your team can then track modifications, view differences side-by-side and share or revert changes. Throughout your deployment process, Schema Compare for Oracle saves you time and gives you greater visibility over the changes you make. http://www.red-gate.com/or
Views: 879 Redgate Videos
29-ORACLE SQL 10g (Manage Schema Objects) By Eng-Helal Ahmed
 
36:28
29-ORACLE SQL 10g (Manage Schema Objects) By Eng-Helal Ahmed www.facebook.com/free4arab http://www.free4arab.com http://twitter.com/free4arab1 https://plus.google.com/114278484973373035289/posts نور الهدى لتكنولوجيا المعلومات
Oracle tutorial : Pseudo columns in Oracle PL SQL (pseudo column)
 
07:56
Oracle tutorial : Pseudo columns in Oracle PL SQL ( pseudocolumn ) oracle tutorial for beginners rownum in oracle This video will show you what is Pseudo columns in Oracle PL SQL. Pseudo columns are likes ROWNUM, ROENUM, ROWID, NEXTVAL,SYSDTAE , USER etc. pseudocolumn examples Oracle tutorial : Pseudo columns in oracle Oracle supports several special-purpose data elements that are not actually contained in a table, but are available for use in SQL statements. Here is a partial list of pseudo-columns in Oracle a)CURRVAL : When using Oracle SEQUENCE values, the pseudo-column CURRVAL returns the current value of the sequence. for example: schema.sequence_name.CURRVAL b)NEXTVAL :When using Oracle SEQUENCE values, the pseudo-column NEXTVAL returns the next value of the sequence and causes the sequence to increment by one. for example: schema.sequence_name.NEXTVAL c)ROWNUM:ROWNUM returns a number indicating the order in which a row was selected from a table. d)ROWID: ROWID returns the rowid (binary address) of a row in a database table. e)USER :This pseudo-column will always contain the Oracle username under which you are connected to the database. f)SYSDATE:This pseudo-column will contain the current date and time. This column is a standard Oracle DATE datatype. The value represents the current time on the server not the client. For more tutorial please visit #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond
Views: 1605 Tech Query Pond
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: 189606 Manish Sharma
How to add hr schema in oracle DBMS ?
 
04:36
http://www.4shared.com/file/IEO9AkEE/hr_oracle.html
Views: 8039 MrXROOT
How to Rename an Oracle Database Name Manually steps by steps | Oracle Tutorial
 
06:53
Hello Friends in this video i'm going to demonstrate you how to rename oracle database manually step by step. #renameoracle #database #ocptechnology Oracle Interview application https://play.google.com/store/apps/de... My Facebook page https://www.facebook.com/ocptechnology My Second Channel https://www.youtube.com/4usupport My Instagram https://www.instagram.com/ocptechnology/ My Website http://ocptechnology.com/ My twitter https://twitter.com/ocptechnology
Views: 1801 OCP Technology
Oracle DBA Justin - How to create a basic user account in an Oracle database
 
11:57
How to create a basic user account in an Oracle database
Views: 21231 jbleistein11
SQL tutorial 61: SEQUENCE in Oracle Database By Manish Sharma RebellionRider
 
08:05
This tutorial is all about Sequence In Oracle Database. In this SQL Tutorial you will learn How to create a sequence How to populate a Primary key column (auto increment in Oracle) using Sequence How to drop a sequence ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/sql-sequence-in-oracle-database-rebellionrider-manish-sharma Previous Tutorial ► How To Insert Data into Table using SQL Developer http://youtu.be/YYQCSV6MzTk ► INSERT INTO Command http://youtu.be/uQXgqFtxI_k ► How to copy /Insert data into a table from another table http://youtu.be/m3Ep8tAMqok ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►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: 46200 Manish Sharma
Oracle 11g DBA Bangla Tutorial |Ch9_4-Managing Schema Objects | Database Management System |Training
 
41:24
See the Description for required source code and links Oracle DBA Tutorial Source Code of Oracle Database Training: https://drive.google.com/open?id=0Bz0MNaVyRm3lOFBQdE9EOWJFSnc Chapter-9 : Managing Schema Objects. In this chapter, you will know about oracle data types, types of constraints, create and modify table, create and modify index, temporary tables, customer database schema and schema object. The constraint, index and customer database schema is a important in oracle. Oracle DBA training including database design is special computer training designed online courses on Database Management System. It is fully bangla tutorial of Oracle 11g database administration. It will be much helpful for every database programmer and administrator. Subscribe this channel to watch my all tutorials on PHP, MYSQL, Javascript, Linux, Networking, Access Programming & Microsoft Office, C++, HTML, CSS. Oracle Database Administration PDF eBook Link : https://drive.google.com/open?id=0Bz0MNaVyRm3la2dYR1A1SlRiVlk All Source Codes & Required Documents together are found in the link: https://drive.google.com/open?id=0Bz0MNaVyRm3ldTUwaTd4cjVka0k Oracle DBA Tutorials: https://www.youtube.com/playlist?list=PLUYY2piVmub6bRM0ScQMNnbyH66yrh1cf Oracle - SQL Tutorial link: https://www.youtube.com/playlist?list=PLUYY2piVmub7QL0ET2_eg4D_SV3AOsPHT Channel Link: http://www.youtube.com/channel/UCT_fWLNX67sDH3W3FZ1wxLg?sub_confirmation=1 Required Document Link : https://drive.google.com/open?id=0Bz0MNaVyRm3lTWNhMURIbFV1MjA FB Page: https://www.facebook.com/BanglaTutorial24 FB Group: https://www.facebook.com/groups/banglatutorial24/ N.B: In the video tutorial, I have tried to describe steps to create index, customer database schema, schema object, constraint, tables in oracle database. [SQL TUTORIAL, DATABASE MANAGEMENT SYSTEM, BANGLA TUTORIAL, TRAINING, DATABASE, ORACLE DBA]
Views: 258 MD. SHARIFUL ALAM
Oracle DBA Justin - How to put an Oracle database in restricted session mode
 
09:30
How to put an Oracle database in restricted session mode
Views: 2586 jbleistein11
Toad for Oracle Schema browser how you will get the detail of database object ,log on schema
 
06:35
Toad for Oracle Schema browser how you will get the detail of database object ,log on schema,others schema,user
Views: 9354 Abinash Sahoo
Oracle Drop database
 
02:27
A short video on how you can drop an Oracle database using drop database command from SQL*PLUS
Views: 1619 André Karlsson
Oracle DBA Justin - How to change the name of an Oracle database # 1 of 2
 
16:11
How to change the name of an Oracle database
Views: 10208 jbleistein11
Schema
 
01:56
Oracle users can choose to browse owner objects, Accessible Schema Objects and All Schemas of their choice with ease
Views: 148 SQLFLY
Oracle DBA Justin - How to setup a database user to be identified externally with os authentication
 
14:10
How to setup a database user to be identified externally with os authentication
Views: 5492 jbleistein11
01 Oracle database Table lock
 
20:58
Purpose Use the LOCK TABLE statement to lock one or more tables, table partitions, or table subpartitions in a specified mode. This lock manually overrides automatic locking and permits or denies access to a table or view by other users for the duration of your operation. Some forms of locks can be placed on the same table at the same time. Other locks allow only one lock for a table. A locked table remains locked until you either commit your transaction or roll it back, either entirely or to a savepoint before you locked the table. A lock never prevents other users from querying the table. A query never places a lock on a table. Readers never block writers and writers never block readers. See Also: Oracle Database Concepts for a complete description of the interaction of lock modes COMMIT ROLLBACK SAVEPOINT Prerequisites The table or view must be in your own schema or you must have the LOCK ANY TABLE system privilege, or you must have any object privilege on the table or view. ROW SHARE ROW SHARE permits concurrent access to the locked table but prohibits users from locking the entire table for exclusive access. ROW SHARE is synonymous with SHARE UPDATE, which is included for compatibility with earlier versions of Oracle Database. ROW EXCLUSIVE ROW EXCLUSIVE is the same as ROW SHARE, but it also prohibits locking in SHARE mode. ROW EXCLUSIVE locks are automatically obtained when updating, inserting, or deleting. SHARE UPDATE See ROW SHARE. SHARE SHARE permits concurrent queries but prohibits updates to the locked table. SHARE ROW EXCLUSIVE SHARE ROW EXCLUSIVE is used to look at a whole table and to allow others to look at rows in the table but to prohibit others from locking the table in SHARE mode or from updating rows. EXCLUSIVE EXCLUSIVE permits queries on the locked table but prohibits any other activity on it. NOWAIT Specify NOWAIT if you want the database to return control to you immediately if the specified table, partition, or table subpartition is already locked by another user. In this case, the database returns a message indicating that the table, partition, or subpartition is already locked by another user. WAIT Use the WAIT clause to indicate that the LOCK TABLE statement should wait up to the specified number of seconds to acquire a DML lock. There is no limit on the value of integer. If you specify neither NOWAIT nor WAIT, then the database waits indefinitely until the table is available, locks it, and returns control to you. When the database is executing DDL statements concurrently with DML statements, a timeout or deadlock can sometimes result. The database detects such timeouts and deadlocks and returns an error.
Views: 934 Md Arshad
Oracle DBA Justin - How to setup user password complexity in an Oracle database
 
13:14
How to setup user password complexity in an Oracle database
Views: 3609 jbleistein11
SQL Developer: Install and configure SQL Developer on windows | How to install SQL Developer
 
15:52
How to install Oracle SQL Developer in Windows 7 Oracle 11g Express & SQL Developer Install How to Download and Install Oracle SqlDeveloper Install and Configure Oracle SQL Developer on Windows Follow me: https://www.facebook.com/munir.du https://twitter.com/munir_du https://www.linkedin.com/in/md-munir-hussain Contact me: [email protected] How to configure SQL Developer on windows ----------------------------------------------------------------------- Oracle SQL Developer is a free integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle. SQL Developer supports Oracle Database 10g, 11g, and 12c More details: http://www.oracle.com/technetwork/developer-tools/sql-developer/what-is-sqldev-093866.html Requirements for SQL Developer: a. Oracle database 10g or 11g or 12c b. JDK8 or above To download and synchronize SQL Developer 4.1.3 on windows using the following steps: At first, Install JDK8 Download required (32/64 as per your system) JDK8 from: http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html Extract sqldeveloper-4.1.3.20.78-no-jre Download SQL Developer from: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html Now, copy this folder named sqldeveloper Then copy to Oracle home directory Open this folder Create shortcut for SQL Developer: Right click on sqldeveloper.exe Then send to desktop(create shortcut) To configure: Run SQL Developer by double clicking You need to a connection: Click on green plus (+)sign for connection Enter following information: Connection name: your connection name like HR Username: hr (your username) Password: hr (your password) Click on Save Password check box Hostname: localhost (my database is install in this machine only, so my host name is localhost.) Port: 1521 (default port number) SID: xe (global database name or your ORACLE_SID) Click on Test button for testing and debugging above information Click on Save than Connect button for connection, if your test status is success. That’s it. Thanks for linking, commenting, sharing and watching more of our videos.
Views: 21798 Leen's Tech
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: 8788 Manish Sharma
Oracle DBA Justin - How to create a basic VPD policy
 
14:13
How to create a basic VPD policy
Views: 6247 jbleistein11
Oracle DBA Justin - How to disable and re-enable an Oracle database trigger
 
08:27
How to disable and re-enable an Oracle database trigge
Views: 1688 jbleistein11
Oracle: How-to: Change the PAGESIZE and LINESIZE in SQL*Plus
 
02:09
The Best Site to Learn SQL Online
Views: 20296 TechnicalSkills
Oracle DBA Justin - Oracle database internals - Dynamic performance views
 
22:15
Oracle dataase internals - Dynamic performance views
Views: 6972 jbleistein11
Oracle DBA Justin - How to determine which databases are currently connected to an ASM instance
 
11:51
How to determine which databases are currently connected to an ASM instance
Views: 4217 jbleistein11
Oracle DBA Justin - How to drop/delete a tablespace from an Oracle database
 
16:10
How to drop/delete a tablespace from an Oracle database
Views: 3532 jbleistein11
Oracle Apex 5: Create workspace on Oracle Apex 5.1
 
10:02
Create workspace on Oracle Apex 5.1: ============================== Oracle Application Express is Oracle's primary tool for developing Web applications with SQL and PL/SQL. Using only a web browser, you can develop and deploy professional Web-based applications for desktops and mobile devices. Create Workspace First, you need to log in the administration system of Oracle APEX in order to declare a Workspace. A Workspace will work with a SCHEME in database. Workspace contains Applications including a system of forms, reports, and so on, managing users who participate in programming, or users who use the application. • Open your internet browser, then write following URL in address bar for log in http://localhost:8080/apex/apex_admin • After log in, You need to create new Workspace: Click on create workspace • Enter: Workspace Name: my_ws Then click Next. • You can select a SCHEMA available in Database. Here I create a new SCHEMA named my_ws with password my_ws, and Re-use existing schema? No, then click on Next. • In the previous step, you created a SCHEMA named my_ws. It means 1 user database is created and named my_ws. • In this step, you need to declare a administration User of Workspace. It is not a user database, but it is a administration user of this Workspace. It is capable of creating applications, other Users as programmers, or users who use the application... Enter: User Name: my_ws_admin Password: my_ws_admin Email: [email protected] Then click Next. And then confirm your request by clicking Create Workspace, Finally click on Done. Note: Your Workspace has been created. You can see the list of current Workspace and edit if you want. • To find your workspace: Click on Manage Workspaces, Find Workspace Work with Workspace • In the above step, you created a Workspace named my_ws. Now we will log in and work with this Workspace: Open your internet browser, and then write following URL in address bar for log in http://localhost:8080/apex Enter: Workspace: my_ws User Name: my_ws_admin Password: my_ws_admin Then click Next. • In the first time of logging in Workspace, the system requires you to change your password, but you can keep your password intact • You are logged in my_ws Workspace Follow me: https://www.facebook.com/leens.tech https://www.facebook.com/munir.du https://twitter.com/munir_du https://www.linkedin.com/in/md-munir-hussain Contact me: [email protected] Download Oracle Database 11g R2 from: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html Download Oracle Apex 5 from: http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html
Views: 5053 Leen's Tech
SQL Tutorial For Beginners : What is SYS_CONTEXT in Oracle with Example
 
04:24
What is SYS_CONTEXT in Oracle with Example What is SYS_CONTEXT Function? Syntax: SYS_CONTEXT( namespace, parameter [, length] ) SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 451 TechLake
Oracle DBA Justin - How to manually expire a user account's password in an Oracle database
 
04:35
How to manually expire a user account's password in an Oracle database
Views: 2543 jbleistein11
Oracle CURRENT_DATE Function
 
01:54
https://www.databasestar.com/oracle-date-functions/ The Oracle CURRENT_DATE function is used to return the current date in the session timezone. The session timezone is the timezone that the current user is logging in from. This can be different from the database’s timezone. The syntax of the CURRENT_DATE function is: CURRENT_DATE No parameters are needed - just the function name. The function returns a DATE data type, and it includes hours, minutes, and seconds. This is good to know because the default display format for DATE does not include the time component, and it can be easy to forget. It’s different to the SYSDATE function as SYSDATE returns the date in the database timezone, and CURRENT_DATE returns the date in the session time zone. So, if I’m logging in from Melbourne, Australia, and the database is in London, England, then the CURRENT_DATE will return a date and time that’s 10 hours ahead of SYSDATE. It may be on the same day, or it could be a different day, depending on when I run the function. You can perform arithmetic on this function just like any other date value (e.g. CURRENT_DATE - 7 for 7 days ago). For more information about the Oracle CURRENT_DATE function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-date-functions/
Views: 138 Database Star
How to use Code Analysis in Toad for Oracle
 
08:09
https://www.quest.com/products/toad-for-oracle/ Learn how to use Code Analysis in Toad for Oracle.
Views: 1143 Quest
Oracle DBA Justin - How to drop/delete an Oracle database via the DBCA
 
06:28
How to drop/delete an Oracle database via the DBCA
Views: 2517 jbleistein11
ORACLE 12C Online Training || Domain Constraints || Class - 12 || by Dinesh
 
46:58
oracle tutorial oracle tutorial by dinesh oracle dba tutorial by dinesh oracle dba training videos oracle 11g tutorial oracle 11g tutorial by dinesh oracle 11g architecture explanation oracle 12c tutorial for beginners oracle 12c new features oracle 12c installation on linux oracle 12c architecture oracle 12c installation oracle 12c dba training videos oracle 12c rac installation on linux
PL/SQL tutorial 18: DDL Trigger with Schema Auditing Example
 
08:12
Learn how to create a DDL Trigger in Oracle Database with Schema Auditing Example where we will learn how to keep an any on which object is created, altered or drop and by who. Manish Sharma From RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/DDL-Trigger Previous Tutorial ►PL/SQL Tut 14 Triggers Introduction https://youtu.be/R3fvX_xf5P4 ► PL/SQL Tut 17 Table Backup Using DML Trigger https://youtu.be/jSv1LIlNKU0 ------------------------------------------------------------------------- ►►►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: 49895 Manish Sharma
Oracle DBA Justin - Oracle database internals - Data dictionary
 
19:49
Oracle database internals - Data dictionary
Views: 3376 jbleistein11
Oracle DBA Justin - How to startup an Oracle database
 
24:03
How to startup an Oracle database
Views: 10099 jbleistein11
Oracle DBA Justin - How to drop/delete a basic PL/SQL procedure
 
07:43
Oracle DBA Justin - How to drop/delete a basic PL/SQL procedure
Views: 1464 jbleistein11
How to download/install oracle database (software) 11g release 2 on Windows 10 Pro 64 bit
 
08:13
How to install oracle database 11g on Windows 10 Pro 64 bit, I'll explain the detail steps for downloading the oracle database 11g Release 2 then how to install it step by step. after that I will show you how to access oracle database(software) using SQL*Plus. thanks for watching. Subscribe for more: ---------------------------------- https://goo.gl/oL45FT SWE.Safaa Al-Hayali - saf3al2a TAGS: #How_to_install_oracle_database_11g_on_Windows_10_Pro_64_bit ----------------------------------------------------------------------------------------------------
Views: 200312 Safaa Al-Hayali
Oracle DBA Justin - How to disable variable substitutions in Sqlplus
 
07:21
How to disable variable substitutions in Sqlplus
Views: 1128 jbleistein11
Accessing Oracle HR schema : sqlvids
 
01:30
How to access Oracle HR schema (Oracle Hello World database)? Creating new connection in SQL Developer. More tutorials for beginners are on http://www.sqlvids.com
Views: 10427 sqlvids
Oracle Architecture
 
04:11
This video describes the best architecture of the oracle after trying more than times to Oracle structure I decided to produce an animated video let's start first with the database structure on the left side you have the client here on the right side you have to serve a two-year the server side is divided in three main structures to memory the logical structure and the physical structure so let's use SQL Plus application to provide you every step up a transaction will be using Scott sample schema it is important to note that the whole string is an alias and not a database name district will be compared to this alias inside of a file called pianist named doc or this file is similar to a DNS and with up pain all the necessary detail to reach a database server locally a user process will be allocated and will validate the connection through a listener the listener will be in charge to allocate a server process the user processes da link to the server process let's now execute our first transaction for this example we will execute an update first to state that will be validated we call this step the parsing this server process sense back to confirmation of the parsing that statement with be written into their share pool and the redo log buffer an execution plan will also be created it to the fair share Paul that database book they choose fought the transaction will be read and copy into the database buffer cache only that feel implicated in that transaction will be held it to a - segment till the transaction is completed we call those copies the before image a copy of this block will be duplicated with the updated feel this copy is called me after image a confirmation will be sent to to use a process the commit statement will complete the transaction and will be written into to redo log buffer to commit statement triggers the log writer process and we'll send all statement for the current transaction into the redo log file the before image into undo segment could be then deleted went that threshold up to undo retention parameters reach alaskan from Asian will be sent to the user process went to current law kiss Paul it generates a switch lock triggering at the same time the archiver process and to log sequence number the archiver will generate and archive the file with the content of the current loc a switch up with them trigger a checkpoint process that will incriminate the checkpoint number by applying this last number into each data file header the checkpoint process with finally trigger the database writer process enright the last image from that database buffer cache into thirty people
Views: 21876 Ezylearning
DML Triggers in Oracle - Row Level Trigger - Statement Level Trigger - Triggers in Oracle
 
27:07
DML triggers are such triggers in Oracle which execute in response to a DML event over an Oracle database table. There are two main types Row level triggers and Statement level triggers. They can be fired Before triggers or After triggers. Become patron : https://www.patreon.com/crazy4db/ #Crazy4DB #OraclePLSQL #LearnPLSQL Important reference videos : Trigger predicates : https://youtu.be/bG9hPV_hzNU Trigger basics : https://youtu.be/_XSaPlQRQBg Mutating trigger error : https://youtu.be/hFhAaMxqAHo For integrity constraints : https://www.youtube.com/playlist?list=PLdNnjIwbbBtZgOBw2u-IjsaF8tVDJZcBZ For Views : https://youtu.be/K_NaE5q9yPU My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 79 Crazy4 DB
Oracle DBA Justin - How to change the name of an Oracle database # 2 of 2
 
07:44
How to change the name of an Oracle database
Views: 3693 jbleistein11
Oracle DBA Justin - Oracle database internals - How to use the _allow_resetlogs_corruption parameter
 
23:28
How to use the _allow_resetlogs_corruption UNDOCUMENTED parameter. DISCLAIMER: Only use under the direction of Oracle software technical support.
Views: 3623 jbleistein11