Home
Search results “Change parameters in oracle”
Oracle DB 12c - Instance Parameter Change Impact
 
09:41
Oracle DB 12c - Instance Parameter Change Impact Watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
Change Oracle Parameters   SPFILE
 
02:33
TADM51 - SAP Netweaver as DB Operations - Change Oracle Parameter - Create the SPFILE
Views: 1168 Mohamed Iliyas
SCPT 5: Parameter Files in Database
 
20:45
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 61539 Oresoft LWC
db files change
 
03:09
Change the DB_FILES parameter in ORACLE without changing the control file.
Views: 90 Imraan Grace
HOW TO RETURN MULTIPLE VALUES FROM A PROCEDURE IN ORACLE PL/SQL? (USING OUT PARAMETERS)
 
04:46
This video tutorial explains how an oracle procedure can return multiple values with a proper example. The video tutorial shows how this problem can be tacked using simple and easy to understand out parameters!!!
Views: 12727 Kishan Mashru
Dynamic Power BI reports using Parameters
 
12:21
In this video, Patrick shows you how you can use a parameter, within a Power BI report, to dynamically change the data in a report. This uses M Functions within Power Query and a second source that has the key values to pull. Then using a gateway to enable refresh. LET'S CONNECT! Guy in a Cube -- https://guyinacube.com -- http://twitter.com/guyinacube -- http://www.facebook.com/guyinacube -- Snapchat - guyinacube -- https://www.instagram.com/guyinacube/ ***Gear*** Check out my Tools page - https://guyinacube.com/tools/
Views: 82448 Guy in a Cube
Oracle Basics: Understanding the init.ora and spfile
 
20:54
Oracle Basics: The init.ora and spfile
Views: 30310 Chris Ostrowski
Oracle DBA Justin - How to reset RMAN persistent parameters back to their defaults
 
06:47
How to reset RMAN persistent parameters back to their defaults
Views: 2667 jbleistein11
3. How to Change a Prompt using Form Personalization (R12) - Oracle ERP Apps Guide
 
03:22
3. How to Change a Prompt using Form Personalization (R12) - Oracle ERP Apps Guide: In this tutorial, I have explained the How to Change a Prompt using Form Personalization. Thanks for watching everyone! Subscribe ► https://www.youtube.com/user/veluruga... Youtube Channel ► https://www.youtube.com/veluruga Facebook Page ► https://www.facebook.com/LearnOracleErpAppsGuide Faceook Group ► https://www.facebook.com/groups/oracleerpappsguide Google+ Communities ► https://plus.google.com/u/0/communities/111267855409088676081 Blog ► http://www.oracleerpappsguide.com Email ► [email protected] Happy Learning!.
Views: 1174 Oracle ERP Apps Guide
How to return multiple values from a function in oracle pl/sql ? (without using out parameter)
 
14:19
This video demonstrates how a function can return multiple values to the calling environment, but without using multiple out parameters, the video shows an example on how we can create a object, a nested table based on the object and then returning the nested table type from the function.
Views: 18645 Kishan Mashru
Oracle Apps Tutorial-19:Forms Personalization
 
52:31
Oracle Corporation, Enterprise Resource Planning, ERP, R12 User Creation, Oracle E-Business Suite (Business Operation), Oracle Database (Software), Oracle Training, Oracle E-Business Suite R12, Learning Oracle, Creating a User in Oracle, Oracle Tutorial, Oracle Financials ledgers, chart of account structure, balancing segment values (BSV), legal entities, MOAC, operating unit, R12, 11i, oracle, scm, apps, functional, purchasing, order management, discrete manufacturing, training, online, placement, certifications
Views: 28644 DataWarehouse
Changing calculation logic based on a column
 
06:39
This video demonstrated how to change the logic of a given row calculation based on the value in another column. You may run in to a scenerion where you need to implement this when you have a requirement that the rows with one dimension value have logic "X" (for instance Mean) and the the rows with a different dimension value have logic "Y" (for instance a Median) assigned. This is accomplished with the Switch (Case) expression in the OBIEE formula builder.
Views: 8084 Justin W. Steigerwalt
Howto Change Linux Boot Options and Splash Screen
 
05:02
Don't like how ugly your PC looks when you dual boot? Customize how your computer boots with Grub 2 - ||Join the chat: http://on.fb.me/follownix || In this tutorial I show you the basic ways to configure your bootloader. Lots of things have changed since the upgrade from the original Grub, so check out this week's episode of OS.ALT to learn more about how to make your boot menu boot-a-licious! Fight for the users in our Discord: https://discordapp.com/invite/CKYwgxA
Views: 153983 Nixie Pixel
Oracle - Understanding the tnsnames.ora and listener.ora files
 
12:46
Oracle - Understanding the tnsnames.ora and listener.ora files
Views: 186956 Chris Ostrowski
oracle date and time functions
 
21:33
Video from our Oracle SQL course. Check out the full course at.. http://learn.hackpress.co/courses/oracle-sql-learning-by-example
Views: 44281 etldeveloper
Changing parameters
 
04:42
This video discusses how to access and change parameters using the API. It exemplifies the different types of parameters, how to find them in the object model, and how to change them. Though this video explains parameters in the context of the API, it does not fully define parametric modeling and its usefulness. Enroll in this free course and learn more about 3D Design at Autodesk Design Academy: academy.autodesk.com
Create Dynamic Query Parameters in Power BI Desktop  - Power BI Tips & Tricks #47
 
09:11
Create Dynamic Query Parameters, filter your reports with them and create a template using Power BI. Links mentioned in the video: Chris Webb blog: https://blog.crossjoin.co.uk/2016/08/30/data-driven-power-bi-desktop-parameters-using-list-queries/ Rio Summer Olympics Report: https://www.youtube.com/watch?v=tZXY9RZwd3U Download the sample report: https://gofile.me/2kEOD/PaRdrp3aG Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI! https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1 Our PLAYLISTS: - Join our DAX Fridays! Series: https://goo.gl/FtUWUX - Power BI dashboards for beginners: https://goo.gl/9YzyDP - Power BI Tips & Tricks: https://goo.gl/H6kUbP - Power Bi and Google Analytics: https://goo.gl/ZNsY8l ABOUT CURBAL: Website: http://www.curbal.com Contact us: http://www.curbal.com/contact ▼▼▼▼▼▼▼▼▼▼ If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running: https://curbal.com/product/sponsor-me Many thanks in advance! ▲▲▲▲▲▲▲▲▲▲ QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: ► Twitter: @curbalen, @ruthpozuelo ► Google +: https://goo.gl/rvIBDP ► Facebook: https://goo.gl/bME2sB #POWERBITIPS #CURBAL #POWERBI #MVP ► Linkedin: https://goo.gl/3VW6Ky
Views: 39341 Curbal
Oracle DBA Justin - How to change the name of an Oracle database # 2 of 2
 
07:44
How to change the name of an Oracle database
Views: 3663 jbleistein11
PARAMETER FILE MGMT
 
11:55
About parameter file management oracle dba
Create EXCEL/PDF/html/etc Report from Oracle | Ten Minute Code
 
10:54
BELOW CODE cerate report server below commands windows key+R run paste -- rwserver server=showjobs status=on Declare repid REPORT_OBJECT; v_rep VARCHAR2(1000); rep_status VARCHAR2(20); PL_ID PARAMLIST; pr_nm varchar2(20):='PNM'; --rwserver server=SHOWJOBS EXCECUTE IT ON RUN v_rptserver varchar2(10):='SHOWJOBS'; ---- Change 1 v_host varchar2(20):='localhost'; ---- Change 2 -- v_rptserver varchar2(10):=:global.RWS1; -- v_host varchar2(20):=:global.IP1; BEGIN PL_ID := GET_PARAMETER_LIST(pr_nm); IF ID_NULL(PL_ID) = FALSE THEN DESTROY_PARAMETER_LIST(PL_ID); PL_ID := CREATE_PARAMETER_LIST(pr_nm); IF ID_NULL(PL_ID) THEN MESSAGE('ERROR CREATING PARAMETER LIST '||pr_nm); RAISE FORM_TRIGGER_FAILURE; END IF; ELSE PL_ID := CREATE_PARAMETER_LIST(pr_nm); END IF; --add parameter with separate statement for each parameter Add_Parameter(pl_id,'P_ECode',TEXT_PARAMETER,:P_ECode); ---change 3 your report have parameters Add_Parameter(pl_id,'P_ECode',TEXT_PARAMETER,:P_ECode); repid := find_report_object('DESG'); --- change 4 report name SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH); SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS); SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE); SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF'); -- change 5 pdf/html -- SET_report_object_property(repid,REPORT_DESFORMAT,:BLOCK3.REP_FORMAT); ------ need all format SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,v_rptserver); v_rep := RUN_REPORT_OBJECT(repid,PL_ID); rep_status := REPORT_OBJECT_STATUS(v_rep); IF rep_status = 'FINISHED' THEN WEB.SHOW_DOCUMENT('http://'||v_host||':8889/reports/rwservlet/getjobid' ||substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server='||v_rptserver,'_blank'); ELSE message('Error when running report'); END IF; END;
Views: 5640 Together Oracle
Move Oracle to Google Big Query in Real Time
 
04:43
You are going to see how you can move data, in real-time, from Oracle on-Premise to Google BigQuery running in the Google Cloud Platform using Striim and change data capture. You have data in lots of Oracle tables, on-premise. You want to move this into Google BigQuery for scalable low cost analytics, in real-time. How do you do this without affecting your production databases? In this demo, you see how you can utilize Striim, and our CDC wizards, to do real-time collection of change data capture from Oracle Database and deliver that, in real-time, into Google BigQuery. We also build a custom monitoring solution of the whole end-to-end data flow.
Views: 369 Striim
Oracle SQL Developer Tips : How to change the language
 
02:38
To get the complete FREE course on Oracle SQL Developer click here: https://www.udemy.com/oracle-sql-developer-tips-and-tricks/ In this video I show you how to change the language of Oracle SQL Developer 's user interface. This is an excerpt of the *FREE* course " Oracle SQL Developer : Tips And Tricks" ( https://www.udemy.com/oracle-sql-developer-tips-and-tricks/ ) Want to learn SQL ? Here is a discounted course for you: http://bit.ly/oracle-sql-course You can find additional Oracle SQL related articles and educational content in my blog here: http://standout-dev.com/
Views: 8969 Oracle SQL
08 of  13 - Oracle APEX 5 - List of values (LOV) for a field in a form; display a hidden column
 
13:22
A new series using APEX 18.1 is now available. https://youtu.be/vgrkiIpJEiQ This is one in a series of videos about creating an application using Oracle APEX 5. In this video we create two lists of values (LOVs) in the Shared Components section of our application. We use each LOV in place of a field in a form. We see how APEX will help us write the SQL for a LOV. The difference between a "display value"and a "return value"is discussed. Finally, we display the primary key field in a form, which APEX hides by default. See the primary key field in a form can be helpful during application development. SQL scripts for this series are available to download at: http://db.kreie.net
Views: 36631 Jennifer Kreie
Formatting Columns Using Oracle BI EE
 
05:29
This video teaches you how to format columns in an analysis. You add color, add currency, override the data format, and add conditional formatting. To find out more about Oracle BI EE, see the documentation at https://docs.oracle.com/en/middleware 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.
Oracle GoldenGate Change Capture Flow - GG Video 15 ( with annotations)
 
04:32
In this video you learn about the various options in deploying the Extract and Pump to send TRAIL to a remote host. . Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 1338 Ramkumar Swaminathan
How to Hack Into Your Oracle Database via Node js Using SQL Injection
 
58:06
https://developer.oracle.com/code/online | Dan McGhan, Chris Saxon: Hackers are constantly searching for personal data they can use to exploit people. And they’re often successful. Each week brings new stories of large-scale data breaches. A common attack vector is SQL injection. If your application is vulnerable to this, hackers can get whatever they want from your database. This session shows you how easy it is to access private data with SQL injection and how to change your code to stop it. It ends with a discussion of further recommendations for writing secure code. This is a must-attend session for all developers who write database access code.
Views: 986 Oracle Developers
How to Install Oracle! !! Database Training
 
01:50
For Complete Database Training Details Visit: http://www.qaonlinetraining.com http://infotek-solutions.com/ Delivery Method: Instructor led classroom and Online Training supported by world class Learning management system which automate all flow of lectures, videos, assignments, forums, quizzes and interview process. Class Schedule: Week-ends and Weekdays Contact Us: 571-437-0652, Mail Us: [email protected] Training Locations at : Ashburn / Fairfax / Maryland Office Address: 12801 Worldgate Dr #500, Herndon, VA 20170 Overview of Oracle DBA Training Oracle as a flexible, complex & robust RDBMS The evolution of hardware and the relation to Oracle Different DBA job roles (VP of DBA, developer DBA, production DBA, database babysitter) The changing job role of the Oracle DBA Environment management (network, CPU, disk and RAM) Instance management (managing SGA regions) Oracle table and index management Instance Architecture Instance vs. database Components of an instance Creating the OFA file structure ($DBA, bdump, udump, pfile) Oracle Instance Internals SGA vs. PGA Background processes Interfaces with server and disk I/O subsystem Using SQL*Plus for DBA management Connecting and executing SQL Using the “as sysdba” syntax Overview of SQL*Plus DBA commands (startup, etc.) Control file, UNDO and REDO management Explaining the use of control files Listing the Contents of the control File File locations for control Files Obtaining Control File Information Listing control file contents Displaying and Creating Undo segments Altering Undo Segments Determining the Number and Size of Undo segments Understanding flashback technology Troubleshooting Undo – snapshot too old Redo log concepts for recovery Online redo log (log_buffer) online redo logs and archived redo logs Oracle ARCH and LGWR background processes Redo log dictionary queries Redo log switch frequency and performance Multiplexing the Online Redo Log Files Archiving the Oracle Redo Logs Recovery using the redo log files User and privilege management The three security methods (VPD, Grant security/role-based security, grant execute) Creating New Database Users Using pre-spawned Oracle connections Auditing User activity Identifying System and Object Privileges Granting and Revoking Privileges Creating and Modifying Roles Displaying user security Information from the Data Dictionary Overview of instance management Parameter files (init.ora, listener.ora, tnsnames.ora) Rules for sizing SGA components Automated Oracle memory management (AMM) Initialization file management Creating the init.ora file Using spfile Displaying init.ora values with v$parameter Oracle*Net configuration Creating the listener.ora file Creating the tnsnames.ora file Data buffer configuration & sizing Inside the Oracle data buffers Using the KEEP pool Monitoring buffer effectiveness Using multiple blocksizes (multiple buffer pools) Shared pool and PGA configuration & Sizing Shared pool concepts and components Understanding the library cache Relieving shared pool contention Overview of PGA for sorting and hash joins Using sort_area_size, hash_area_size and pga_aggregate_target Troubleshooting network connectivity Verifying network connectivity with ping and tnsping Testing database links Oracle tables, views and materialized views Types of Oracle tables (regular, IOT, sorted hash clusters, nested tables) Oracle Views Oracle materialized views Oracle indexes Types of Oracle indexes (b-tree, bitmap, bitmap join index) Creating B*-Tree, bitmap and function-based Indexes Function-based indexes Finding indexing opportunities Index maintenance Oracle constraints Costs & benefits of constraints Types of Oracle indexes constraints (check, not null, unique, PK, FK) Cascading constraints Schema, File & tablespace management Describing the relationship between data files, tablespaces and table Understanding Oracle segments Creating Tablespaces – using the autoextend option Changing the Size of Tablespaces – alter database datafile command Defining a TEMP tablespace Changing the default storage Settings for a tablespace Review of the storage parameters in DBA views (ASM, ASSM, pctfree, pctused and freelists). Monitoring Chained rows (fetch continued rows) Monitoring Insert and Update performance (pctused, APPEND) Database Maintenance Reason for reorgs – chained rows, imbalanced freelists Reorganizing Tables using Export and Import Using CTAS to reorganize data Index rebuilding Backup & Recovery overview (hot & cold Backups, RMAN, block change tracking) Oracle DBA Utilities Data pump (Imp and exp utilities) SQL*Loader LogMiner Flashback DataGuard Oracle DBA utilities – Oracle dbms packages (dbms_redefinition)
GLOBAL TEMPORARY TABLE (GTT) IN ORACLE SQL WITH EXAMPLES
 
13:33
This video demonstrates the usage and working of GTT in oracle SQL. The video shows how internally oracle works with GTT, and also explains the working of ON COMMIT DELETE ROWS and ON COMMIT PRESERVER ROWS in oracle with easy examples.
Views: 8824 Kishan Mashru
Migrating Database to Amazon RDS
 
13:06
Amazon RDS is a mature Database as a Service offering from AWS. This screencast will cover the setup and configuration of a MySQL database and how to import data.
Views: 64651 Janakiram MSV
Redo Logs in an Oracle Database - DBArch Video 11
 
08:54
This video explains the concepts of Redo Log Groups and Files in an Oracle Database. You will understand how Oracle Instance uses Redo Buffers and Logwriter to keep the redo in Redo Logs. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 16715 Ramkumar Swaminathan
CredSSP Encryption Oracle Remediation Error in Windows 10 (SOLVED)
 
03:15
Fix CredSSP Encryption Oracle Remediation Error In Windows 10: https://techempty.org/?p=708 Those of you who may have installed the security updates on Windows 10 workstations recently in the past few days may notice that you receive a strange error when trying to establish a remote desktop connection to a server that worked before like An Authentication error has occurred. The function requested is not supported. CredSSP Encryption Oracle Remediation Error after updating the Windows 10 computer. And here is the fix showing you on how to rectify CredSSP Encryption Oracle Remediation Error by following these two simple methods. Basically, the reason behind this error is, when you try to connect to the client whose Windows machine is outdated, you may get this CredSSP Encryption Oracle Remediation Error. When both the clients are up to date, then you won’t get any kind of error. Now let’s take a look at Windows 10 RDP CredSSP encryption oracle remediation error fix. The first one. Search for ‘Edit Group Policy’ and then open it. Now under the ‘Computer Configuration’, expand the ‘Administrative Tools’ then ‘System’ then ‘Credentials Delegation’ and here find ‘Encryption Oracle Remediation’. Right click on it then choose ‘Edit’ and now here Enable Encryption Oracle Remediation then change the protection level to ‘Vulnerable.’ Finally, Apply the changes then click on Ok. Here is how you can fix CredSSP Encryption Oracle Remediation Error In Windows 10. Second method is for the one who doesn’t have Group Policy editor or can’t find the Encryption Oracle Remediation within Group Policy editor. Search for ‘regedit’ to open the registry editor. Now expand ‘HKEY_LOCAL_MACHINE’ then ‘Software’ then ‘Microsoft’ then ‘Windows’ then ‘CurrentVersion’ then ‘Policies’ then ‘System’. Now you need to create a new key. So, right click on the System folder then choose ‘New Key’ and name it as CredSSP. Again create another ‘Key’ within CredSSP with the name ‘Parameters’. Inside the Parameters, you need to create a new DWORD value and name it as ‘AllowEncryptionOracle’. Finally change the DWORD value to 2 and Base to ‘Decimal.’ Save all the settings then try to connect to the RDP client. Subscribe to TechEmpty at https://www.youtube.com/user/techempty?sub_confirmation=1 **Stay Connected with Sai Praveen** Facebook: https://www.facebook.com/imsaipraveen Twitter: https://twitter.com/praveenhub Google Plus: https://plus.google.com/+techempty Website: https://techempty.org
Views: 27938 TechEmpty
How to Change Oracle Database Name Manually without using Nid Utility
 
24:21
We can change Oracle Database Name Manually without using nid utility. In this video i am showing you we can change database name using modifying controlfile. First we take a backup of controlfile. alter database backup controlfile to trace as '/location'; Modify some parameter in this controlfile backup. In the place of Reuse Set Old Database name New Database Name Noresetlogs Resetlogs It is very easy to understand. Follow this steps.
Views: 606 Parag Mahalle
Oracle-creer un spfile apartir d'un pfile || oracle-create a spfile from a pfile
 
05:37
sorry i have an audio problems but ready to answer your questions ! if i can of course the oracle used in this video is the latest version 12C you need to be connected with the sysdba acount to create the spfile because of the less priveleges of bouth sys and system accounts that's why i used the command prombt hope you like the video
Views: 204 Soufiane Nabbat
Crystal Reports Tip: Creating Dynamic Parameters
 
13:51
How to create a dynamic parameter and examine the attributes of a parameter
Views: 124300 SymphonyCorp
Configuring the Kernel Launch Parameters Part 1 - Intro to Parallel Programming
 
04:18
This video is part of an online course, Intro to Parallel Programming. Check out the course here: https://www.udacity.com/course/cs344.
Views: 15342 Udacity
SAP Basis/NetWeaver - How to change TP parameters
 
03:28
SAP Basisの技術情報 「TPパラメータの変更方法について」 http://sapbasis.blog.fc2.com/blog-entry-46.html
Views: 1215 KasuyaC
5. By the Poolside: Application Module Pool Advanced Settings
 
22:42
This is the fifth in a series of videos to introduce Oracle's ADF Business Component Application Module Pool and its parameters. This video investigates some of the advanced parameters that change the overall behaviour of the pool and how the AMs behave. Overall this series of videos takes a progressive learning approach to introducing the AM pool and its settings. As such new viewers are recommended to watch the video series end-to-end to ensure they understand the full set of concepts. Previous video: - By the Poolside: Cleaning the Application Module Pool - http://youtu.be/sc1WMT89Lvc
Views: 1662 ADFInsiderEssentials
Oracle OCP (1Z0-053) Lesson 3 - Setting up Kernel parameters and Installing additional packages
 
26:12
Learn Oracle with these series of videos leading to Oracle Database 11g Administrator II (1Z0-053) exam.
Views: 454 Ogutu Ochieng
Audit table changes in sql server
 
06:45
sql server 2008 ddl trigger audit sql server table changes tracking In this video we will discuss, how to audit table changes in SQL Server using a DDL trigger. Table to store the audit data Create table TableChanges ( DatabaseName nvarchar(250), TableName nvarchar(250), EventType nvarchar(250), LoginName nvarchar(250), SQLCommand nvarchar(2500), AuditDateTime datetime ) Go The following trigger audits all table changes in all databases on a SQL Server. CREATE TRIGGER tr_AuditTableChanges ON ALL SERVER FOR CREATE_TABLE, ALTER_TABLE, DROP_TABLE AS BEGIN DECLARE @EventData XML SELECT @EventData = EVENTDATA() INSERT INTO SampleDB.dbo.TableChanges (DatabaseName, TableName, EventType, LoginName, SQLCommand, AuditDateTime) VALUES ( @EventData.value('(/EVENT_INSTANCE/DatabaseName)[1]', 'varchar(250)'), @EventData.value('(/EVENT_INSTANCE/ObjectName)[1]', 'varchar(250)'), @EventData.value('(/EVENT_INSTANCE/EventType)[1]', 'nvarchar(250)'), @EventData.value('(/EVENT_INSTANCE/LoginName)[1]', 'varchar(250)'), @EventData.value('(/EVENT_INSTANCE/TSQLCommand)[1]', 'nvarchar(2500)'), GetDate() ) END In the above example we are using EventData() function which returns event data in XML format. Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/audit-table-changes-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/audit-table-changes-in-sql-server_12.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 Full SQL Server Course https://www.youtube.com/playlist?list=PL4cyC4G0M1RQ_Rm52cQ4CcOJ_T_HXeMB4 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: 40237 kudvenkat
INSTALLING ORACLE 12c DB WITH DBCA
 
06:43
This video shows how to install a non-cdb database using a file system with the 12c installer. To save space, the flash recovery area is reduced. You can use the menus to change this to suit your needs. The installation does not take advantage of multiplexing files on different areas of storage. However, you can do this later, moving controlfiles and log files onto different file systems to simulate real life DBA tasks.
How to write post query trigger in Oracle Forms.
 
06:57
How to write post query trigger in Oracle Forms. Post query triggers at block level to retrieve data from other table. This is a small tutorial in Oracle forms to show you creating forms post query trigger, writing pl sql code into triggers.
Views: 8391 Subhroneel Ganguly
Oracle DBA, How to setup SQL Prompt, 1e21
 
06:04
The video will show you how to change SQL promot to show username and Database name.
Views: 2046 hammadshams
Oracle SQL Tutorial 30 - UTF-8 and UTF-16 Character Sets
 
04:01
A few videos ago we discussed UTF-8 and UTF-16 encoding, but when we are working with a database we do not worry about encodings as much as we do character sets. That's because a specific character set is going to have a specific encoding. The reason I am making this video is to introduce you to the most common character sets and to teach you the differences. That’s because as we go into the national character sets we need to understand the information taught in this video. So the first character set I am going to teach you about is AL32UTF8. AL32UTF8 is a character set that uses the uff-8 encoding and each character can take up to 4 bytes with the utf-8 encoding. There is another character set (not encoding) called utf8 (no hyphen) which is also encoded with UTF-8. This can be a little confusing because UTF8 is the name of an encoding and a character set, but bear with me. Both of these character sets are UTF-8 encoded, but UTF8 uses an older version of UTF-8 encoding. Generally, they work about the same, but the way certain characters are stored is slightly different, specifically way certain characters are stored is slightly different, specifically what are known as supplementary characters, which take up 4 bytes. The max size for a UTF8 character set is 3 bytes, as they do not directly support the supplementary characters as 4 bytes but instead store them across 2 groups of 3 bytes each. Oracle recommends that you use AL32UTF8 for all future development instead of the archaic UTF8 character set. There is another character set that you should know about, and that is AL16UTF16, which uses the UTF-16 encoding. Watch my video over UTF-8 and UTF-16 to learn more about UTF-16. Lastly, there is a character set known as UTFE, which uses an encoding known as UTF-EBCDIC. This is like a super archaic character set, and I'm not even going to talk about it. I thought I would at least mention it as it is going to come up a bit in the next video's topic. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support me! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 6583 Caleb Curry
oracle 10g db installation 2
 
06:53
step by step installation of oracle 10g database
Views: 21493 Shahid Patel
Reporting Services (SSRS) Part 2 - Data Sources and Datasets
 
11:56
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! By Andrew Gould https://www.wiseowl.co.uk - Learn how to create data sources and datasets in Microsoft SQL Server Reporting Services. This video teaches you how to link your Report Server project to a database by creating a data source and how to create datasets to extract specific information from the database. We'll teach you the difference between shared and embedded data sources and datasets and show you how to use the Query Designer tool to make your life simple when it comes to building queries. You can download the script to create the Movies database used in this video at the following link: https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Views: 283839 WiseOwlTutorials

Use of atarax 25mg
Bayers aspirin 81mg
Levitra 10 mg cp orodispers
Dihydroxyaluminum allantoinate 50 mg benadryl
Amitriptyline 20 mg withdrawal