Home
Search results “Oracle grant to public”
SQL tutorial 45: Introduction to user Privileges in Oracle Database By Manish Sharma RebellionRider
 
04:30
First SQL Tutorial in the series of user privileges in oracle database an introduction to user privileges. In this tutorial you will learn ● What is user privileges ● Different types of user Privileges ● Data Control Language (DCL) Grant and Revoke ● Who Can Grant or Revoke System Privileges? ● Oracle grant flags such as "With Admin option, With Grant option and with hierarchy option " This is a quick video on Introduction of user privileges expaining the theoretical concepts for the better understanding of the concept and up coming videos in USER PRIVILEGE series. Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/introduction-to-user-privileges ------------------------------------------------------------------------- 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 first 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 [email protected] 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: 27256 Manish Sharma
How to revoke privileges from PUBLIC user on Oracle
 
01:44
Oracle Database Audit Best Practices
Views: 1466 checklist20
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: 38481 ITORIAN
SQL Server 2012 Database Roles and Privileges Grant and Deny
 
12:10
SQL Server 2012 Creating Roles, Granting Privileges to Roles, Assigning Roles to users, Denying inherited Privileges to a specific user. Creating SQL Server Authentication User and Testing Roles and Privileges. To Learn or Teach Linux visit www.theskillpedia.com, A Marketplace for Learners and Trainers.
Views: 19541 TheSkillPedia
Oracle - Synonyms
 
10:43
Oracle - Synonyms
Views: 8152 Chris Ostrowski
Oracle 12c PL/SQL Security New Features - Session 6 of 8 - Granting Roles to Procedures
 
06:37
See www.skillbuilders.com/12c-plsql-security for all free modules in this tutorial. It is now in Oracle Database 12c possible to grant roles to the stored program units. Remember this didn't apply to anonymous PL/SQL. Anonymous PL/SQL as always executed with the enabled roles of the invoker. But we can now grant role to a stored procedure. There are a couple of conditions. The role granted must be directly granted to the owner. I'm not sure if this is documented or not or it could've been issues I had during my own testing but certainly the last time I tested this thoroughly I found that if I granted roles to roles to roles to roles as I go down to three, it no longer functions. So that could've been just me or it may be documented. But certainly to be sure, the role granted must be granted directly to the person who's writing the code. Also and it is documented, the owner still needs direct privileges on the object that the code references. That make perfect sense because the role might be disabled at the time that he happens to be creating the object. So you need the role, you need direct privileges on the object referenced by the code. [pause] The invoker however needs absolutely nothing. The invoker now needs nothing, no roles, no privileges. All he needs is execute on the procedure. The invoker will then take on that role during the course of the call. This will tighten up the definer's rights problem and that our user doesn't have much at all. He needs the bare minimum and then only that role will be available, only the role is available to the invoker during the call. Not everything else that the owner happens to have. You can combine this as well with invoker's rights and either way we are controlling privilege inheritance. Invoker's rights plus roles restrict the ability of definer's to inherit privileges from invokers and invokers inherits privileges from definers, both of which raise that ghastly possibility of privilege escalation associated typically to SQL injection. [pause] Grant create session, create procedure to dev, and that will give him select on scott.emp to dev. I've given dev the minimum he needs to write code that hits that table. Then create a role. [pause] Create role r1 and that'll grant select on scott.emp to r1. Finally, grant r1 to dev. It has met the requirements. The role is granted to the owner, the owner does have direct privileges. [pause] So connect as dev/dev and create my favorite procedure. [pause] The same procedure has executed definer's rights and query scott.emp. But now what we can do this new is I can grant r1 to procedure list_emp. [pause] I'll create a very low privileged user now. I need to connect as sysdba and create user low identified by low, and all I shall give him is create session. [pause] And execute on that procedure. [pause] Grant execute on dev.list_emp to low. That's all he's got. He can log on and he can run, run one procedure. What actually is going to happen to him? Let me try to log on. Connect sys low/low set server output on and see if he can run that thing. Just to check, if he tries to select star from scott.emp he is the lowest of the low is my user low. But then execute dev.list_emp, trying to retrieve the CLARKs and it works. And because my user low has virtually no privileges at all, there's no possible danger of the malicious developer being able to inherit dangerous privileges from him. [pause] The final step, that functioned because of the privilege that I mentioned earlier - the privilege that we saw on the previous slide which was inheriting privileges. If I revoke that - and this is what you should be doing in all your systems after upgrade - revoke inherit privileges on user low from public, connect there, and it fails. So the final bit of tightening up the security is to grant the privilege specifically we grant inherit privileges on user low to dev. Now we have a totally secure system and that my low privilege user dev can do that. [pause] And nothing more. My low privileged developer dev can't grab anything in his too as well. That tightens things up totally.
Views: 2823 SkillBuilders
63/125 Oracle PLSQL: Supplied  Packages / UTL_FILE  2
 
11:58
if you face issue remember to do this grant READ, WRITE on DIRECTORY MYDIR to public; تعلم اوراكل حتى الاحتراف Learn Oracle PLSQL EXAM 1Z0-144
Views: 548 khaled alkhudari
How to Create Database Link in Oracle. /* Step By Step /*
 
17:21
Today I am showing you. How to create Database link (DB Link) in Oracle. What is Database Link ( DB Link ) ? A database link is a schema object in one database that enables you to access objects on another database. I have 2 databases 1. paragdb 2. orcl In Paragdb database 1. Create listener 2. Service Name 3. In Orcl Database 1. Create Listener 2. Service Name 3. Create new User 4.Grant connect,resource,create database link to username; 5. open user 6. create database link 1. create database link link1 connect to scott identified by tiger using 'connect_primary''; 7.select * from [email protected]; 8. select * from [email protected]; 9. views 1. select * from user_db_links; 2. select * from all_db_links; 10. conn sys as sysdba 11. grant public database link to username; 12. select * from dba_db_links; 13. conn username/pass 14. create public database link plink connect to scott identified by tiger using 'connect_primary'; 15. drop database link. drop database link link1; To follow this steps you will also create oracle database link. It is very easy to understand.
Views: 7630 Parag Mahalle
Oracle Database Restricted Privileges Audit Method
 
01:08
How to use Checklist 2.0 practice list to audit restricted privileges in Oracle database
Views: 550 checklist20
Oracle DBA Justin - How to create a basic VPD policy
 
14:13
How to create a basic VPD policy
Views: 6022 jbleistein11
Oracle Grant
 
09:18
este vieo es para enseñar como poratir informacion entre usuarios
Views: 165 frosthellsing
OAuth Grant Types
 
06:37
Learn about the two-legged and three-legged flows, as well as the client types used in these flows. This videos forms part of the Oracle Cloud Primer Series. For more details visit the Cloud Primer Playlist at: http://bit.ly/cloud_primers ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll Copyright © 2017 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.
Loudoun County, Virginia on Oracle Hyperion Public Sector Planning and Budgeting
 
03:50
In this video, Adnan Nasir from Loudoun County, Virginia spoke with us about their extensive Oracle footprint and their use of Hyperion Public Sector Planning and Budgeting (PSPB). Loudoun County has a number of Oracle EPM products including PSPB, Oracle Business Intelligence Extended Edition, and Oracle Hyperion Financial Data Quality Management Extended Edition to integrate Oracle ERP and Enterprise Performance Management (EPM) tools. Prior to these implementations, they were using outdated software, which badly needed upgrading, and Oracle was the vendor of choice to replace their old software. The biggest change they are experiencing with their Oracle EPM products is the increased control, security, and reliability.
Oracle DB - Privilege
 
11:50
Oracle DB - Privilege Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
Oracle's Database as a Service in action
 
15:44
Preview Lecture of Udemy Course: Oracle Private Database Cloud ===================================================== In this lecture I will demonstrate Oracle's Database as a Service in action, via the Oracle Enterprise Manager self service console and logged in as the self-service user. We will create a single instance database via self-service. For the complete Udemy course, please visit https://www.udemy.com/oracle-private-database-cloud/?couponCode=ORANOVTODEC16 Course Description =============== This course will introduce you to the concepts of the Oracle Private Database cloud. You will be taught techniques for building, configuring, and managing a private database cloud with Oracle Enterprise Manager 13c Cloud Control. Learn best practices for a wide variety of different approaches--Database as a Service, Snap Clone as a Service, Schema as a Service, and Pluggable Database as a Service. The course also explains how to use the Oracle Cloud REST API for performing Database as a Service. You will gain a reasonable understanding of how to architect, configure, and manage every component in a private database cloud lifecycle. Learn from an Oracle Certified Master, previous Oracle ACE Director, and experienced computing writer (three books published on Oracle Enterprise Manager). What are the requirements? Oracle Enterprise Manager Cloud Control 13c installed on a sandbox server - Enterprise Manager Cloud Control is the main driving engine for the Oracle private database cloud Oracle Database Enteprise Edition Homes installed for 11g and 12c Oracle Databases created - 11g for SChaaS and 12c container database for PDBaaS Alternatively, you can follow the lectures without an actual install of the software What am I going to get from this course? Understand the concepts and requirements of the Oracle Private Database Cloud Learn techniques and best practices for building, configuring, and managing a private database cloud with Oracle Enterprise Manager 13c Cloud Control Set up the foundation of the Oracle Private Database Cloud - including the Enterprise Manager Software Library, Enterprise Manager Self update, User Privileges and Roles for self-service, and the PaaS Infrastructure Zones Set up and Configure Database as a Service and Snap Clone as a Service - Database Pools, Quotas, Database Profiles, Database sizes, Service Templates, Request Settings See Database as a Service in action using the Enterprise Manager Self-Service console See Snap Clone as a Service in action using the Enterprise Manager Self-Service console Set up and Configure Schema as a Service - Schema Pools, Quotas, Schema Profiles, Service Templates, Request Settings See Schema as a Service in action using the Enterprise Manager Self-Service console Set up and Configure PDB as a Service - PDB Pools, Quotas, PDB Profiles, Service Templates, Request Settings See PDB as a Service in action using the Enterprise Manager Self-Service console Understand how to use the Cloud REST API for performing Database as a Service, using the REST client in Google Chrome, and why you would use the Cloud REST API instead of the Enterprise Manager Self Service Console Understand the next course of action and further reading material What is the target audience? Students who want to get a basic understanding of the setup, configuration and actual use of the capabilities of the Oracle Private Database Cloud Students who want to understand the use of Oracle Enterprise Manager for Database as a Service, Snap clone as a Service, Schema as a Service and PDB as a Service Students who want to use the Cloud REST API for self-service in their own customized orchestration engine Students should have a basic understanding of Oracle Database install/administration concepts, and Oracle Enterprise Manager adminstrator concepts I hope this course is beneficial to you and your careers. All the Best. Great endorsement from my ex-colleague friend Bob Lofblad. Thanks Bob. "I used to work with Porus at Oracle and learned a lot from his workshops. This course is an amazing value for getting up to speed on using Enterprise Manager and the Cloud." - Bob Lofblad (Customer Success Manager - Public Cloud at Oracle) From my friend Rob Zoeteweij : "Just did the training course Oracle Private Database Cloud on Udemy by Porus Homi Havewala and I must say; this guy knows what he is talking about! If you are as eager I was to start working with DBaaS , Snap cloning, Schema as a Service and PDB as a Service using EM13c, this course really give you a head start. It takes you about 3 hours to follow and must say the course is pretty easy to follow and for its price, you get you value for your money. I really recommend this course. Good job Porus!" Thanks a lot, Rob. Really appreciated. Regards, Porus Homi Havewala (OCM). For the complete Udemy course, please visit https://www.udemy.com/oracle-private-database-cloud/?couponCode=ORANOVTODEC16
Views: 1448 Porus Homi Havewala
Oracle Public Cloud Helps Update Grant Thornton's Business
 
00:28
Jeffrey Silverman, BI Manager at Grant Thornton, describes their journey to the cloud and why Oracle's Integrated Cloud infrastructure helps them match up their consultants to jobs in a more effective manner, thereby improving their bottom line.
Views: 78 Oracle
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: 5059 jbleistein11
How to installation  Oracle Designer 10 g  and Introduction
 
16:49
دي الصلاحيات المطلوبه لليوزر GRANT EXECUTE ON DBMS_LOCK TO &U; GRANT EXECUTE ON DBMS_PIPE TO &U; GRANT EXECUTE ON DBMS_RLS TO &U; GRANT SELECT ON dba_rollback_segs TO &U; GRANT SELECT ON dba_segments TO &U; GRANT SELECT ON sys.v_$nls_parameters TO &U WITH GRANT OPTION; GRANT SELECT on V_$PARAMETER TO &U; GRANT ALTER SESSION TO &U; GRANT CREATE ANY SYNONYM TO &U; GRANT CREATE SESSION TO &U; GRANT CREATE DATABASE LINK TO &U; GRANT CREATE PROCEDURE TO &U; GRANT CREATE ROLE TO &U; GRANT CREATE SEQUENCE TO &U; GRANT CREATE SESSION TO &U; GRANT CREATE TABLE TO &U; GRANT CREATE TRIGGER TO &U; GRANT CREATE TYPE TO &U; GRANT CREATE VIEW TO &U; GRANT DROP ANY SYNONYM TO &U; GRANT SELECT ANY SEQUENCE TO &U; GRANT CREATE PUBLIC SYNONYM TO &U; grant execute on dbms_lock to &U; grant execute on dbms_pipe to a&U; grant execute on dbms_rls to &U; grant select on dba_rollback_segs to &U; grant select on dba_segments to &u; grant select on v_$nls_parameters to &u; grant select on v_$parameter to &u;
Views: 3654 Ahmed Tartour
Oracle Public Cloud Helps Grant Thornton Update Business
 
02:24
Jeffrey Silverman, BI Manager at Grant Thornton, describes their journey to the cloud and why Oracle's Integrated Cloud infrastructure helps them match up their consultants to jobs in a more effective manner, thereby improving their bottom line.
Views: 193 Oracle
Oracle DBA Justin - How to use the public role for database objects
 
13:14
How to use the public role for database objects.
Views: 1586 jbleistein11
Synonyms in Oracle PL SQL
 
03:48
Synonyms in Oracle #techquerypond sql synonyms oracle synonym what is Synonyms in Oracle ? 1)A synonym is an alternative name tO objects. 2)Objects like tables, views, sequences, stored procedures. 3)Generally we use to granting or revoking the access. 4)It means that the synonym is a public synonym and is accessible to all users. 5)Please note user must first have the appropriate privileges to access synonym. To get more information watch the above video. For example: CREATE PUBLIC SYNONYM EMP FOR EMPLOYEE; SELECT * FROM EMP; DROP PUBLIC SYNONYM EMP; https://techquerypond.wordpress.com https://techquerypond.com https://twitter.com/techquerypond
Views: 1286 Tech Query Pond
Using Roles to Define Who Can Do What
 
02:34
Create a new application role, configure member users to inherit the ability to build and run reports from BI Content Author, and then configure permissions on catalog objects for the new role. To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. ================================= For more information, see http://www.oracle.com/goto/oll Copyright © 2016 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.
02 - ORA-01017 Invalid Username Password
 
03:11
oracle error ORA-01017 : invalid username/password; logon denied A - Cause : public username is invalid B- steps : 1-login to sql as follows 2-connect system as sysdba 3-when password asked enter system {password will not shown while typing} 4-you are connected successfully 5- check correct pubuser running on oracle by the follwoing select username from dba_users; 6-usually you should find it as pubuser or PUBPRM$PM 7- change the public passwrod as follwos: alter user PUBUSER identified by pubuser ; where PUBUSER=public user username and pubuser=public user password
Views: 41822 adel mohd
Grant County PUD Continues Customer Service Excellence with Oracle Utilities CC&B
 
03:18
Annette Lovitt, Grant County PUD, describes the seamless transition to Oracle Utilities Customer Care and Billing.
Views: 333 Oracle Utilities
How To Check Check The Roles and Privileges That Control The Functionality
 
02:12
Using the Security Console to verify roles and privileges associated with function features.
oracle 12c pre requisites install with public YUM
 
02:42
to install oracle in linux oracle provide yum tool to install prerequisites by connecting to oracle public repository via internet connection. public yum is open source, after installing yum we can directly start installing oracle software in linux.
Views: 66 RAMESH NAIDU
Security of Users in Oracle to assign Profiles
 
23:18
Hello friends today i will explain to you a brief #SecurityofUsers #OracleProfiles introduction of Users and Profile monitoring to get more security. Oracle database Unbeatable,Unbreakable Platform..
Views: 6584 Oracle World
How to log in to an Oracle Database - Answer Video - Database Tutorials 42
 
04:26
How to log in to an Oracle Database - Answer Video - Database Tutorials 42 This video explains about how to log in to an Oracle database. This also explains about how to create an user and grant a role to that user. In this case, the role granted is 'dba'. The following things happen in this Oracle Database Tutorial. * We invoke SQLPLUS using the CMD utility which came with Windows 7 (Just click START in your Windows 7 and type CMD in the field which is immediately above the START button. A CMD window will open) * We also invoke SQLPLUS using the program group in which Oracle has been installed. * We also invoke Database Control * We then create a user. * And we assign a password to that user. * Using those (username and password) we are able to connect to the Oracle Database.
Views: 10689 Sam Dhanasekaran
Webutil configuration in Oracle Forms 11g
 
13:53
Webutil configuration in Oracle Forms 11g install.syslib.0.0.7.1=jacob-1.18-x86.dll|167936|1.18|true install.syslib.0.1.7.1=jacob-1.18-x64.dll|205312|1.18|true CREATE USER Webutil IDENTIFIED BY Webutil; grant create session, create procedure, create public synonym to webutil; Grant connect, resource to Webutil; Connect Webutil/Webutil; @c:\oracle\middleware\oracle_frhome1\forms\create_webutil_db.sql; connect sys as sysdba; Create public synonym webutil_db for webutil.webutil_db; Grant execute on webutil_db to public; [scott] form=E:\TEST\TEST_INFO.fmx userid=scott/[email protected] separateFrame=False WebUtilArchive=frmwebutil.jar,jacob.jar WebUtilLogging=off WebUtilLoggingDetail=normal WebUtilErrorMode=Alert WebUtilDispatchMonitorInterval=5 WebUtilTrustInternal=true WebUtilMaxTransferSize=20000 baseHTMLjinitiator=webutiljpi.htm baseHTMLjpi=webutiljpi.htm archive_jini=frmall_jinit.jar,frmall.jar archive=frmall.jar width=100% height=100% pageTitle=Testing for Scott lookAndFeel=oracle colorScheme=teal
Views: 4982 M Tarik
How to grant execute permissions on a SQL Server Database?
 
12:47
Learn how to grant execute permissions on a SQL Server Database. Also, while preparing this video I have experienced multiple issues and fixed them to achieve the task. Hope you like it. Check out my another article on, How to create Conflicts in Replication in SQL Server? https://youtu.be/nGuUPyla1Cw
Views: 13969 Srikanth Srikanth
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: 172474 Manish Sharma
How to Unlock the user
 
01:07
How to Unlock the user in oracle sql . (ORA-28000) http://chetanyadavds.blogspot.in/2013/08/how-to-unlock-user-oracle-ora-28000.html check more on http://youtube.com/user/chetanyadavvds http://chetanyadavds.blogspot.in/
Views: 3539 chetan yadav
Lesson 07 - OCI Fundamentals - Database
 
31:12
================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll and http://docs.oracle.com Copyright © 2018 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.
Cloud DBA: Role of DBA in Cloud
 
05:54
Learn about Cloud DBA: Role of DBA in Cloud with the FREE Lesson from our Cloud DBA Trainer & Oracle ACE & Author, Atul Kumar Covering Role of DBA. This video is from Cloud DBA Training (http://k21academy.com/clouddba02) where we will cover all these in the most practical way. PS: Preparing for Your Job as an Oracle Cloud Expert? Register for FREE 90 minutes Training ( What, Why & How of Oracle Cloud DBA) at http://k21academy.com/cloud02
Views: 10700 K21Academy
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: 11854 radhikaravikumar
Oracle DBA Justin - The delete command is a DML, and the truncate command is a DDL statement
 
09:00
The delete command is a DML, and the truncate command is a DDL statement
Views: 2089 jbleistein11
Oracle Database Security: Audit Vault
 
03:12
Um breve overview sobre a solução.
Views: 751 Odirect Lad
Oracle Database Express Edition (XE) Kullanıcı Oluşturma ve Toad'a Bağlama
 
01:31
sqlplus "/ as sysdba" create user denemeusr identified by sifre; grant CREATE SESSION, ALTER SESSION, CREATE DATABASE LINK, - CREATE MATERIALIZED VIEW, CREATE PROCEDURE, CREATE PUBLIC SYNONYM, - CREATE ROLE, CREATE SEQUENCE, CREATE SYNONYM, CREATE TABLE, - CREATE TRIGGER, CREATE TYPE, CREATE VIEW, UNLIMITED TABLESPACE - to denemeusr; C:\ORA_DS10GR2\NETWORK\ADMIN XXX= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521) ) (CONNECT_DATA = (SID = XE) ) )
Views: 142 Values
Oracle DBA Justin - How to disable variable substitutions in Sqlplus
 
07:21
How to disable variable substitutions in Sqlplus
Views: 1109 jbleistein11
Online EVERYTHING in 12c Release 2 and 18c
 
04:29
If you're a DBA, you'll love that you can do just so much stuff in the database in 12c Release 2 and above that does NOT need an outage. blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Subscribe as new tech videos come every week!
Views: 593 Connor McDonald
WARREN BUFFETT JUST BOUGHT THESE STOCKS
 
11:43
Today we got to talk about some moves Warren Buffett the oracle Omaha is making out there! Do you like these Warren Buffett stocks of not so much? Warren Buffett bought some more Apple stock for sure :)) First 10 people that join with this pre applied coupon code get 50% off a years membership in my private stock market group. https://bit.ly/2OSUMDS *The Only Stock Market Course you will ever need right here https://bit.ly/2EFi8wP * My Instagram is : FinancialEducationJeremy Financial Education Channel
Views: 48048 Financial Education
Oracle State Park
 
05:40
Oracle State park provides a place to enjoy nature, history, art and dark skies. It covers about 4,000 acres and is located on what used to be one of the earliest cattle ranches in the region. It was owned and operated by Kannally family siblings whose final survivor donated the land for what would eventually become the park. The Kannally Ranch House, built between 1929 and 1933, is listed on the National Register of Historic Places and is also home to 30 art paintings by Lee Kannally, a self-taught cowboy artist. Thousands of years ago the area was possibly visited by “Clovis Man” Native Americans, and scientists say more recently, the Hohokam and possibly the Apache used the area for hunting and food gathering. The park contains a portion of the Arizona Trail and in 2014, was designated as an “International Dark Sky Park.” Producer: Tony Paniagua Videographer: Nate Huffman Editor: Nate Huffman
How to fix "insufficient privileges to access this directory" error
 
02:23
Problem: While installing a program, the user receives the following error message: "The installer has insufficient privileges to access this directory". Solution: 1. manually create the required folder, 2. download the compressed registry file : ► https://drive.google.com/open?id=0Bw-8fzdMfWSFREZUTzZqNFROWkk 3. extract the contents to a folder you like, 4. double-click the "Take Ownership.reg" file to add it to the Windows Registry, 5. go to the folder that you manually created, right-click on it, click "Take ownership" 6. try to continue the setup, click Retry.
Views: 148533 furulevi

online dating free without registration
dating american ladies online
dating for seniors member login
dating older brothers friend
dating methods in science