Search results “Vbscript and oracle”
How to connect Excel to Oracle with VBA
This video will show you how can you connect to a Oracle database and read data into your Excel sheet using VBA programming. Source Code: https://github.com/woolfool/ExcelConnectToOracle
Views: 28433 WoolFool
VBScript 11 Database handling
Connect to database, execute select or insert queries, fetch records
Views: 5414 Free OpenMentor
VBScript Database Objects
VBScript Database Objects Tutorial explains Usage of Database Connection object and Database Recordset object. Creating Database objects, creating database connection string, fetch data from a database using SQL Commands. Working with Databases in UFT using VBScript.
Views: 3429 G C Reddy
VBScript Working with Databases and SQL - tutorial 8
Learn vb scripting for beginners with code shown in this vbs training. Click Cc button to see subtitles in English. Next, start learning HTML at http://youtu.be/I0Y2oyBmv6Q
ADODB connection in visual basic (vb6) with oracle database
This video briefly explains ADODB connection in vb6 using ADO for data bases to oracle database
Views: 35246 Vijay Thombre
How to link Oracle 10g with VB 6.0
This video shows how to: -Establish connection between Oracle 10g(eXpress Edition) with Visual Basic 6.0 -Create a data grid -Create drop down menu's
Views: 26169 gauthamkv
Validating the database using UFT & VBScript with and without checkpoint
This video explains how to use database checkpoint and how to write script for validating the database using ADODB object. I have explained for SQL Server. I will upload for Oracle in other video.
Views: 4865 nanda.D Reddy
QTP Part 69 VBScript ADODB
Handle database thru vbscript
Views: 3222 Free OpenMentor
How to run VBScript programs !! Database Training Training ! Infotek-SolutionInc
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)
Tutorial: Basics of CMD and VBS Scripting: Part 1
Don't forget to like and subscribe if you enjoyed. If you have any questions please tell me in the comments and I will respond as soon as I can. Twitter: https://twitter.com/BBQGrapes CMD Colour Codes 0 = Black 8 = Gray 1 = Blue 9 = Light Blue 2 = Green A = Light Green 3 = Aqua B = Light Aqua 4 = Red C = Light Red 5 = Purple D = Light Purple 6 = Yellow E = Light Yellow 7 = White F = Bright White
Views: 139 Zentorano
Web Browser Troll [vbs and Batch Tutorial]
In diesem kleinem Video zeige ich euch wie man auf einfachste mittle eine andere Person trollen kann :D. (Nur zur Demonstration und Ich hafte auch nicht bei Nachstellungen) Mfg AngryFrogGaming
Views: 529 AngryFrogGaming
VBScript and CSS|HTML
Let’s learn HTML Lesson VBScript and CSS. Access all educational video only on Edubull.
Views: 86 EDUBULL
Basics of oracle backups automation
Learn basics of how to automate backups in oracle
Views: 157 DBATALENT
How to create VB script in Sql || PL/SQL ||
Views: 103 Vinod vinu
VBScript - Excel background colors or font styles and ranges
This video explains how to interact with excel cells to change font or background colors and how to work with ranges.
Views: 364 nanda.D Reddy
Studi Kasus Rental Car Oracle-VB
Praktikum 31 Basis Data 2
Views: 14 dbSoulActivity
Database Scripts in UFT
Database Scripts in UFT using Vbscript database connection object and Database recordset object. UFT Scripting examples, working with Database, Excel and File system Objects.
Views: 8147 G C Reddy
Use VB script to run Excel macro
How to use Visual Basic Script to run Excel macro with single click. This technique can be use with Windows Task Scheduler to fully automate the process. Follow us on Facebook: https://www.facebook.com/theRedStapler Website: http://redstapler.co/ Twitter: https://twitter.com/redStapler_twit
Views: 73750 Red Stapler
Create SQL Database in WinCC with Script
Hvordan implementeres scriptet i WinCC. Project kan be downloaded here: https://support.industry.siemens.com/cs/document/61883659/how-do-you-access-an-sql-database-in-wincc-runtime-advanced-using-a-script-?dti=0&lc=en-WW
Views: 28735 RotaxAams
Oracle Conn With Asp.Net.wmv
Hi Viewers Thiz is My first tutorial Of Oracle Connection With Asp.Net.Its Audio Version Will Be Coming Soon.If u Have Any Problem Regarding This Tutorial Feel Free to Comments me And u Can Also Email Me [email protected]
Views: 14265 Salman Sabir
Finding the word count of a string using VBScript
This video will show you how to find the word count of a string using the split command in VBScript. This is part of an ongoing tutorial series designed to help writers to get software tools that will help objectively improve their writing. To download Notepad++ (referenced in the video) go to: https://notepad-plus-plus.org/
Views: 122 Peter Pike
VBScript Tutorial 4
VBScript Conditional and Loop Statements tutorial explains If statement, Select case statement, Else if, Nesd if etc... VBScript Loop structures For loop, While loop, Do loop, For Each Next loop and Terminating For loop and Terminating Do loop.
Views: 9595 G C Reddy
VBScript Tutorial 5
VBScript Tutorial: VBScript User defined functions, Sub procedures, Sub procedures with arguments, Function procedures with arguments, Function procedure with returning value, Function procedure with returning multiple values and Calling functions within functions. Creating function library files, associating function libraries and calling functions. VBScript Built in functions, Date & Time functions, String functions, Array functions and Conversion functions.
Views: 8526 G C Reddy
Part 1 - Website and Database Connection - Scripting Languages ASP VBScript ASP.NET PHP
Scripting Languages - website connections to data sources Part 1 of 4 - Total Web Info Totalwebinfo
Views: 22506 totalwebinfo
QTP Database connection
QTP , Automation testing
Views: 7893 Prasad QTP
Checkpoint Oracle 11g - Bases de Datos USAC
En este vídeo se demuestra el uso del checkpoint en oracle 11g Link de Scripts: https://mega.co.nz/#!hVdQ3S4K!EiVwJAMX9uvENS0nRSlgQmhtP8tjiq3dnQ_xER_m_1w
Views: 545 Gary Lopez
QTP - Quick trick if QTP/UFT is not recognizing objects in your application.
http://www.joecolantonio.com/2013/09/26/qtp-uft-object-recognition-issues-with-net/ If you are like me the first thing I do when testing a new object with QTP is use the SPY to check out the files that I need to automate. If the QTP Spy has object recognition issues I rarely try to record against it. But in this case doing a quick throw away recording first actually helps.
Views: 18159 Joe Colantonio
How to fetch data from database in QTP
In QTP you can read data from tables of a database using vbscript adodb object. You can find record count using select sql query in QTP. You can get more information on http://qtp-interview-questions.blogspot.in If you like this video, Please thumbs up it. Thanks for your time.
Views: 9906 Sagar S
Oracle Connection to QuerySurge
Learn how to make a connection from Oracle to QuerySurge. For more information on QuerySurge, the leading data testing solution for Big Data and Data Warehouses, please visit: www.QuerySurge.com For more instructional videos, please visit: http://www.querysurge.com/product-tour/video-library
Views: 207 RTTStv
Views: 37915 Excel Vba Tutorial
Using INSTR Function
Using INSTR Function
Views: 914 Abe Samir's Academy
How to create DSN to connect Oracle Database using ODBC
How to create DSN to connect Oracle Database using ODBC
Views: 6100 Web illusion
Visual basic for beginners in hindi
In this video you can learn visual basic in Hindi Computer class in Shri sai baba adarsh collage ambikapur Download Flipcart App for Amazing Offer- http://fkrt.it/oehfpTuuuN Filpcart affiliate - Lenevo k5 note - http://fkrt.it/6di3n!NNNN Redmi note 4(64GB) - http://fkrt.it/oXvIpTuuuN -~-~~-~~~-~~-~- Please watch: "Vlogit - Best free video editing application | 2018" https://www.youtube.com/watch?v=jGEPDj2uEQc -~-~~-~~~-~~-~-
Views: 220724 Hindi Tips Duniya
Hi, This is Akhil Reddy from AkhilReddy Technologies. We provide classroom and online training on Software Testing Tools. We are providing Manual and Automation,in Automation QTP,QC,LR,Selenium,ETL Testing,MOBILE testing,SQL Server content of course Please visit Our website www.AkhilReddy.com FOR MORE DETAILS CALL ME ON:9440592994
Understanding the Oracle Social Network Web Client
Learn how to navigate Oracle Social Network's web interface and use the filters and global search functionality to quickly find what you are looking for. 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.
Calling a stored procedure with output parameters   Part 7
Text version of the video http://csharp-video-tutorials.blogspot.com/2012/10/calling-stored-procedure-with-output.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-7-calling-stored-procedure-with.html All ADO .NET Text Articles http://csharp-video-tutorials.blogspot.com/p/free-adonet-video-tutorial.html All ADO .NET Slides http://csharp-video-tutorials.blogspot.com/p/adonet-slides.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 In this video, we will learn about calling a stored procedure with output parameters from an asp.net web application.
Views: 186176 kudvenkat
Excel Macros y Virus VBS - Visual Basic Script
Explicación básica de los eventos MouseMove sobre formularios y Labels. Además cómo crear archivos vbs para jugar con la computadora.
Views: 3363 Joseth David Guerrero
One stop Installation of Oracle Virtual Box Windows7 and HP UFT
One stop Installation of Oracle Virtual Box Windows7 and HP UFT/QTP
Views: 553 QA eLearn
Winlock.vbs  КАК сделать winlock?
ВНИМАНИЕ!!! Вся информация предоставлена исключительно в ознакомительных целях и я не несу ответственность за все Ваши действия! Я в ВК:https://vk.com/id400396022 Всем привет, я Hacker Black и я решил что буду делать обзоры на вирусы которые можно сделать с помощью Блокнота. Это подобие Винлокера Вот скрипт: Do msgbox"Ваш компьютер заблокирован!",99,"Винлокер" x = inputbox("Не вкоем случае не перезагружайте компьютер иначе удалиться система!") if (x = "пароль") then msgbox"Нажмите ок для продолжения",64,"Закрытие скрипта" exit do else msgbox"окно не закроется!",99,"Винлокер" end if loop Также есть более сильный winlock. Вот ссылка на файл:http://rgho.st/7ZjNVcYwk
Views: 497 Hacker Black
Oracle 12c_Lesson10: Managing Data Concurrency
Oracle Database 12c Administration Workshop
Views: 83 B N H
Oracle APEX -  Form and Report Validation on Oracle APEX
Developer:Md.Abdullah Al Mamun Contact-01827712531 helpline: facebook.com/benq.mamun
Views: 569 Oracle Apex
VBScript: How To Make A Myspace Auto Logon Program Sub4Sub
Well, as the name implies, it will log you into Myspace, using the information you put into it. And, of course, you need to replace the "Email" and "Password" things with your email and password. Rate, Comment, Subscribe! *******Code******* set a = createobject("wscript.shell") a.run "http://www.myspace.com/" wscript.sleep (5000) a.sendkeys chr(9) wscript.sleep (2000) a.sendkeys ("EMAIL GOES HERE") a.sendkeys chr(9) wscript.sleep (2000) a.sendkeys ("PASSWORD GOES HERE") a.sendkeys "{Enter}" wscript.quit
Views: 609 FireBirdTutorials
SQL: Optimizer Hints Part-3
In this tutorial, you'll learn...what are optimizer hints and how to use it.. SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems.
Views: 10295 radhikaravikumar
Difference between functions and procedures in vbscript
This video gives examples of and tutorials of functions and procedures in vb script.
Views: 1496 Sagar S
Validate the database using Database checkpoint and using ADODB object in VBScript and UFT
This video explains about how to validate the database using Database Checkpoint of UFT and using ADODB object of VBScript/UFT. For detail information and usage of ADODB object, watch my next video related to ADODB object.
Views: 880 nanda.D Reddy
2 - Working with PowerShell to perform SQL tasks
This video outlines how to work with Powershell.exe and the SQL Command Mode to create automated tasks.
Views: 356 Randal Root