Home
Search results “Package text oracle”
79 - Oracle PL/SQL- Stored Program Units (Procedure, Function,Package) أوراكل
 
01:41:48
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج Database 2 - Oracle PL/SQL Stored Program Units (Procedures, Functions,Packages) in Arabic Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W
How to Debug a Oracle Procedure | Package with PL/SQL Developer
 
09:20
This Video will show you the simple and efficient way to Debugging your Procedure | Package with PL/SQL Developer..
Views: 7555 Oracle PL/SQL World
Oracle PLSQL Training | How to Create an Oracle PL-SQL Package Specification | Video Tutorial
 
11:51
This PL-SQL video tutorial from https://www.fireboxtraining.com/oracle demonstrates how to create a PL-SQL package specification, as well as the package body. We will place PL-SQL functions and proceures into the package, then call the code from a PL-SQL code block.
Views: 17261 Firebox Training
IO8: Sending mail from PL/SQL with UTL_MAIL
 
05:00
Learn how to use the UTL_MAIL package to send mail from within your PL/SQL program. Download my demo.zip from v.gd/sfdemo to access and run all referenced scripts. This video was taken from PLSQLChannel.com, originally recorded before Steven Feuerstein re-joined Oracle in March 2014. ======================================== Practically Perfect PL/SQL with Steven Feuerstein 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.
78- Oracle Packages تعليم أوراكل
 
29:31
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج Database 2 - PL/SQL Packages in Arabic Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W
Oracle developer g11- 31- Creating Packages
 
12:15
============ رابط دورة C#: http://goo.gl/SFrRC8 رابط دورة aps.net: http://goo.gl/NtH3q5 رابط دورة Wordpress: http://goo.gl/6hYT0q رابط دورة artisteer: http://goo.gl/Lnax8k رابط دورة Visual basic 2012: http://goo.gl/fXYjcT رابط دورة MCITP: http://goo.gl/4vcmgM رابط دورة Autoplay media studio8: http://goo.gl/hFbdil رابط دورة dreamweaver cs5: http://goo.gl/p8EIle رابط دورة Oracle developer g11: http://goo.gl/NY2a64 رابط دورة Access 2007: http://goo.gl/gtQdr1 رابط دورة sql 2008: http://goo.gl/hjdXM0 رابط دورة primavira: http://goo.gl/Abq8eA رابط دزورة Linux: http://goo.gl/uJqkH2 رابط دورة Photoshop cs6: http://goo.gl/2UAb7P رابط دورة التسويق الشبكي: http://goo.gl/9F9PA2 رابط دورة التنمية الإدارية: http://goo.gl/6bJnHW ------------ لمتابعة باقي دورات موقعنا يمكنك زيارتنا على موقع وصفحة وقف أون لاين http://www.waqfonline.com http://www.facebook.com/Waqfonline
Basics of jdbc programming Tutorial-10(Storing a text file into oracle database)
 
10:36
this video deals with the overall idea of how the jdbc program is connected to the database in order to store a text file //storing of a text file to oracle database import java.sql.*; import java.io.*; class Jdbc { public static void main(String[] args) throws Exception { Connection con=null; PreparedStatement pst=null; try { Class.forName("oracle.jdbc.driver.OracleDriver"); con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "student","shubham123"); if(con!=null) { System.out.println("connection established"); pst=con.prepareStatement("update myfile set col1=? where col2=100"); } if(pst!=null) { System.out.println("preparedstatement object created"); File f=new File("f:\\hello.txt"); FileReader fr =new FileReader(f); pst.setCharacterStream(1,fr,(int)f.length()); System.out.println("file size="+f.length()); int i=pst.executeUpdate(); System.out.println(i+" records affected"); } } catch(SQLException e) { e.printStackTrace(); } catch(ClassNotFoundException e) { e.printStackTrace(); } catch(Exception e) { e.printStackTrace(); } finally { pst.close(); con.close(); } } }
Views: 100 Learn it by Fun
create report from package - pipeline pl/sql Oracle
 
02:15
12-march-2017 Oracle Apex create report from package - pipeline pl/sql steps 1. Create package on dept from HR 2. Package Specification create or replace PACKAGE r_deptinfo AS TYPE t_row IS RECORD ( DEPTNO NUMBER(2,0), DNAME varchar2(60), LOC varchar2(60) ); TYPE t_tab IS TABLE OF t_row; FUNCTION get_tab(p_DEPTNO number) RETURN t_tab PIPELINED; END; / 3. Package body create or replace PACKAGE BODY r_deptinfo AS FUNCTION get_tab(p_DEPTNO number) RETURN t_tab PIPELINED IS l_row t_row; cursor c1 is select DEPTNO, DNAME, LOC from dept where (DEPTNO = p_DEPTNO or 1=1); BEGIN FOR r1 IN c1 LOOP l_row.DEPTNO := r1.DEPTNO; l_row.DNAME := r1.DNAME; l_row.LOC := r1.LOC; PIPE ROW (l_row); END LOOP; RETURN; END; END; / 4. Call package select DEPTNO, DNAME, LOC from table(r_deptinfo.get_tab(10)); col DNAME for a30 col LOC for a30 drop package r_deptinfo / 5. now we can use it anywhere as a sql statement thats it Thanks . . .
Views: 594 Mostafiz Mitul
61/125 Oracle PLSQL: Supplied  Packages  / DBMS_OUTPUT
 
16:00
تعلم اوراكل حتى الاحتراف Learn oracle Learn Oracle PLSQL EXAM 1Z0-144
Views: 519 khaled alkhudari
IO4: Rename, Move, Copy Files with UTL_FILE
 
14:22
UTL_FILE offers a number of high-level subprograms to perform activities like copying a file, renaming a file, and removing a file. Download my demo.zip from v.gd/sfdemo to access and run all referenced scripts. This video was taken from PLSQLChannel.com, originally recorded before Steven Feuerstein re-joined Oracle in March 2014. ======================================== Practically Perfect PL/SQL with Steven Feuerstein 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.
SQLTools and Sublime Text - Executing SQL, directly in your editor
 
05:07
In this tutorial, I show you the excellent SQLTools package for Sublime Text and how it can be used to connect to your databases and run SQL commands directly in your favourite editor
Views: 7454 Greg Bird
Oracle DBA Justin - How to execute sql and Sqlplus commands from an external script
 
09:33
How to execute sql and Sqlplus commands from an external script
Views: 82385 jbleistein11
PL/SQL Developer Test Manager: Regression testing all routines in a package
 
00:34
Short AVI demonstrating the use of a testing, like Allround Automation's PL/SQL Developer Test Manager, to mimic much of what tools like Junit give you: push-button, fear-reducing full regression test of a library of related units.
Views: 1377 Bill Coulam
Using the database/sql Package (Episode 13)
 
05:34
This screencast talks about how to use the database/sql (https://godoc.org/database/sql) package to do the basic CRUD interactions against a supported database. In the example code, we present a structured approach to best organize your code, access rows in the database, and store your data while it's in memory. Code and outlines are available on Github at: https://github.com/arschles/go-in-5-minutes/tree/master/episode13 Sign up for our newsletter to get new screencast notifications by email: http://www.goin5minutes.com/subscribe/index.html.
Views: 8352 Go In 5 Minutes
60/125 Oracle PLSQL: Supplied  Packages  / Introduction
 
07:18
تعلم اوراكل حتى الاحتراف Learn Oracle PLSQL EXAM 1Z0-144
Views: 475 khaled alkhudari
The Undiscovered Country: Useful Built-in Database Packages You've Never Heard About
 
01:07:53
Presented by Morten Egan 13 September 2012 Summary In this session we will take a look at some of the lesser known PL/SQL packages that come with the Oracle database. Packages like DBMS_ASSERT, DBMS_CRYPTO and DBMS_PARALLEL_EXECUTE. We will take a look at some of the utility packages that could come in handy such as UTL_NLA and UTL_MATCH, look briefly at some of the helper functions from UTL_INADDR and UTL_URL. At the end, I will take a look at some of the good packages from the Oracle community that will help you get your work done faster and smarter. A live Q&A session with Morten Egan will follow the presentation. For our complete archive, and to sign up for upcoming webinars please go to http://www.red-gate.com/oracle-webinars
Views: 1819 Redgate Videos
63/125 Oracle PLSQL: Supplied  Packages / UTL_FILE  2
 
11:58
if you face issue remember to do this grant READ, WRITE on DIRECTORY MYDIR to public; تعلم اوراكل حتى الاحتراف Learn Oracle PLSQL EXAM 1Z0-144
Views: 530 khaled alkhudari
Submitting Concurrent Program through plsql package fnd_request in oracle apps( No Audio)
 
09:01
This is request set It can be used in interface programs.. To do interface programs.. we need to run 1) sql loader program 2) interface program But The requirement is Client wants to run A single program.. In that he need 1)sql loader program and 2)interface program so we need to add sql loader program inside interface program using fnd_request package Create or replace package xxtest as procedure main(errbuf out varchar2,retcode out number); end; / Create or replace Package body XXTEST as V_REQUEST_ID NUMBER; v_phase varchar2(100); v_status varchar2(100); v_dev_phase varchar2(100); v_dev_status varchar2(100); v_message varchar2(100); V_wait_for_request boolean; procedure main(errbuf out varchar2,retcode out number) as BEGIN fnd_global.apps_initialize(fnd_global.user_id ,fnd_global.resp_id ,fnd_global.resp_appl_id); mo_global.init('PO'); --=====================================================================-- --== Standard Program Submition ==-- --=====================================================================-- V_REQUEST_ID := FND_REQUEST.SUBMIT_REQUEST ( 'PO', 'XXKRAXML program',-- PROGRAM NAME null, '06-JAN-2015',-- YOU MAY USE SYSDATE FALSE ); FND_FILE.PUT_LINE(FND_FILE.LOG,'REQUEST ID.......'||V_REQUEST_ID); COMMIT; --=====================================================================-- --== Concurrent Program waiting ==-- --=====================================================================-- V_wait_for_request :=FND_CONCURRENT.wait_for_request(V_REQUEST_ID, 10, 0, v_phase, v_status, v_dev_phase, v_dev_status, v_message ); COMMIT; DBMS_OUTPUT.PUT_LINE('REQUEST ID.......'||V_REQUEST_ID); DBMS_OUTPUT.PUT_LINE('Phase.......'||v_phase); DBMS_OUTPUT.PUT_LINE('Status.......'||v_status); DBMS_OUTPUT.PUT_LINE('Dev Status.......'||v_dev_phase); DBMS_OUTPUT.PUT_LINE('Dev Status.......'||v_dev_status); DBMS_OUTPUT.PUT_LINE('Message.......'||v_message); END; end; /
Views: 4089 kranti kumar
How To Perform A Text Import With PL/SQL Developer
 
07:58
http://oracletuts.net/ Hey guys! I am TJ Abrahamsen, with OracleTuts. In this video I will show you how you can use PL/SQL Developer from Allround Automations to import a text file, in my case a .CSV file into a simple table. This tool can be used for many types of data imports into an Oracle table. I hope you find the little video helpful. ~ TJ
Views: 23924 oracletuts
Oracle Database Tutorial - SELECT Operators - DECODE, CASE, NVL, NVL2, SUM, COUNT etc
 
21:30
This video tutorial on Oracle database provides detailed information on various operators used in SELECT statements. You can visit Oracle Database related videos here : https://www.youtube.com/watch?v=cDqlT7O8H0Q&list=PLRt-r4QiDOMfMmVU-8145pLcBxIdvAt8f&index=1 Website: http://guru4technoworld.wix.com/technoguru Facebook : https://www.facebook.com/a2zoftech/ Blog: http://dronatechnoworld.blogspot.com
Views: 48 Sandip M
Export Oracle data to Excel file from Oracle Forms.
 
16:02
This is Oracle forms tutorial exporting data using for cursor loop to excel file invoking excel application with OLE2 forms built in package. OLE2 package contains all the stuff to invoke the property, procedures and function within an excel application. It creates the file, add workbook, add worksheet, put data to cells of worksheet and set properties like font size ,font color and font size of the cells. It saves the file as well. Source Code Link : https://drive.google.com/file/d/0BznrW3lgX0ozRktCMUlTaHZ0MzQ/view?usp=sharing
Views: 14547 Subhroneel Ganguly
Oracle Database Review (Real User: Kai Yu)
 
06:31
Read a text version of this review here: https://www.itcentralstation.com/product_reviews/oracle-database-review-37541-by-kai-yu This review was recorded by IT Central Station at Collaborate 2016. The review is not subject to editing or approval by the vendor. www.itcentralstation.com
Views: 400 IT Central Station
Importing Data from Excel into Oracle Database using SQL Developer 4.1
 
02:23
One of SQL Developer’s most popular features has undergone a significant upgrade. Users can quickly define and recall delimited or Excel files to be imported to a new or existing Oracle table. Data preview and validation is provided for each column, as well as ‘best guess’ data type and date format mask mapping. This process can now be automated via the SQL Developer command line interface (SDCLI) ‘Import’ command. NOTE: This is a video only. There is no audio. 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.
Solaris 11 Package Administration   - Part I
 
24:18
This screen-cast demonstrates the Image Packaging System (IPS) in Solaris 11. Upon watching this video, you'd learn how to perform basic package administration in Solaris 11 Operating System
Views: 5248 Rajesh Rajasekharan
SQL Server Integration Services - How to use Stored Procedure in OLE DB Source in SSIS Package
 
06:19
In this video we will learn the answer of SQL Server Integration Services(SSIS) Interview Question " Can we use Stored Procedure in OLE DB Source? If yes, how do you map the parameters?" How to use Stored Procedure in OLE DB Source in SSIS Package How to map parameters in OLE DB Source in SSIS Package How to pass value of variable to Stored Procedure parameter in OLE DB Source in Data Flow in SSIS Package To Follow Step by Step this SSIS video tutorial By Tech Brothers http://sqlage.blogspot.com/search/label/SSIS%20Video%20Tutorial
Views: 25914 TechBrothersIT
Query Analysis and Optimizing in Oracle
 
37:53
Database Management Systems 11. Query Analysis and Optimizing in Oracle ADUni
Views: 82780 Chao Xu
Difference between SQL Loader and UTL_File Package
 
03:52
This video tutorial will provide complete understanding of difference between SQL Loader and UTL_File package.
Views: 2043 amit wadbude
Creating and Managing Variables in Report Packages
 
05:37
This video demonstrates to report package owners and doclet authors how to create, edit, inspect, and delete variables in report packages in Oracle Enterprise Performance Reporting Cloud Service.
Apex ACP (Anychart Conversion Package)
 
01:58
This demo of the Apex ACP that shows a conversion of the standard Apex sample application application chart. It will show a multicolumn/serie query (standard for bar/line charts in Apex) and demonstrates different types of charts.
Views: 1235 Rutger de Ruiter
Spark Tutorial - Create | Package | Submit Spark Applications
 
13:28
We have been learning Spark examples using the REPL. Now it's time to show you a method for creating a standalone spark application. In this video, I will create a simple example and help you understand the process of creating Spark applications. We will also cover how to deploy your applications on a spark cluster. This video covers following. 1. Spark Application build tool 2. Understanding build.sbt for Spark application 3. Resolving external Spark dependencies 4. Developing and compiling Spark Application 5. Submitting a Spark Applications The source code used in this video is available at below website. ------------------------ https://www.learningjournal.guru/courses/spark/spark-foundation-training/how-to-create-and-submit-spark-applications/
Views: 2256 Learning Journal
Create Excel File Dynamically for Stored Procedure Results in SSIS Package by using Script Task-P165
 
17:09
SSIS Tutorial Scenario How to create Excel File Dynamically for Stored Procedure Results in SSIS Package by using Script Task You are working as ETL Developer / SSIS Developer and you need to create an SSIS Package that should execute Stored Procedure from SQL Server database and create an excel file for data returned by Stored Procedure. Let's assume that in in scenario, the Stored Procedure does not accept any parameters. Often Stored Procedures are created to run bunch of queries to generate final results and load that to Excel file. Your Stored Procedure might be using pivot and it can return different columns on each execution. Our SSIS Package should be able to handle this situation. It should always create an Excel file whatever columns are returned by Stored Procedure. The excel file should be generate with Datetime on each execution. Link to Script used in the video http://www.techbrothersit.com/2016/03/how-to-create-excel-file-dynamically_21.html Checkout other videos from TechBrothersIT for Dynamic Excel Source and Destination in SSIS Video playlist How to Load Data from Excel Files when Number of Columns can decrease or order is changed in Excel Sheet How to Load Only Matching Column Data to SQL Server Table from Multiple Excel Files (Single Sheet per file) Dynamically in SSIS Package How to Load Excel File Names with Sheet Names ,Row Count,Last Modified Date, File Size in SQL Server Table How to Load Multiple Excel Files with Multiple Sheets to Single SQL Server Table by using SSIS Package How to Load Matching Sheets from Excel to Table and Log Not Matching Sheets Information in SQL Server Table How to create Table for each sheet in Excel Files and load data to it dynamically in SSIS Package How to Create Table per Excel File and Load all Sheets Data Dynamically in SSIS Package by using Script Task How to create CSV file per Excel File and Load All Sheets from Excel File to it in SSIS Package How to Create CSV File for Each Excel Sheet from Excel Files in SSIS Package How to Load Excel File Name and Sheet Name with Data to SQL Server in SSIS Package How to Import data from Multiple Excel Sheets with a pattern of sheet names from Multiple Excel File in SSIS Package How to import Data from Excel Files for specific Sheet Name to SQL Server Table in SSIS Package Load Data To Tables according to Excel Sheet Names from Excel Files dynamically in SSIS Package How to Load Excel Files with Single/ Multiple Sheets to SQL Server Tables according to Excel File Name Dynamically How to Read Excel Sheet Data after Skipping Rows in SSIS Package by using Script Task How to read data from Excel Sheet and Load to Multiple Tables by using Script Task in SSIS Package How to create Excel File Dynamically from SQL server Table/View by using Script Task in SSIS Package How to create Excel File Dynamically for Stored Procedure Results in SSIS Package by using Script Task How to Export SQL Server Tables from Database to Excel File Dynamically in SSIS Package by using Script Task How to Convert CSV/Text Files to Excel Files in SSIS Package by using Script Task How to Load All CSV Files to Excel Sheets ( Sheet Per CSV) in single Excel File in SSIS Package How to Load All CSV Files to Single Excel Sheet with File Names in an Excel File Dynamically in SSIS Package How to Create Sample Excel file with Sheet from each table with Top 1000 Rows per sheet in SSIS Package How to Export Data to Multiple Excel Sheets from Single SQL Server Table in SSIS Package
Views: 5234 TechBrothersIT
72- Oracle PL SQL - Cursors - Implicit Cursors تعليم أوراكل
 
15:26
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج Database 2 - PL/SQL Cursors - Implicit Cursors in Arabic Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W
Build an Oracle Intelligent Bot in 5 Min
 
04:35
No coding required. With Oracle Intelligent Bots, you can build a context aware chatbot declaratively with a few simple clicks and minimal data examples to train your chatbot.
Views: 18881 Oracle
Solaris 11 text installation part 1
 
23:40
The installation is divided into 2 parts: -Part 1 covers the following: 1- Download Free download manager (FDM) or any equivalent software. 2- Downloading the necessary software from Oracle website. 3- Create the virtual machine on your VMware client. 4- Install Solaris 11 and enable telnet and ftp daemons. -Part 2 covers the following: 1- Allow ftp access for root user 2- Upload the 2 repository images to the server. 3- Use the cat command to produce the last usable image and delete the 2 old images. 4- mount the image we produced in the previous step. 5- Configure the repository. 6- install solaris-desktop package from the repository. Note:This Video covers only the first Part of the installation. The second part can be found on my YouTube channel.
Views: 7480 warthog Channel
Atom 12 Essential  Packages & Solution 2018
 
27:04
"Comment Us" What Next you want to Learn NEXT New way of Learning for beginner and for interview preparation and also if you want to quick return to the Code Overview. In this video I will start with a default Atom editor and add each of my favorite packages and plugins step by step so make Atom an overall better code editor. ATOM INSTALL: [ Complete Setup] PACKAGE LIST: -Emmet -File Icons -Live Server -Mini-Map -Pigments -Linter, linter-htmlhint, linter-CSSLint, linter-Jshint, linter-PHP -PHP Server [ Included Setup and PHP Solution] -Beautify [ Included Setup and Solution] -Ask Stack -Highlight Selected -Quick-query [ Database Connection] -File Differ [File Compare] -Double Tag [Edit both the start and end HTML tags at the same time.] ATOM for LARAVEL & Wordpress Code FEATURES Laragon - PHP -EMMIT SHORT CODE Link http://destyy.com/wfC9ey Visit: Facebook: https://fb.com/LearningClub.live website: https://learningclub.live
Views: 381 Learning Club
SSIS "Execute SQL Task" - stored procedure with input parameters
 
17:42
Demonstration of how to call a stored procedure to update a table with input parameters from a SSIS Execute SQL Task. Covers error handling of update failures. Examples cover OLE DB and ADO.NET.
Views: 8634 Steden Videos
0301-What are the Oracle SQL and PLSQL Tools
 
02:43
What are the Oracle SQL and PLSQL Tools
Views: 111 Akhlaq Ahmed
Solaris 11 Package Administration   - Part II
 
30:22
This screen-casts walks through the steps involved in setting up a Solaris 11 IPS repository on a Solaris 11 machine. Upon watching this video, you will know: - the download location of IPS repository files - the Korn shell script used to stich the repository files, mount it and copy it to a destination ZFS filesystem - property of pkg/server SMF Service that points to the filesystem location that has valid IPS packages - how to setup a Solaris 11 client to download packages from the local IPS repository
Views: 2710 Rajesh Rajasekharan
Informatica MDM User Exits Oracle PL SQL PACKAGE from Java | Informatica MDM java Package
 
05:48
Want to do Informatica MDM the right way in 2018? Then check out this insanely actionable Informatica MDM tutorial. (https://cloudfoundation.com/informatica-mdm-training/) In this video I'll explain Informatica MDM and User Exits Oracle PL SQL PACKAGE from Java You can always contact me on [email protected] Website: https://cloudfoundation.com/ Linkedin: https://www.linkedin.com/company/cloudfoundation/ Facebook: https://www.facebook.com/CloudFoundation-1005093483033181/ Twitter : https://twitter.com/cloudfoundtion Subscribe to my channel to get video updates. Hit the subscribe button. Thanks
Views: 213 Cloud Foundation
How to Concatenate String Values with Integer values in SQL Server - TSQL Tutorial
 
10:23
How to Concatenate String and Integer Values in SQL Server ( + Sign vs CONCAT ) - TSQL Tutorial Working with Databases is fun. On daily basis we save data into tables in different columns and often we need to write queries which involve concatenation of multiple columns of different datatypes to produce our final output. In below example we have saved some data into #Customer Table which has Street Address column as string and zip as INT. we want to produce Full Address by concatenating these columns. To concatenate we can use + sign but this works only with String values. So if we have any Integer value/s we have to convert them to String first. We can use Cast or Convert function to convert Integer value to string. Also if there is any Null value among which values we are concatenating , our output will be Null by using + sign. To take care of that part we can use either ISNULL() or Coalesce Function to replace NULL with blank value in SQL Server. In SQL Server 2012 and Later versions, CONCAT function was introduced. You can concatenate multiple values by using this function. Fun part of this function is you don't have to worry about Null outcome as it will Ignore Null values and also you don't have to worry about converting INT into strings, It will take care of that automatically. So if you are using new versions such as 2012 or later, start taking advantage of this function. Blog post link for the video with script http://sqlage.blogspot.com/2015/03/how-to-concatenate-string-and-integer.html
Views: 14709 TechBrothersIT
How to Install Java JDK on Windows 10 ( with JAVA_HOME )
 
08:56
In this video I am going to show you How to install Java JDK on Windows 10 ( with JAVA_HOME ). Java installer .msi file comes with JRE and JDK. Java JDK Installation for Microsoft Windows (64-bit). JDK stands for Java SE Development Kit. JRE stands for Java Runtime Environment. 1. Download Java Open your web browser Type URL: http://www.oracle.com/technetwork/java/javase/downloads/index.html to go to Oracle download page Click on button “ JDK download ” for Java SE update 4. This will lead you JDK download page http://www.oracle.com/technetwork/java/javase/downloads/jdk-7u4-downloads-1591156.html Accept oracle license agreement Find and click on the correct jdk download link right for your operating system to download Save the file to disk 2. Install Java Double click to run the download file Just follow the prompt in Installer window #Javatutorialforbeginners #Javatutorial #Javaprogramming #Javaprogrammingtutorial #Javabasicsforbeginners ----------------------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 -------------------Online Courses to learn---------------------------- 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
Views: 1095816 ProgrammingKnowledge
How To Install MySQL on Windows 10
 
24:18
In this post we will learn how to How To Install MySQL on Windows 10. The same procedure can be used for installing MySQL on Windows 8 / Windows 7. But first let's see What is MySQL . MySQL is a very popular, open source database. Officially pronounced “my Ess Que Ell” (not my sequel). Handles very large databases; very fast performance. Why are we using MySQL? Free (much cheaper than Oracle!) Each student can install MySQL locally. Easy to use Shell for creating tables, querying tables, etc.Easy to use with Java JDBC. While installing MySQL, it will prompt you to create a root password . At this stage please select a safe and secure password . Make sure you remember the password, to use it later.MySQL tutorial for beginners and professionals with examples on CRUD, insert statement, select statement, update statement, delete statement, use database, keys, joins etc. -------------------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
Views: 431738 ProgrammingKnowledge
SQLPLUS: LineSize & PageSize
 
03:49
In this tutorial, you'll learn how to set linesize and pagesize . PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 15458 radhikaravikumar
Dynamic sql table name variable
 
11:59
Text version of the video http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-table-name-variable.html Slides http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-table-name-variable_20.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 SQL Server Tutorial Videos https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB 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 discuss how to pass table name dynamically for stored procedure in sql server. This is one of the sql questions that is very commonly asked. I have a web page with a textbox. When I enter a table name in the textbox and when I click "Load Data" button, we want to retrieve data from that respective table and display it on the page. Copy the SQL Script to create the tables from my blog using the link below http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-table-name-variable.html Create the following stored procedure. Notice we are passing table name as a parameter to the stored prcoedure. In the body of the stored procedure we are concatenating strings to build our dynamic sql statement. In our previous videos we discussed that this open doors for SQL injection. Create procedure spDynamicTableName @TableName nvarchar(100) As Begin Declare @sql nvarchar(max) Set @sql = 'Select * from ' + @TableName Execute sp_executesql @sql End So the obvious question that comes to our mind is, why are we not creating parameterised sql statement instead. The answers is we can't. SQL Server does not allow table names and column names to be passed as parameters. Notice in the example below, we are creating a parameterised query with @TabName as a parameter. When we execute the following code, the procedure gets created successfully. Create procedure spDynamicTableName1 @TableName nvarchar(100) As Begin Declare @sql nvarchar(max) Set @sql = 'Select * from @TabName' Execute sp_executesql @sql, N'@TabName nvarchar(100)', @TabName = @TableName End But when we try to execute it we get an error - Must declare the table variable "@TabName" Execute spDynamicTableName1 N'Countries' Add a Web Page to the project that we have been working with in our previous video. Name it "DynamicTableName.aspx". Copy and paste the HTML from my blog using the link below http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-table-name-variable.html Copy and paste the code from my blog in the code-behind page http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-table-name-variable.html At this point, run the application and type the following text in the "Table Name" textbox and click "Load Data" button. Notice "SalesDB" database is dropped. Our application is prone to SQL injection as we have implemented dynamic sql in our stored procedure by concatenating strings instead of using parameters. Employees; Drop database SalesDB One way to prevent SQL injection in this case is by using SQL Server built-in function - QUOTENAME(). We will discuss QUOTENAME() function in detail in our next video. For now understand that by default, this function wraps that string that is passed to it in a pair of brackets. SELECT QUOTENAME('Employees') returns [Employees] Modify the stored procedure to use QUOTENAME() function as shown below. Alter procedure spDynamicTableName @TableName nvarchar(100) As Begin Declare @sql nvarchar(max) Set @sql = 'Select * from ' + QUOTENAME(@TableName) Execute sp_executesql @sql End At this point, type the following text in the "Table Name" textbox and click "Load Data" button. Notice you will see a message - Invalid object name 'Employees; Drop database SalesDB'. Also "SalesDB" database is not dropped. Employees; Drop database SalesDB The entire text in "Table Name" textbox is wrapped in a pair of brackets by the QUOTENAME function and is treated as table name. Since we do have a table with the specified name, we get the error - Invalid object name.
Views: 21191 kudvenkat
TCL save point | sql queries |oracle database 11g version 2 | by bhanu priya
 
05:42
SQL queries on oracle database 11g version 2
Views: 39 Education 4u

Olow emu plains newsletter formats
Human resources assistant cover letter example
Wolfe and associates application letters
Sample cover letters for employment gaps in resumes
Cover letter internship geophysics institute