Home
Search results “Oracle alter session processes” for the 2015
Oracle DBA Justin - How to kill a user session connected to an Oracle database
 
07:32
How to kill a user session connected to an Oracle database
Views: 8007 jbleistein11
Oracle 12c Installation Complete Process || SQL Developer Setup || How to create the first new user
 
16:09
Description of this video: == Oracle 12c Installation Complete Process == SQL Developer Setup == How to create the first new user ===================================================== Link for downloading Oracle 12c software: http://www.oracle.com/technetwork/database/windows/downloads/index.html ===================================================== Errors: INS-30011: The string password entered does not conform to the Oracle recommended standards. Cause: Oracle recommends that the password entered should be at least string characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Action: Provide a password that conforms to the Oracle recommended standards. ===================================================== Username : system Password: Manager123 Create user command: CREATE USER *username* IDENTIFIED BY *password*; Example:CREATE USER swapnil IDENTIFIED BY swapnil; Command 2: alter session set "_ORACLE_SCRIPT"=true; Command 3: If you two different sid and you want to change the sid then at the time of login you can connect via below command: ==system/[email protected] Here system is username Manager123 is password and sidwind is SID. ===================================================== Do reach out to me on GMAIL: [email protected] INSTAGRAM: swapnil_g_thaware FACEBOOK: https://www.facebook.com/swapnilthaware SKYPE: swapnilgthaware Tags: #oracle #installation #Developer #SQL #new user #Oracle 12c #SQL Developer Setup #12c #Process #swapnil #thaware #oracle #oracle12c #software #engineer #install #process #database #complete #simple #video #sql #sqlplus #sqldeveloper #achiever
Views: 124 Achiever
Oracle DBA Justin - How to set the current session's schema.
 
15:38
How to set the current session's schema
Views: 2657 jbleistein11
Custom date time format in Oracle SQL Developer?
 
01:03
From Oracle SQL Developer's menu go to Tools -- Preferences. From the Preferences dialog, select Database -- NLS from the left panel. From the list of NLS parameters, enter DD-MON-RR HH24:MI:SS or for 24-Hour, DD-MON-YY HH24:MI:SS Or just for an active session use below instead. alter SESSION set NLS_DATE_FORMAT = 'required_date_format' i.e. alter SESSION set NLS_DATE_FORMAT = 'DD-MM-YYYY HH24:MI:SS' into the Date Format field. Save and close the dialog.
Views: 919 Maruti AIR Tech
Oracle Alter Table Statment تعليم اوراكل
 
14:34
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج How to modify the table structure using Alter Table statement. كيف تعدل بناء الجدول Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W
Oracle HCM Brings AI to Talent Recruitment
 
05:06
Nagaraj Nadendla, Group Vice President, Oracle Talent Acquisition Cloud, discusses how his team is leveraging artificial intelligence to enhance the recruitment experience in Oracle HCM.
Views: 13107 Oracle
Oracle Table Space and User Creation with grant Privileges
 
05:05
--------------Table space Creation-------------------- Syntax CREATE TABLESPACE 'DATA FILE NAME' DATAFILE 'Data File Path to store the data' SIZE 'SIZE in MB' AUTOEXTEND ON NEXT 'SIZE in KB/MB' MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 'SIZE in KB' SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE TABLESPACE ORA12CR2_DATA DATAFILE 'E:\OracleDB\app\ORA12CR2_DATA.dbf' SIZE 2048M AUTOEXTEND ON NEXT 8K MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE TABLESPACE ORA12CR2_INDEX DATAFILE 'E:\OracleDB\app\ORA12CR2_INDEX.dbf' SIZE 1024M AUTOEXTEND ON NEXT 8K MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; Increasing the Tablespace space: ALTER DATABASE DATAFILE 'E:\OracleDB\app\ORA12CR2_DATA.dbf' RESIZE 5120M; ALTER DATABASE DATAFILE 'E:\OracleDB\app\ORA12CR2_DATA.dbf' AUTOEXTEND ON NEXT 512M MAXSIZE UNLIMITED; ALTER DATABASE DATAFILE 'E:\OracleDB\app\ORA12CR2_INDEX.dbf' RESIZE 2048M; ALTER DATABASE DATAFILE 'E:\OracleDB\app\ORA12CR2_INDEX.dbf' AUTOEXTEND ON NEXT 512M MAXSIZE UNLIMITED; ------------User Creation and Grant Privileges Syntax:- CREATE USER 'USER NAME' IDENTIFIED BY 'Password' DEFAULT TABLESPACE 'Table Space Name' TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; Example:- CREATE USER DEMOUSER IDENTIFIED BY DEMOUSER DEFAULT TABLESPACE ORA12CR2_DATA TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited; alter profile DEFAULT limit PASSWORD_LIFE_TIME unlimited; GRANT DBA TO DEMOUSER; ALTER USER DEMOUSER DEFAULT ROLE ALL; -- 16 System Privileges for DEMOUSER GRANT CREATE ROLE TO DEMOUSER; GRANT CREATE TYPE TO DEMOUSER; GRANT CREATE VIEW TO DEMOUSER; GRANT CREATE TABLE TO DEMOUSER; GRANT ALTER SESSION TO DEMOUSER; GRANT CREATE SESSION TO DEMOUSER; GRANT CREATE SYNONYM TO DEMOUSER; GRANT CREATE TRIGGER TO DEMOUSER; GRANT CREATE ANY TYPE TO DEMOUSER; GRANT CREATE SEQUENCE TO DEMOUSER; GRANT CREATE ANY INDEX TO DEMOUSER; GRANT CREATE PROCEDURE TO DEMOUSER; GRANT CREATE ANY TRIGGER TO DEMOUSER; GRANT CREATE DATABASE LINK TO DEMOUSER; GRANT UNLIMITED TABLESPACE TO DEMOUSER; GRANT SELECT ANY DICTIONARY TO DEMOUSER; GRANT DEBUG CONNECT SESSION TO DEMOUSER; GRANT DEBUG ANY PROCEDURE TO DEMOUSER; GRANT CREATE ANY MATERIALIZED VIEW TO DEMOUSER; GRANT GLOBAL QUERY REWRITE TO DEMOUSER; -- 2 Tablespace Quotas for DEMOUSER ALTER USER DEMOUSER QUOTA UNLIMITED ON ORA12CR2_DATA; ALTER USER DEMOUSER QUOTA UNLIMITED ON ORA12CR2_INDEX; -- 1 Object Privilege for DEMOUSER CREATE OR REPLACE DIRECTORY DB_EXP_IMP AS 'E:\OracleDB\app'; GRANT READ, WRITE ON DIRECTORY DB_EXP_IMP TO DEMOUSER;
Freefloat Handguard Upgrade Step-by-Step
 
13:53
Please consider supporting Ultimate Reloader on Patreon: https://www.patreon.com/ultimatereloader ------------------------------------------- Important: See disclaimer at end of video description. ------------------------------------------- Full Story: http://bit.ly/2rRDZKv If you've been wanting to upgrade your fixed front sight AR-15 to a free float hand guard- this video will guide you through the process step by step, including necessary tools. Be sure to read the full write-up for additional details, tricks, and be on the lookout for some related deals from Midsouth Shooter's Supply! ------------------------------------------- Ultimate Reloader LLC / gavintoobe Disclaimer: You alone are responsible for the safety of yourself and your property. Check local and state laws before undertaking any activity involving posessing, transporting, and shooting firearms. Check local and state laws before attempting to load ammunition or perform any modifications to a firearm. Always abide by the law. Always practice gun safety. The content on this channel (including videos, ammunition reloading data, technical data, comments, and any other information contained within) is for demonstration purposes only. Do not attempt any of the processes or procedures shown or described in this video or on this YouTube channel (gavintoobe). Any reloading data supplied on this YouTube channel (gavintoobe) or in this video, including any comments from viewers and readers must be assumed to be in error. Always consult at least three sources of manufacturer's ammunition relaoding data before reloading your own ammunition. Do not attempt to repair or modify any firearms based on information found on this YouTube channel or in this video. Gunsmithing procedures should only be performed only by a licensed gunsmith. Ultimate Reloader, LLC can not be held liable for any harm caused to any individual or any personal property related to to activities, procedures, techniques, or practices described in whole or part on this YouTube channel (gavintoobe) or in this video. By watching this video in whole or in part, you agree that you alone are solely responsible for your own safety and property as it pertains to activities, procedures, techniques, or practices described in whole or part on this YouTube channel (gavintoobe) or in this video.
Views: 271441 gavintoobe
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: 3828 Ahmed Tartour
Stored procedures in sql server   Part 18
 
20:11
In this video we will learn 1. What is a stored procedure 2. Stored Procedure example 3. Creating a stored procedure with parameters 4. Altering SP 5. Viewing the text of the SP 6. Dropping the SP 7. Encrypting stored procedure Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/stored-procedures-part-18.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-18-stored-procedures.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 759092 kudvenkat
DBMS_PROFILER - A Key to Identify PL/SQL Performance Bottleneck
 
14:02
This video tutorial explains PL/SQL performance analysis with DBMS_PROFILER. This video tutorial explains DBMS_PROFILER package,Profiler tables,how to use profiler. It demonstrates Setting up DBMS_PROFILER, Profiling for a PL/SQL procedure and Analyzing the Profiler data.
Views: 28619 Anindya Das
How to change SYS/SYSTEM password in 12C-Oracle 12C Administration
 
05:13
How to change SYS/SYSTEM password in 12C-Oracle 12C Administration =================================================== [email protected]= alter session set container=CDB$ROOT; Session altered. [email protected]=show con_id CON_ID ------------------------------ 1 [email protected]= alter user SYSTEM identified by oracle container=all; User altered. [email protected]= alter session set container=pdb1; Session altered. [email protected]= show con_id CON_ID ------------------------------ 3 ============================================= Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected]
Views: 4804 ANKUSH THAVALI
Changing Oracle BPM Human Task Parameters
 
12:35
This is an extract from lesson 2 in AVIO's self-paced on-demand Oracle BPM Developer Workshop (A-211v), and it describes how to change human task parameters after the human task has already been created. It also shows the trick on how to update the ADF Data Control for the human task.
Views: 2909 Dan Atwood
SQL Stored Procedures - What They Are, Best Practices, Security, and More...
 
44:34
Newsletter signup (with exclusive discounts): https://iamtimcorey.com/general-sign-up (your email will be kept safe and you will not be spammed). Facebook Page: https://www.facebook.com/IAmTimCorey/ Want to see a full C# application built from scratch? Check out this course: https://iamtimcorey.com/courses/csharp-from-start-to-finish/ Microsoft SQL can be confusing. There are a TON of features, options, and settings to consider when attempting to use it. One of my favorite features is stored procedures. These pre-compiled queries allow you to safely and securely access and modify data. In this video, you will learn the basics of how to build a stored procedure, as well as what the benefits and drawbacks of stored procedures are. You will also learn some best practices, including how to secure your entire database in just a few simple commands.
Views: 50797 IAmTimCorey
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: 154 Values
Importing Visio Processes into Oracle BPM 12c
 
07:13
This shows how to import Visio processes into Oracle BPM 12c.
Views: 1727 Dan Atwood
How to debug Oracle Procedure | Package using Oracle SQL Developer
 
07:41
This video will teach you the simple way to debug your Oracle Procedure | Package with Oracle SQL Developer..
Views: 12842 Oracle PL/SQL World
Oracle Training - Accounts Payable in Oracle E-Business Suite R12 (1080p - HD)
 
12:00
http://www.i-oracle.com/ - Oracle Training and Tutorials - Learn how to enter and pay an invoice in Oracle Applications E-Business Suite R12. Use the R12 interface to also match the invoice to a Purchase Order, validate and approve the invoice. View Subledger Accounting (SLA) transactions, view invoice details. And many more.
Views: 391210 Yemi Onigbode
03 Installing Oracle 11G Express Edition and Schema Creation
 
09:37
In this video we are going to see how to install Oracle 11G Express Edition, Schema creation and use with IBM Sterling Order Management System Link : http://activekite.com Register : http://activekite.com/wp-login.php?action=register Welcome to ActiveKite.com Google Search String : oracle 11g express edition free download Download Link : http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html ----------------------------------- Create Schema ----------------------------------- create user sterling94 identified by sterling94; --grant privileges: grant create session, alter session, create any sequence, alter any sequence, create procedure, create synonym to sterling94; grant create table, create trigger, create type, create view, delete any table, execute any procedure, execute any type to sterling94; grant connect, insert any table, select any dictionary, select any sequence, update any table to sterling94; grant select_catalog_role to sterling94; create bigfile tablespace sterts_01 datafile 'sterts_f1.dat' size 100M autoextend on; alter user sterling94 default tablespace sterts_01 quota unlimited on sterts_01;
Views: 342 ActiveKite
How To Modify Business Process Forms In Oracle Primavera Unifier
 
02:57
https://www.emerald-associates.com/software/oracle/primavera-unifier.html --- Our website: https://www.emerald-associates.com Our LinkedIn: https://www.linkedin.com/company/81377?trk=tyah&trkInfo=clickedVertical%3Acompany%2Cidx%3A2-1-6%2CtarId%3A1432914893132%2Ctas%3Aemerald%20ass --- Learn how to customize your business processes in Oracle Primavera Unifier by modifying your business process forms.
Views: 2127 EAI Emerald
Financial  Reports Approval Process Accelerator: manage financial reporting processes
 
16:39
Learn how the Financial Reports Approval (FRA) Oracle Process Accelerator can help your organization transform ad-hoc processes to produce financial reports, today mostly based on email, into a precise workflow-based process to consistently deliver accurate financial reports. This demo shows how a BPM solution integrated with Excel can also support a complex reporting process typical in global financial institutions.
Views: 2150 OProcessAccel
How to Install Oracle Database 11g on Windows 10 By Manish Sharma
 
08:24
Detail tutorial on How to install Oracle database 11g enterprise edition on Windows 10 Professional 64 bit. Full installation under 9 mins. You can follow the steps for installing Oracle 11g on Windows 10 32 bit home or any other version. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Previous Tutorial ► Download Link http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html ►Create Database using DBCA https://youtu.be/enFFezPYhCg ►How To Unlock User using ALTER USER https://youtu.be/sMqq9MSVmQo ------------------------------------------------------------------------- ►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/TheRebellionRider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ 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: 356245 Manish Sharma
Jumpstart Your MicroServices Development: From Dev to Deploy
 
44:09
Darrel Chia Oracle Microservices is changing the way applications are being designed and new tools and processes are needed. In this session, we introduce to the audience, how to use Apiary as a tool to aid the design and development of microservice components, and Wercker to build and deploy the services onto Oracle's container cloud service.
Views: 66 Oracle Developers
DDL, DML, DCL & TCL statements in SQL (Database basics)
 
09:35
DDL, DML, DCL & TCL statements in SQL (Database basics) Check my blog on this: https://sqlwithmanoj.com/2009/02/10/what-are-ddl-dml-dcl-and-tcl-commands-difference-bw-them/ Check the whole "SQL Server Basics" series here: https://www.youtube.com/playlist?list=PLU9JMEzjCv14f3cWDhubPaddxRvx1reKR Check my SQL blog at: http://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 313116 SQL with Manoj
Entity Relationship Diagram (ERD) Tutorial - Part 1
 
06:58
Learn how to create an Entity Relationship Diagram in this tutorial. We provide a basic overview of ERDs and then gives step-by-step training on how to make an ER diagram with correct cardinality. Entity Relationship Diagrams are comprised of 3 main categories: entities, attributes, and relationships. Entities are objects or concepts that are associated with important data—like a customer, order, or product. Attributes represent properties or traits of an entity, such as a customer’s phone number or home address. Relationships demonstrate the link between entities. Another main aspect of of ERD's is cardinality, which further defines the relationship between entities in a numerical way. Certain symbols signify the minimum and maximum relationship between different entities. Additional ERD information: https://www.lucidchart.com/pages/entity-relationship-diagram-tutorial —— Learn more and sign up: https://www.lucidchart.com/users/register Follow us: Facebook: https://www.facebook.com/lucidchart Twitter: https://twitter.com/lucidchart Instagram: https://www.instagram.com/lucidchart LinkedIn: https://www.linkedin.com/company/lucidsoftware
Views: 668884 Lucidchart
What is an ETL Tool?
 
04:56
What is an ETL tool, why is it important to have and how do you decide which is best for your organization? To Talk with a Specialist go to: http://www.intricity.com/intricity101/
Views: 261217 Intricity101
LIBRA |  ABUNDANCE \ FINALLY FALLING INTO PLACE UNDERSTANDING March 2019 Tarot
 
01:12:12
LIBRA March 2019 Tarot Reading LOVE CAREER LIFE Skip Intro: 22:22 Skip Deal: 25:07 🎥 March, 2019 *BREAK DOWN* *Reading*🎥 https://vimeo.com/ondemand/warrwillowlibra032019 🎥 Watch the Trailer for the Extension Here🎥 https://youtu.be/HsksSdnBTEs 💸*Donations*💸 https://www.paypal.me/warrwillow 💌*EMAIL*💌 [email protected] 🌖🌑🌔 *PRIVATE* *ASSISTANCE *🌖🌑🌔 📞 45 min = $45 (Talk/Tarot + Maximum Advice/Suggestion) + 15 minutes = $25 📞 EMERGENCY READINGS = $120 per hour + $25 for an additional 30 minutes EMAIL BEFORE PAYMENT! [I no longer offer other options like email/video/30min/90min because they all ended up being inefficient or unsustainable for me. There is a huge demand for readings, and 45/60min sessions are all I can offer without losing my mind! LOL] *PROCEDURE* To those of you who donate and do not opt for assistance, I greatly appreciate your generosity. It pays for others who cannot afford the help. For Service 1. Pay here: https://www.paypal.me/warrwillow (PERSONAL PAYMENTS ONLY) 2. Take a Screenshot of PayPal Transaction. Email the screenshot to me here: [email protected] 3. I will respond within via email with a link for you to book your appointment. *Thank You* 💲💲💲💲* ESL Teaching Job (Remote Work From Home)* 💲💲💲💲 Join an industry that is changing lives every day, and change your life, today! https://t.vipkid.com.cn/?refereeId=18402386&partnerId=3724772 🛸🔮🌈👽🌈🔮🛸 LIGHTWORKER Unionized Twin Scholar, Counselor, Educator Twin-Flame (Marriage) Guidance *Disclaimer* I am legally obligated to tell you that this is for *ENTERTAINMENT PURPOSES ONLY* However, I really am a Lightworker, and I am here to assist in any way I can. I focus on empowerment and helping humanity ascend to 5d (God's Kingdom COME!) TWIN-FLAME UNIONS, Divine Masculine & Divine Feminine AWAKENING, Life-Purpose, Dharma, Healing from Narcissistic Abuse, and trauma. Energy Healer. All exchanges are *ABSOLUTELY 100% FINAL*🎓 I am a trained SCHOLAR and EDUCATOR 🌈🌈🌈 DECKS (I own. Not All Are Used in Each Video) Tarot ☑️Night Sun by: Fabio Listrani ☑️Golden Botticelli by: Lo Scarabeo ☑️Starman Tarot by: Davide De Angelis Oracle ☑️Sacred Activation Oracle by: Beyond Words / LON ☑️Kuan Yin Oracle by: Alana Fairchild ☑️Gardian Angel... by: Doreen Virtue and Radleigh Valentine ☑️Moonology Oracle Cards by: Yasmin Boland ☑️Romance Angels Oracle Cards by: Doreen Virtue ☑️Work Your Light Oracle Cards by: Rebecca Campbell ☑️Loving Words from Jesus by: Doreen Virtue Golden Playing Cards ♦️️♣️️♥️️♠️️ ☑️Do a google search for "Golden Playing Cards" The ones I got are generic you can get them anywhere, and I can't find a link for the ones I have specifically. Images: https://www.freeimages.com/photo/angel-1409581 Music: "Just As Soon" Kevin MacLeod (incompetech.com) Licensed under Creative Commons: By Attribution 3.0 License http://creativecommons.org/licenses/by/3.0
Views: 5229 WarrWillow Tarot
Oracle SQL Developer Tips : Changing the Language (The short Story)
 
01:02
This is the short story of how to change the GUI language in Oracle SQL Developer. I have another video on this very topic, but I wanted to test a new video tool, which creates videos from text, automatically. For the detailed procedure, please watch https://youtu.be/84hYgN30-bc. You can find additional Oracle SQL related articles and educational content in my blog here: http://standout-dev.com/
Views: 166 Oracle SQL
Oracle E-Business Suite Integrated SOA Gateway - PL/SQL API as REST Service
 
08:27
Oracle E-Business Suite Integrated SOA Gateway Release 12.2.4 Tutorial: Publish PL/SQL API as REST Service 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.
LEDGlow | How To Install Car Interior LED Lights
 
06:35
This video will help walk you through the process of installing your LEDGlow 4pc 7 Color Interior LED Lighting Kit to the interior of your car. SHOP NOW: http://bit.ly/2vEoNkV LEDGlow's 4pc. 7 Color LED Interior Light Kit was designed to create a custom multi-color interior lighting effect to the interior of your vehicle using the included four 15” tubes with a total of 120 intense LEDs. For More Information Please Visit: http://www.ledunderbody.com/7-Color-4pc-LEDGlow-LED-Interior-Lights-Lighting-Kit.aspx WARNING: This demonstration is meant to be a guideline. All vehicles are different and professional assistance is highly recommended for installing any lighting kit. As with all of our products, we recommend testing the kit before beginning the install process.
Views: 3667484 LEDGlow
Pick A Card: Message from All Mama
 
28:13
See the Piles (and snoozy pupper) :56 Group 1: 1:42 Group 2: 10:48 Group 3: 19:35 Energy Exchanges (suggested $11.11) accepted here https://www.paypal.me/chelseachrist Cash or Check donations or payments, or otherwise gifts of any kind, may be sent here: 3705 W Pico Blvd #592 Los Angeles, CA 90019-3451 (whole zip preferred) Email address for contact: [email protected] Prophetic Personal Services! PRICES ARE FLEXIBLE (email for details) Healing Reiki Session or Tarot/Oracle Card Reading Single Card Clarification (Written Message through email with picture of card) $11 15 Minute Session (either service) $33 30 Minute Session (either service) $55 60 Minute Session (either service) $77 https://www.paypal.me/chelseachrist For a personal reading, feel free to give some background information to your concern or question as well as the birthdays of yourself and anyone involved (time or location not required). You can also keep it general and keep your information private. Reading topics can include: dream interpretations, love life, spiritual life, soulmate or twin flame connections, personal hardships and aspirations, life purpose, clarification on experiencing fulfillment, insight on interpersonal human bonds of any kind, and while many ask about career, we will always get to the core of you so you can co-create your career. As long as you are open to a channeled message, the possibilities for insight are endless! You will receive a privately shared audio file with pictures of your cards through email from my google drive (you do not need a gmail account to access your link) which you then download onto a device for guaranteed future use. Please allow 72 hours to receive your reading to the email used for your query. Any money received through Paypal WITHOUT AN EMAIL OR NOTE FOR INSTRUCTION will be considered an Energy Exchange Donation until the giver inquires about the service not yet provided. What to Expect from a Psychic Reiki Session with Chelsea: Reiki is not a replacement therapy for mental, physical, or emotional conditions. Keep in touch with any current practitioners, medical and otherwise, about the addition to Reiki Healing to your caretaking regiment to note any possible changes that might require a shift in your care, such as doses to medicine, to accommodate the possible physical ripple effects of your changing energy. After you purchase your time frame, allow 72 hours to receive your guided meditation, which you can listen to with gentle background music of your choosing if you like. Your prophet "uploads" an energy shift while recording the process on an audio file for you to "download" at your leisure. All that's needed of the client is a willingness to receive the changes in your energy. The guided meditation is useful to the client's ego, and will have many channeled messages about your energetic state/your life in general. *Services for "Entertainment Value Only" as life is a game! *Chelsea Christ Incarnate is under no obligation to refund
Introducing TMS NOW
 
02:44
http://www.capgemini.com/tmsnow Built on the latest release of Oracle Transportation Management (OTM) by Capgemini, a Diamond-level partner of Oracle, TMS NOW offers a streamlined and flexible way to implement a Transportation Management System (TMS) which saves companies time and money. In TMS NOW the logistics processes and technical workflows which support order consolidation, planning, tendering, track and trace, freight settlement and reporting for shippers are pre-built, to help you obtain value from your TMS as quickly as possible. The solution can be delivered on premise, or in SaaS mode with a subscription-based commercial model, and can evolve to meet your company's changing needs and scale.
Views: 17210 Capgemini
Tour the Oracle Dev Gym!
 
06:51
Flex Your Oracle Muscles! [Note: the UI for the Dev Gym has changed since this video was recorded, but the basic operations of taking quizzes is still present. Enjoy!] You make a living working with code and data - both of which are changing all the time. How do you stay at the top of your game? How do you keep all your knowledge fresh, current and readily available when you are confronted by your next challenge? You go to the gym. You exercise your knowledge. You compete against other developers. You work out, getting strong and flexible. You challenge yourself with practice quizzes and tests. ======================================== 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.
طريقة تصطيب الديزاينر وعمل مشروع مصغر عليه
 
50:30
دي الصلاحيات المطلوبه لليوزر 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: 1228 Ahmed Tartour
Oracle Performance Tuning - Loading Data - 03 Using manual parallelism and changing initrans
 
13:50
Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/itversity https://github.com/dgadiraju https://www.youtube.com/c/TechnologyMentor https://twitter.com/itversity
Views: 885 itversity
How To Download And Install Java on Windows 10 ( Java JDK on Windows 10) + Set JAVA_HOME
 
08:56
In this video I am going to show How To Download And Install Java on Windows 10 ( Java JDK on Windows 10). In addition I am going to show How to Set JAVA_HOME environment variable. Install Java Development Kit on Windows 10 in simple and easy steps. -------------------Online Courses to learn---------------------------- Blockchain Course - http://bit.ly/2Mmzcv0 Big Data Hadoop Course - http://bit.ly/2MV97PL Java - https://bit.ly/2H6wqXk C++ - https://bit.ly/2q8VWl1 AngularJS - https://bit.ly/2qebsLu Python - https://bit.ly/2Eq0VSt C- https://bit.ly/2HfZ6L8 Android - https://bit.ly/2qaRSAS Linux - https://bit.ly/2IwOuqz AWS Certified Solutions Architect - https://bit.ly/2JrGoAF Modern React with Redux - https://bit.ly/2H6wDtA MySQL - https://bit.ly/2qcF63Z ----------------------Follow--------------------------------------------- My Website - http://www.codebind.com My Blog - https://goo.gl/Nd2pFn My Facebook Page - https://goo.gl/eLp2cQ Google+ - https://goo.gl/lvC5FX Twitter - https://twitter.com/ProgrammingKnow Pinterest - https://goo.gl/kCInUp Text Case Converter - https://goo.gl/pVpcwL -------------------------Stuff I use to make videos ------------------- Stuff I use to make videos Windows notebook – http://amzn.to/2zcXPyF Apple MacBook Pro – http://amzn.to/2BTJBZ7 Ubuntu notebook - https://amzn.to/2GE4giY Desktop - http://amzn.to/2zct252 Microphone – http://amzn.to/2zcYbW1 notebook mouse – http://amzn.to/2BVs4Q3 ------------------Facebook Links ---------------------------------------- http://fb.me/ProgrammingKnowledgeLearning/ http://fb.me/AndroidTutorialsForBeginners http://fb.me/Programmingknowledge http://fb.me/CppProgrammingLanguage http://fb.me/JavaTutorialsAndCode http://fb.me/SQLiteTutorial http://fb.me/UbuntuLinuxTutorials http://fb.me/EasyOnlineConverter #javatutorialforbeginners #javatutorial #javaprogramming #javaprogrammingtutorial #javabasicsforbeginners Java SE Development Kit 8 will enable you to develop Java programs on Windows OS. How do I install Eclipse and Java SDK into Windows 10.How to use Java on Windows 10. Installing JDK 8 on Windows 10 How to Install Java JDK & Set Environment Variable in Windows 10 installing java jdk on window 10
Views: 234885 ProgrammingKnowledge2
ARIES | BEWARE! A MALICIOUS MAGICIAN CAUSING CHAOS! \ STEALTH OPERATOR February 2019 Tarot
 
01:32:23
Aries February 2019 Tarot Reading https://www.paypal.me/warrwillow Skip Intro: 11:35 💸*Donations*💸 https://www.paypal.me/warrwillow 💌*EMAIL*💌 [email protected] 🌖🌑🌔 *PRIVATE* *ASSISTANCE *🌖🌑🌔 📞 45 min = $45 (Talk/Tarot + Maximum Advice/Suggestion) + 15 minutes = $25 📞 EMERGENCY READINGS = $120 per hour + $25 for an additional 30 minutes !!! EMAIL CONFIRMATION NECESSARY BEFORE PAYMENT!!!! [I no longer offer other options like email/video/30min/90min because they all ended up being inefficient or unsustainable for me. There is a huge demand for readings, and 45/60min sessions are all I can offer without losing my mind! LOL] *PROCEDURE* To those of you who donate and do not opt for assistance, I greatly appreciate your generosity. It pays for others who cannot afford the help. For Service 1. Pay here: https://www.paypal.me/warrwillow (PERSONAL PAYMENTS ONLY) 2. Take a Screenshot of PayPal Transaction. Email the screenshot to me here: [email protected] 3. Patiently wait for a link with which to book your appointment. All people must book. Even for emails and video responses so that I do not miss someone. I will accomplish your request according to my calendar. I *need* this to stay organized. You will book the block of time in which your request will be fulfilled. *Thank You* 🛸🔮🌈👽🌈🔮🛸 LIGHTWORKER Unionized Twin Scholar, Counselor, Educator Twin-Flame (Marriage) Guidance 💲💲💲💲* ESL Teaching Job (Remote Work From Home)* 💲💲💲💲 Join an industry that is changing lives every day, and change your life, today! https://t.vipkid.com.cn/?refereeId=18402386&partnerId=3724772 *Disclaimer* I am legally obligated to tell you that this is for *ENTERTAINMENT PURPOSES ONLY* However, I really am a Lightworker, and I am here to assist in any way I can. I focus on empowerment and helping humanity ascend to 5d (God's Kingdom COME!) TWIN-FLAME UNIONS, Divine Masculine & Divine Feminine AWAKENING, Life-Purpose, Dharma, Healing from Narcissistic Abuse, and trauma. Energy Healer. All exchanges are *ABSOLUTELY 100% FINAL*🎓 I am a trained SCHOLAR and EDUCATOR 🌈🌈🌈 DECKS (I own. Not All Are Used in Each Video) Tarot ☑️Night Sun by: Fabio Listrani ☑️Golden Botticelli by: Lo Scarabeo ☑️Starman Tarot by: Davide De Angelis Oracle ☑️Sacred Activation Oracle by: Beyond Words / LON ☑️Kuan Yin Oracle by: Alana Fairchild ☑️Gardian Angel... by: Doreen Virtue and Radleigh Valentine ☑️Moonology Oracle Cards by: Yasmin Boland ☑️Romance Angels Oracle Cards by: Doreen Virtue ☑️Work Your Light Oracle Cards by: Rebecca Campbell ☑️Loving Words from Jesus by: Doreen Virtue Golden Playing Cards ♦️️♣️️♥️️♠️️ ☑️Do a google search for "Golden Playing Cards" The ones I got are generic you can get them anywhere, and I can't find a link for the ones I have specifically Image: https://www.freeimages.com/photo/engagement-1311706 Music: "Just As Soon" Kevin MacLeod (incompetech.com) Licensed under Creative Commons: By Attribution 3.0 License http://creativecommons.org/licenses/by/3.0/
Views: 22386 WarrWillow Tarot
!!!!! Pick a Message from A.A. Michael !!!!!
 
15:20
See the piles: :50 Group 1: 1:13 Group 2: 5:55 Group 3: 11:08 Energy Exchanges (suggested $11.11) accepted here https://www.paypal.me/chelseachrist Cash or Check donations or payments, or otherwise gifts of any kind, may be sent here: 3705 W Pico Blvd #592 Los Angeles, CA 90019-3451 (whole zip preferred) Email address for contact: [email protected] Prophetic Personal Services! PRICES ARE FLEXIBLE (email for details) Healing Reiki Session or Tarot/Oracle Card Reading Single Card Clarification (Written Message through email with picture of card) $11 15 Minute Session (either service) $33 30 Minute Session (either service) $55 60 Minute Session (either service) $77 https://www.paypal.me/chelseachrist For a personal reading, feel free to give some background information to your concern or question as well as the birthdays of yourself and anyone involved (time or location not required). You can also keep it general and keep your information private. Reading topics can include: dream interpretations, love life, spiritual life, soulmate or twin flame connections, personal hardships and aspirations, life purpose, clarification on experiencing fulfillment, insight on interpersonal human bonds of any kind, and while many ask about career, we will always get to the core of you so you can co-create your career. As long as you are open to a channeled message, the possibilities for insight are endless! You will receive a privately shared audio file with pictures of your cards through email from my google drive (you do not need a gmail account to access your link) which you then download onto a device for guaranteed future use. Please allow 72 hours to receive your reading to the email used for your query. Any money received through Paypal WITHOUT AN EMAIL OR NOTE FOR INSTRUCTION will be considered an Energy Exchange Donation until the giver inquires about the service not yet provided. What to Expect from a Psychic Reiki Session with Chelsea: Reiki is not a replacement therapy for mental, physical, or emotional conditions. Keep in touch with any current practitioners, medical and otherwise, about the addition to Reiki Healing to your caretaking regiment to note any possible changes that might require a shift in your care, such as doses to medicine, to accommodate the possible physical ripple effects of your changing energy. After you purchase your time frame, allow 72 hours to receive your guided meditation, which you can listen to with gentle background music of your choosing if you like. Your prophet "uploads" an energy shift while recording the process on an audio file for you to "download" at your leisure. All that's needed of the client is a willingness to receive the changes in your energy. The guided meditation is useful to the client's ego, and will have many channeled messages about your energetic state/your life in general. *Services for "Entertainment Value Only" as life is a game! *Chelsea Christ Incarnate is under no obligation to refund
Linux Administration in Distributed Cloud Computing Environments by Robert Shimp, Oracle
 
43:25
Linux Administration in Distributed Cloud Computing Environments - Robert Shimp, Oracle Systems of engagement and control in distributed computing environments, are changing Linux system administration strategies. These next-gen applications, potentially based on cloud services at or close to the edge of the network, will be largely container-based microservices that may be deployed to dozens or hundreds of distributed sites. These applications will create opportunities for greater innovation today than at any recent time in the past. This session will outline a vision for Linux in cloud-based distributed computing environments and some of the challenges to deliver on that vision. About Robert Shimp Robert Shimp is group vice president of product management responsible for the Oracle Linux operating system, Oracle VM server virtualization, Private Cloud Appliance and other cloud infrastructure products for Oracle. Robert has been heavily involved in new product planning as well as setting go-to-market strategies for broad initiatives at Oracle in areas such as cloud computing; big data, mobile, social and IoT. He has over 35 years of experience in enterprise software and hardware, product management, marketing, alliances, sales operations, and business planning. He has guided the launch of hundreds of products for Oracle. Mr. Shimp holds a Bachelor’s degree in Electrical Engineering and Engineering & Public Policy from Carnegie Mellon University. He also holds a Master of Business Administration degree and a Juris Doctorate from the University of North Carolina, Chapel Hill.
Views: 3529 The Linux Foundation
UPK Template Editing, Oracle Applications Training
 
04:07
This lesson shows how to modify the UPK publishing template for the System Process Document.
Views: 1589 Larry Sherrod
BPM human task managing attachments in WebCenter content
 
08:46
This demonstration shows a BPM processes that utilizes the WebCenter Content ECM system to manage documents associated the process.
Views: 841 mjk88cbo
Titina Ott, Oracle - Oracle OpenWorld 2015 - #OOW15 - #theCUBE
 
18:06
01. Titina Ott, Oracle, Visits #theCUBE. (00:18) 02. Women's Leadership Group at Oracle. (00:51) 03. Oracle Prides Itself on It's Diverse Workforce. (03:42) 04. Impact of the Women's Leadership Group. (06:22) 05. Community and Paying It Forward. (08:34) 06. Seventh Year of Sponsoring OWL Summit at Oracle OpenWorld. (10:25) 07. Engagement with Partners and Customers. (11:35) 08. Oracle Fosters a Culture Where Women Can Grow and Succeed. (12:55) 09. Leadership Is about Helping Others Find Their Potential. (13:46) 10. Strong Leadership Program in the UK. (14:49) 11. Life at Oracle Is Ever-Changing. (16:15) Track List created with http://www.vinjavideo.com. --- --- Oracle Women’s Leadership program a ‘launchpad for millennials’ | #oow15 by Amber Johnson | Oct 25, 2015 In 2006, a grassroots organization arose within the Oracle community. This organization later became known as the Oracle Women’s Leadership (OWL), which has a goal of “creating access to networks for women” in the technology industry. Over the years, OWL has expanded those goals to developing, engaging and empowering women. The organization currently has a presence in 41 countries. Most recently, OWL has become a “launchpad for millennials.” OWL is not just another leadership program, according to Titina Ott, VP worldwide A&C, system and business processes at Oracle. Ott sat down for an interview with John Furrier and Stu Miniman, cohosts of theCUBE, from the SiliconANGLE Media team, during Oracle OpenWorld 2015 in San Fransisco. “Programs [like OWL] are successful when there is engagement not just from the top … executive level … but also from the bottom,” Ott remarked. She continued, saying programs need “women pulling other women up with them” through the ranks. A female employee told Ott in 2008 that OWL made her “more committed to Oracle.” Ott credited OWL with the ability to “engage and retain” employees. OWL has more than 150 women leaders throughout the company. “A diverse workforce makes [a company] more effective,” said Ott. OWL is sponsoring its seventh summit at Oracle OpenWorld 2015, an event that Ott described as an opportunity for members to connect to leaders of the industry. OWL and its partners also sponsor Dare 2B Digital, a STEM program for girl grades 7 through 12. Ott stated that in regards to diversity, “We still have a lot to learn, but Oracle is heading in the right direction.” @theCUBE #oow15
Oracle username and password and Account unlocking
 
08:37
all education purpose videos
Views: 283233 Chandra Shekhar Reddy
Managing Resumable Space Allocation in Oracle database
 
02:56
By Vivek Saxena Insa Shabad Coachings Shamli Resumable Space Allocation is given by extending the data file size with a open database Alter session enable resumable; Create tablespace spr datafile 'c:\db3\data\spr1a.dbf' size 100k; Create table spr(rn number(10) tablespace spr; Insert into spr(select salary from hr.employees); Insert into spr (select * from spr); Set oracle_sid= orcl Sqlplus/nolog Conn/as syadba Alter database datafile 'c:\db3\data\spr1a.dbf' resize 300k;
Informatica Tutorial 1.6  - Create My First Workflow
 
10:44
This Tutorial Video shows the Step-by-Step process for creating your first Informatica Workflow. Visit us at http://www.disoln.org or http://facebook.com/disoln for the complete list of training Sessions, Training Manual, User Guide and Lab Guide. These informatica powercenter tutorials for beginners provide self explanatory and easy to follow steps and complete the training with enterprise ready experience. This session will cover • Create database connections for sources and targets • Learn how to use Workflow Manager. • Create a simple Workflow • Create a session task and start task and Link tasks
Views: 65251 DISoln
Checking Which OBPM 11g Rules Fired
 
04:54
This video shows you how to check which rules are fired with Oracle Business Process Management 11g. Copyright © 2012 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.
New Document-Only Process Oracle BPM 12c Composer Feature
 
09:11
This describes the new "Document-Only" feature in Oracle BPM 12c Composer and why you would want to use it.
Views: 5100 Dan Atwood
Oracle SQL Data Conversion-Implicit Explicit
 
19:23
Oracle SQL Data Conversion Implicit Explicit Online console used -- https://livesql.oracle.com Implicit and Explicit data conversion to_char, to_number, to_date and cast functions Queries: /*IMPLICIT DATA CONVERSION EXAMPLES*/ SELECT salary + '10' FROM hr.employees; SELECT last_name FROM hr.employees WHERE employee_id = '200'; SELECT last_name FROM hr.employees WHERE employee_id = 200; SELECT last_name FROM hr.employees WHERE hire_date = '03-MAR-97'; Create table birth(name varchar2(15), dob date); Insert into birth values ('nids', '12/jan/58'); Insert into birth values ('panda', '14/feb/48'); Insert into birth values ('Spider', '14/feb/1958'); Insert into birth values ('agnes', '14/feb/2048'); Select * from birth; SELECT to_date('12-jan-58') - to_date('14-feb-48') from DUAL; '01/01/2058','MM/DD/RRRR' 01/01/2058 '01/01/2048','MM/DD/RRRR' 01/01/2048 '01/01/48','MM/DD/RRRR' 01/01/2048 '01/01/58','MM/DD/RRRR' 1/01/1958 '01/01/48','MM/DD/YYYY' 01/01/0048 '01/01/58','MM/DD/YYYY' 01/01/0058 '01/01/58','MM/DD/YY' 01/01/2058 '01/01/48','MM/DD/YY' 01/01/2048 SELECT * FROM NLS_SESSION_PARAMETERS WHERE PARAMETER = 'NLS_DATE_FORMAT'; Alter session set nls_date_format = 'DD-MM-RRRR'; Select * from birth; alter session set nls_date_format = 'DD-MON-YYYY'; Select * from birth; ALTER session set nls_date_format = 'DD-MON-YY'; SELECT to_date('12-jan-58') - to_date('14-feb-48') from DUAL; ALTER session set nls_date_format = 'DD-MON-RR'; /*EXPLICIT DATA CONVERSION EXAMPLES*/ /*TO_CHAR, TO_DATE, TO_NUMBER*/ SELECT first_name, TO_CHAR (hire_date, 'MON DD, YYYY') HIRE_DATE, TO_CHAR (salary, '$99999.99') Salary FROM hr.employees; SELECT TO_CHAR('01110') FROM DUAL; SELECT TO_CHAR('01110' + 1) FROM DUAL; SELECT TO_DATE('2012-06-05', 'YYYY-MM-DD') FROM dual; SELECT TO_DATE( '5 Jan 2017', 'DD MON YYYY' ) FROM dual; SELECT TO_NUMBER('1210.73', '9999.99') from DUAL; SELECT TO_NUMBER('$65.169', 'L99.999') FROM DUAL; SELECT TO_NUMBER('123,456,789', '999,999,999') FROM DUAL; /*This example takes a complicated string, determines that it is in certain format, and specifies the numeric characters to use*/ SELECT TO_NUMBER('$17 218,00', 'L999G999D00',' NLS_NUMERIC_CHARACTERS='', ''') FROM DUAL; /*CAST*/ SELECT CAST( '22-Aug-2003' AS varchar2(30) ) from dual; SELECT CAST('245.205' AS NUMBER(5,2)) FROM dual; /*      -- Result: 245.21 (note that the value is rounded, not truncated to 245.20) */ SELECT CAST(245.205 AS NUMBER(5,2)) FROM dual; SELECT CAST ('123456' AS NUMBER) + 5 FROM DUAL; SELECT CAST ('5.05.2017' AS DATE) +5 FROM DUAL; /*check the default date format. That's why it give error*/ SELECT CAST ('30-APRIL-2015' AS DATE) +5 FROM DUAL; SELECT CAST (SYSDATE AS TIMESTAMP) FROM DUAL; SELECT SYSDATE FROM DUAL;
Views: 76 Nids Dixit
Learn Oracle | How to Create a Trigger in PL SQL
 
05:39
Pebbles present, Learn Oracle 10g with Step By Step Video Tutorials. Learn Oracle 10g Tutorial series contains the following videos : Learn Oracle - History of Oracle Learn Oracle - What is Oracle - Why do we need Oracle Learn Oracle - What is a Database Learn Oracle - What is Grid Computing Learn Oracle - What is Normalization Learn Oracle - What is ORDBMS Learn Oracle - What is RDBMS Learn Oracle - Alias Names, Concatenation, Distinct Keyword Learn Oracle - Controlling and Managing User Access (Data Control Language) Learn Oracle - Introduction to SQL Learn Oracle - Oracle 10g New Data Types Learn Oracle - How to Alter a Table using SQL Learn Oracle - How to Create a Package in PL SQL Learn Oracle - How to Create a Report in SQL Plus Learn Oracle - How to Create a Table using SQL - Not Null, Unique Key, Primary Key Learn Oracle - How to Create a Table using SQL Learn Oracle - How to Create a Trigger in PL SQL Learn Oracle - How to Delete Data from a Table using SQL Learn Oracle - How to Drop and Truncate a Table using SQL Learn Oracle - How to Insert Data in a Table using SQL Learn Oracle - How to open ISQL Plus for the first time Learn Oracle - How to Open SQL Plus for the First Time Learn Oracle - How to Update a Table using SQL Learn Oracle - How to use Aggregate Functions in SQL Learn Oracle - How to use Functions in PL SQL Learn Oracle - How to use Group By, Having Clause in SQL Learn Oracle - How to Use Joins, Cross Join, Cartesian Product in SQL Learn Oracle - How to use Outer Joins (Left, Right, Full) in SQL Learn Oracle - How to use the Character Functions, Date Functions in SQL Learn Oracle - How to use the Merge Statement in SQL Learn Oracle - How to use the ORDER BY Clause with the Select Statement Learn Oracle - How to use the SELECT Statement Learn Oracle - How to use the Transactional Control Statements in SQL Learn Oracle - How to use PL SQL Learn Oracle - Data Types in PL SQL Learn Oracle - Exception Handling in PL SQL Learn Oracle - PL SQL Conditional Logics Learn Oracle - PL SQL Cursor Types - Explicit Cursor, Implicit Cursor Learn Oracle - PL SQL Loops Learn Oracle - Procedure Creation in PL SQL Learn Oracle - Select Statement with WHERE Cause Learn Oracle - SQL Operators and their Precedence Learn Oracle - Using Case Function, Decode Function in SQL Learn Oracle - Using Logical Operators in the WHERE Clause of the Select Statement Learn Oracle - Using Rollup Function, Cube Function Learn Oracle - Using Set Operators in SQL Learn Oracle - What are the Different SQL Data Types Learn Oracle - What are the different types of Databases Visit Pebbles Official Website - http://www.pebbles.in Subscribe to our Channel – https://www.youtube.com/channel/UCNNjWVsQqaMYccY044vtHJw?sub_confirmation=1 Engage with us on Facebook at https://www.facebook.com/PebblesChennai Please Like, Share, Comment & Subscribe
Views: 1393 Pebbles Tutorials