Home
Search results “Oracle current open cursor count”
PL/SQL tutorial 74: PL/SQL Bulk Collect Clause with FETCH-INTO statement of an explicit cursor
 
09:49
RebellionRider.com presents a PL/SQL tutorial on how to use PL/SQL Bulk Collect with Fetch-Into statement of an explicit cursor in Oracle Database. Watch and learn how to enhance query performance with Bulk Collect in Oracle Database by Manish Sharma. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/bulk-collect-3 Previous Tutorial ► Introduction to Bulk Collect: https://youtu.be/HPVzFBluM_Q ► Explicit Cursor: https://youtu.be/3q7dW_d2KVc ► Simple Loop: https://youtu.be/AFx6QYcY1CU ► The script on GIT: https://github.com/RebellionRider/pl-sql-tut-74.git ------------------------------------------------------------------------- ►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 http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ For E-mail address please check the 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: 7518 Manish Sharma
Cursor Leak in Java - JDBC code.
 
08:22
This video explains about Cursor Leak in java jdbc code and how to fix it. The exception is known as ORA-01000 Maximum Open Cursors Exceeded exception || By || Krishna Nimmaraju
Views: 176 Krishna Nimmaraju
7.ORACLE WORLD- FLASHBACK TRANSACTION QUERY
 
14:43
Hi guys today we will learn how to perform flashback transaction query to find out the DDL that performed by users. #FLASHBACKTRANSACTIONQUERY Oracle database Unbeatable,Unbreakable Platform..
Views: 1364 Oracle World
PL/SQL tutorial 75: PL/SQL Bulk Collect with LIMIT clause in Oracle Database
 
07:37
RebellionRider.com presents the 4th tutorial in Bulk Collect series. Watch and learn how to use Bulk Collect with LIMIT clause to enhance the query performance in Oracle Database by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/bulk-collect-4 Previous Tutorial ► Bulk Collect with Explicit Cursor https://youtu.be/PSA8HigCcRs ------------------------------------------------------------------------- ►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 http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the 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: 6216 Manish Sharma
PL/SQL Tutorial | User Defined Exception | Pragma Exception_INIT in Oracle Database 11g
 
23:33
Learn in depth with example about creating user defined exception using Pragma Exception_INIT and Raise_application_error following handling of different types of system named and unnamed exception in details. How to handle exception in oracle database, How to handle user defined exception in oracle database, What is Pragma in Exception Handling, What is Pragma Exception_INIT in oracle, Types of exception available in oracle, How to use Raise_application_error in oracle, How to use custom exception in oracle, How to use pragma autonomous transaction, SQLERRM, SQLCODE, Raise_application_error, In Oracle PL/SQL, PRAGMA refers to a compiler directive or "hint" it is used to provide an instruction to the compiler. The 5 types of Pragma directives available in Oracle are listed below: * PRAGMA AUTONOMOUS_TRANSACTION * PRAGMA SERIALLY_REUSABLE * PRAGMA RESTRICT_REFRENCES * PRAGMA EXCEPTION_INIT * PRAGMA INLINE Details of System Exception: DUP_VAL_ON_INDEX ORA-00001 You tried to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique index. TIMEOUT_ON_RESOURCE ORA-00051 You were waiting for a resource and you timed out. TRANSACTION_BACKED_OUT ORA-00061 The remote portion of a transaction has rolled back. INVALID_CURSOR ORA-01001 You tried to reference a cursor that does not yet exist. This may have happened because you've executed a FETCH cursor or CLOSE cursor before OPENing the cursor. NOT_LOGGED_ON ORA-01012 You tried to execute a call to Oracle before logging in. LOGIN_DENIED ORA-01017 You tried to log into Oracle with an invalid username/password combination. NO_DATA_FOUND ORA-01403 You tried one of the following: You executed a SELECT INTO statement and no rows were returned. You referenced an uninitialized row in a table. You read past the end of file with the UTL_FILE package. TOO_MANY_ROWS ORA-01422 You tried to execute a SELECT INTO statement and more than one row was returned. ZERO_DIVIDE ORA-01476 You tried to divide a number by zero. INVALID_NUMBER ORA-01722 You tried to execute a SQL statement that tried to convert a string to a number, but it was unsuccessful. STORAGE_ERROR ORA-06500 You ran out of memory or memory was corrupted. PROGRAM_ERROR ORA-06501 This is a generic "Contact Oracle support" message because an internal problem was encountered. VALUE_ERROR ORA-06502 You tried to perform an operation and there was a error on a conversion, truncation, or invalid constraining of numeric or character data. CURSOR_ALREADY_OPEN ORA-06511 You tried to open a cursor that is already open. Linkedin: https://www.linkedin.com/in/aditya-kumar-roy-b3673368/ Facebook: https://www.facebook.com/SpecializeAutomation/
How To Open new line for text below, above cursor In Vi Or Vim Editor In Linux
 
01:46
How To Open new line for text below, above cursor In Vi Or Vim Editor In Linux A Step By Step Tutorial o, O Open new line for text below, above cursor
Views: 1434 Mayank Agarwal
Oracle Database11g tutorials 14 : How to CREATE TABLE using sql developer and command prompt
 
08:36
Oracle Database11g tutorials 14 How to Create table using command prompt and Create table using sql developer Blog Link http://bit.ly/1TkY4Oe Time Line 0:25 Introduction of Tables in Database 1:03 What is Create Table (Introduction of create table) 1:30 Syntax of Create Table 2:08 How to create table using Command Prompt 4:55 How to create table using SQL Developer Links for Oracle Database tutorials 4: database connectivity using SQL developer and command prompt http://youtu.be/wSqoXRlXDUU You can have indepth knowledge about SQL create table here http://www.rebellionrider.com/sql-create-table.html Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com Today in this oracle database tutorial we will see How to CREATE A TABLE. if we have to define a table in layman language then we can say that Tables are just a collection of Rows and Columns but In RDBMS tables are database objects which help in organizing data into ROWS and COLUMNS. We can also say that SQL tables are kind of data structure which are used by database for efficient storage of data. To create a table in our database we use SQL CREATE TABLE command. SQL CREATE TABLE is a type of DATA DEFINITION LANGUAGE also known as DDL. To Create a table in your schema you will require CREATE TABLE system privilege. In our future videos we will see what are system and object privileges and how to grant them to a user. Today for this video we will be using Sample schema HR which already has all the necessary privileges. Ohk Let's see the syntax. CREATE TABLE table name ( column name1 Data-Type(size), column name2 Data-Type(size), ..... ); CREATE TABLE is an oracle reserved word or say an Oracle key word whereas There are 3 different ways of creating a table in Oracle database. Creating a table using Command Line Interface (CLI) in Oracle database For demonstrating how to create table in oracle database using CLI, I'll be using Command prompt. Thats how we create table using command prompt. you can check your table structure by DESCRIBE command for that just write DESC and your table name. Like this Another way of creating a table is by using Graphic user interface (GUI) in Oracle database To demonstrate how to create table using GUI we will use SQL developer. Lets open our SQL developer I am connected to HR schema if you do not know how to create a connection to database using SQL developer please watch my oracle database tutorial 4 that explains database connectivity using SQL developer and command prompt. Link for this video is in the description below. So lets create a table. Creating a table using SQL developer is very easy we do not have to fire any query here. Let's start First of all right click on your connection in which you want to create a table and choose schema browser. This will open a separate schema browser pane or you can expend your connection by clicking this + sign and then right click on table and choose New Table. However I prefer working with schema browser so let's skip to schema browser pane here from the first drop-down list you can choose connection name and in the second drop down list you can choose what database objects you want to work with we want to create a table thus I'll choose table and then click this arrow here and choose option for new table Ok we have created a table wizard first of all give a unique name to your table and add some column as well. For this, click the green plus button. Now we already have a column so give it some name. Also choose a datatype from the list and specify any size you can check this not null column if in case you want to make this a mandatory column you can also specify default value and constraint If you want to make this column a primary key you can click here In my future video i'll show you what are these constraints and different ways of applying them on a column in a table. for this video we will concentrate on create table only so when you are done with all your columns click ok Thats your table You can double click on your table here and can see its structure. Thats it
Views: 169337 Manish Sharma
PART 3- oracle 10g form builder using text item property palette
 
05:32
text item property palette-lowest allowed value, highest allowed value, initial value, hint,back ground and fore color
Views: 18936 Dr. Girija Narasimhan
Oracle Identity Management 11gR2 PS3 (11.1.2.3) Installation Tutorial
 
53:18
In this tutorial I perform a complete installation and configuration of Oracle Identity Management 11gR2 PS3 (11.1.2.3) release. More information including a list of the commands used are available at http://CloudApprentice.com
Views: 5356 OracleIdentity
UTL_FILE Package in Oracle PL/SQL | Oracle SQL Tutorial | Mr.Murali
 
41:39
UTL_FILE Package in Oracle PL/SQL | Oracle SQL Tutorial | Mr.Murali PL/SQL Tutorial for beginners ►For Registration : https://goo.gl/r6kJbB ►Call: +91-8179191999 ► Visit Our Website: http://nareshit.in/ http://nareshit.com/ ► About NareshIT: "Naresh IT is the Best Software Training Institute for Hadoop, Salesforce, AWS, DevOps, Sprak, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in Hyderabad, Chennai and Vijayawada, India which provides online and classroom training classes" ►For Registration : https://goo.gl/r6kJbB ►Call: India- 8179191999, USA- 404-232-9879 Email: [email protected] ►Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5.Share Video's of each and every session. Check The Below Links: ►For Course Reg : https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Visit Our Website: http://nareshit.in/ http://nareshit.com/
Views: 5673 Naresh i Technologies
How To Install Oracle Database 12c on Windows 10 Professional 64 bit Manish Sharma
 
10:25
Learn how to properly install oracle database 12c on Windows 10 Professional/Home x64 Bit. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ ► Oracle 12c Tutorial Playlist [Video] https://www.youtube.com/playlist?list=PLL_LQvNX4xKzVcg_GoRzjeM_veo8CI15A Oracle 12 Tut Playlist [Blog] http://rebellionrider.com/Oracle-database-12c-tutorials.htm ------------------------------------------------------------------------- Download Oracle 12c from here http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-win64-download-2297732.html ------------------------------------------------------------------------- ►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/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at 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: 123321 Manish Sharma
PART-1 (Hello World)  Oracle PL SQL Training - Fast Track Series
 
10:02
Topic 1: Basic Syntax, Hello World Program And Program Units Basic Syntax: Declaration Executable Commands (Begin End) Exception Handling set serveroutput on; begin dbms_output.put_line('Hello World'); end; / DECLARE RADIOUS NUMBER := 7; PI NUMBER := 3.14; AREA NUMBER ; BEGIN AREA := PI * RADIOUS * RADIOUS ; DBMS_OUTPUT.PUT_LINE('AREA :' || AREA); END; / DECLARE A NUMBER := 0; B NUMBER := 5; C NUMBER; BEGIN C := B/A; DBMS_OUTPUT.PUT_LINE('C :' || C); END; / DECLARE A NUMBER := 0; B NUMBER := 5; C NUMBER; BEGIN C := B/A; DBMS_OUTPUT.PUT_LINE('C :' || C); EXCEPTION WHEN ZERO_DIVIDE THEN DBMS_OUTPUT.PUT_LINE('NUMBER CAN NOT BE DIVIDED BY ZERO'); END; / Program Units: • Anonymous Blocks • Functions • Procedures • Package and Package Body • Trigger • Type and Type Body
Views: 2590 Sanket Patel
Read from (SELECT) Database table - SQLite3 with Python 3 part 3
 
11:20
In the previous tutorials, we've covered creating a database and populating one, now we need to learn how to read from the database. Reading from a database is where the power of using something like SQLite over a flat file starts to make sense. While we can query the entire table, we can instead just query a single column, or even based on specific row values. Let's see what I mean sample code and text tutorial: https://pythonprogramming.net/sqlite-part-3-reading-database-python/ Playlist: https://www.youtube.com/playlist?list=PLQVvvaa0QuDezJh0sC5CqXLKZTSKU1YNo https://pythonprogramming.net https://twitter.com/sentdex https://www.facebook.com/pythonprogramming.net/ https://plus.google.com/+sentdex
Views: 76879 sentdex
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: 15514 radhikaravikumar
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.
Explore Data in Oracle Data Visualization
 
03:42
In Oracle Data Visualization Desktop or Oracle Analytics Cloud..... Create a new project. Add a visualization type, add a sort, create a marquee selection, keep a selection, swap data elements, change a visualization type, save the project, and view the story. ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll and http://docs.oracle.com Copyright © 2017 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Advanced Explicit Cursor
 
06:55
Write a cursor that uses parameters Determine when a FOR UPDATE clause in a cursor is required Determine when use the WHERE CURRENT OF clause Write a cursor that uses a subquery
Views: 80 ilham rusydi
Debugging sql server stored procedures
 
15:11
debugging in ssms debugging t-sql code t sql debug stored procedure sql server management studio debug stored procedure how to debug t sql debug in sql server management studio In this video we will discuss how to debug stored procedures in SQL Server. Setting up the Debugger in SSMS : If you have connected to SQL Server using (local) or . (period), and when you start the debugger you will get the following error Unable to start T-SQL Debugging. Could not connect to computer. To fix this error, use the computer name to connect to the SQL Server instead of using (local) or . For the examples in this video we will be using the following stored procedure. Create procedure spPrintEvenNumbers @Target int as Begin Declare @StartNumber int Set @StartNumber = 1 while(@StartNumber [ @Target) Begin If(@StartNumber%2 = 0) Begin Print @StartNumber End Set @StartNumber = @StartNumber + 1 End Print 'Finished printing even numbers till ' + RTRIM(@Target) End Connect to SQL Server using your computer name, and then execute the above code to create the stored procedure. At this point, open a New Query window. Copy and paste the following T-SQL code to execute the stored procedure. DECLARE @TargetNumber INT SET @TargetNumber = 10 EXECUTE spPrintEvenNumbers @TargetNumber Print 'Done' Starting the Debugger in SSMS : There are 2 ways to start the debugger 1. In SSMS, click on the Debug Menu and select Start Debugging 2. Use the keyboard shortcut ALT + F5 At this point you should have the debugger running. The line that is about to be executed is marked with an yellow arrow Step Over, Step into and Step Out in SSMS : You can find the keyboard shortcuts in the Debug menu in SSMS. Let us understand what Step Over, Step into and Step Out does when debugging the following piece of code 1. There is no difference when you STEP INTO (F11) or STEP OVER (F10) the code on LINE 2 2. On LINE 3, we are calling a Stored Procedure. On this statement if we press F10 (STEP OVER), it won't give us the opportunity to debug the stored procedure code. To be able to debug the stored procedure code you will have to STEP INTO it by pressing F11. 3. If the debugger is in the stored procedure, and you don't want to debug line by line with in that stored procedure, you can STEP OUT of it by pressing SHIFT + F11. When you do this, the debugger completes the execution of the stored procedure and waits on the next line in the main query, i.e on LINE 4 in this example. To stop debugging : There are 2 ways to stop debugging 1. In SSMS, click on the Debug Menu and select Stop Debugging 2. Use the keyboard shortcut SHIFT + F5 Show Next Statement shows the next statement that the debugger is about to execute. Run to Cursor command executes all the statements in a batch up to the current cursor position Locals Window in SSMS : Displays the current values of variables and parameters If you cannot see the locals window or if you have closed it and if you want to open it, you can do so using the following menu option. Locals window is only available if you are in DEBUG mode. Watch Window in SSMS : Just like Locals window, Watch window is used to watch the values of variables. You can add and remove variables from the watch window. To add a variable to the Watch Window, right click on the variable and select "Add Watch" option from the context menu. Call Stack Window in SSMS : Allows you to navigate up and down the call stack to see what values your application is storing at different levels. It's an invaluable tool for determining why your code is doing what it's doing. Immediate Window in SSMS : Very helpful during debugging to evaluate expressions, and print variable values. To clear immediate window type ]cls and press enter. Breakpoints in SSMS : There are 2 ways to set a breakpoint in SSMS. 1. By clicking on the grey margin on the left hand side in SSMS (to remove click again) 2. By pressing F9 (to remove press F9 again) Enable, Disable or Delete all breakpoints : There are 2 ways to Enable, Disable or Delete all breakpoints 1. From the Debug menu 2. From the Breakpoints window. To view Breakpoints window select Debug =] Windows =] Breakpoints or use the keyboard shortcut ALT + CTRL + B Conditional Breakpoint : Conditional Breakpoints are hit only when the specified condition is met. These are extremely useful when you have some kind of a loop and you want to break, only when the loop variable has a specific value (For example loop varible = 100). How to set a conditional break point in SSMS : 1. Right click on the Breakpoint and select Condition from the context menu 2. In the Breakpoint window specify the condition Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/debugging-sql-server-stored-procedures.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/debugging-sql-server-stored-procedures_28.html
Views: 99410 kudvenkat
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: 21282 kudvenkat
List all tables in a sql server database using a query  Part 65
 
05:38
Text version of the video http://csharp-video-tutorials.blogspot.com/2013/06/part-65-list-all-tables-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-65-list-all-tables-in-sql-server.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 In this video we will discuss, writing a transact sql query to list all the tables in a sql server database. This is a very common sql server interview question. Object explorer with in sql server management studio can be used to get the list of tables in a specific database. However, if we have to write a query to achieve the same, there are 3 system views that we can use. 1. SYSOBJECTS - Supported in SQL Server version 2000, 2005 & 2008 2. SYS.TABLES - Supported in SQL Server version 2005 & 2008 3. INFORMATION_SCHEMA.TABLES - Supported in SQL Server version 2005 & 2008 -- Gets the list of tables only Select * from SYSOBJECTS where XTYPE='U' -- Gets the list of tables only Select * from SYS.TABLES -- Gets the list of tables and views select * from INFORMATION_SCHEMA.TABLES To get the list of different object types (XTYPE) in a database Select Distinct XTYPE from SYSOBJECTS Executing the above query on my SAMPLE database returned the following values for XTYPE column from SYSOBJECTS IT - Internal table P - Stored procedure PK - PRIMARY KEY constraint S - System table SQ - Service queue U - User table V - View Please check the following MSDN link for all possible XTYPE column values and what they represent. http://msdn.microsoft.com/en-us/library/ms177596.aspx
Views: 86765 kudvenkat
PL/pgSQL con PostgreSQL 9.5 - Cursores (Cursors, Fetch, Open, Close) Práctica
 
05:00
Ejemplo: Práctica ejercicio con cursores. Todo esta basado en la documentación oficial que se encuentra para esta versión 9.5 . http://www.postgresql.org/docs/9.5/static/index.html
Views: 3391 SYSGAP
How to Install Kali Linux 2016 on VirtualBox
 
06:37
Guided installation of Kali Linux on Oracle's VirtualBox. VirtualBox installation, as well as, its extension packs required prior to following this video. Links: VirtualBox download & extension packs: https://www.virtualbox.org/wiki/Downloads Kali Linux 2016: https://www.kali.org/downloads/ Steps: 1) Once you have downloaded the .iso file, open VirtualBox and click "New". Then, enter a name for your machine, and make sure the type is Linux and version is Debian. -Note: You will not have x64 bit available without the extension packs downloaded. 2) Choose what memory size you want. Standard is 1024. 3) Create a virtual hard disk. -file type: VDI. -dynamically allocated. 4) Select the virtual hard disk size (must have the free space on your current HDD). 5) Click "Settings". Specs: A) General: -Basic tab: Set version to Debian. -Advanced tab: Set both settings to bidirectional. B) System: -Motherboard tab: Disable floppy (unless you have the drive). -Motherboard tab: Enable I/O APIC. -Processor tab: Change processor count to 2. -Enable PAE/NX. C) Display: -Screen tab: Maximize video memory. -Screen tab: Enable 3D acceleration. D) Storage: -Click the empty disk space, then select .iso file. E) Network: -Attached to NAT (or bridged). F) USB: -Enable USB controller, and select the USB type desired. -Note: You will get an error message if you have no downloaded VirtualBox extension packs. Steps Cont.: 7) Start the virtual machine. Once it boots, use arrow keys to navigate. Then, select "graphical install". 8) Select your language & location preferences. 9) Give a name for your host machine if desired (or leave unchanged). 10) Provide a domain name if desired (or leave blank). 11) Enter whatever password you want for admin (root) account. 12) Select time zone preference. 13) Partition disks: Guided - use entire disk. 14) Keep clicking continue. 15) When prompted to write changes to disk click "YES". 16) Wait for install. Select "yes" for any other prompts from now on (network mirror is optional). 17) Install GRUB boot loader to /dev/sda. 18) Wait. 19) ?? 20) Profit. Notes: -Look for my video on installing guest additions to have full screen VM. -Look for my video on updating Kali Linux repositories. Music: - Music provided by FreeSongsToUse - Author & Song: Miza & Drake - Oxygen. - To support music author please find their info at: https://youtu.be/izXaUGjDWsI
Views: 24998 Havoque Inc
How to fetch ALTERNATE records from a table  EVEN NUMBERED
 
01:10
How to fetch ALTERNATE records from a table EVEN NUMBERED
Views: 300 DWHBITesting tips
Access 2013 10 - Opening A Form To A Specific Record
 
04:54
File available here: http://www.accessallinone.com/access-2013-no-vba-downloads/ Please select: Access2013_DB_10 Topics covered: Where Condition OpenForm Macro
Views: 108265 Access All In One
Current Record Item on Forms in MINT
 
02:07
As a user of the FormBuilder I want the have a pointer to the Current Record Item, that is the one that opens the form.
Manage Oracle Cloud SFTP user accounts (13.2)
 
05:14
This video will show you how to manage an Oracle Cloud service SFTP user account password. SFTP user accounts are used to sign in to the SFTP server so you can upload and download files related to your Oracle Cloud service. Copyright © 2014 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.
DB2 Tips n Tricks Part 38 - Limitation on Monitor Metrics by Dynamic SQL Snapshot
 
12:15
How Dynamic SQL Snapshot is Technically Correct but Functionally Incorrect Solution: Dynamic SQL Snapshot aggregates monitor metrics based on Statement Text. Use MON_GET_PKG_CACHE_STMT aggregates monitor metrics based on Execution Id. Happy Learning & Sharing
Views: 1534 DB2-LUW-ACADEMY
ORACLE in Telugu What is Database Part 1(www.timecomputers.in)
 
02:19
ORACLE in Telugu -~-~~-~~~-~~-~- Please watch: "Best Useful software For Windows Telugu" https://www.youtube.com/watch?v=puGZTRTSoVA hafiztime hafiz telugu videos #telugutechtuts #hafiztime
Views: 72700 Telugu TechTuts
Linux Tutorial for Beginners: Introduction to Linux Operating System
 
02:29:05
http://www.guru99.com/unix-linux-tutorial.html Linux is the most popular server OS(Operating System). Linux is a clone of UNIX. Knowing one is as good as knowing the other. This tutorial is for absolute beginners. You will know how Linux works. You can learn Linux, by installing it right on your existing Windows or Mac OS systems! (Detailed steps to install Ubuntu given in tutorials). Click on the time points below to view different sections! 6:50 Most Popular Linux distros 8:37 Installing Linux – VirtualBox 18:05 Introduction to Linux operating system and comparison with windows 24:32 Terminal vs. File Manager 27:20 Command Line Interfaces on Ubuntu Operating system 49:19 Brief of Linux commands 52:04 Ownership in Linux Files (Permissions in Linux) 1:04:58 Print, Email & Install Software on Linux 1:25:34 Regular expressions In Linux/Ubuntu 1:30:46 Basic Environment Variables 1:35:56 Communication in Linux 1:37:21 FTP (File transfer protocol) 1:42:35 Types of Processes in Linux 1:54:07 VI Editor Tutorial 2:01:45 Shell Scripting In Linux 2:09:11 What is PERL Programming 2:13:58 Virtual Terminal 2:20:00 Unix Administration in Linux What is Linux? Linux is an operating system (kernel). It is distributed under an open source license. Its functionality list is quite like UNIX. Like, share and subscribe our channel for more videos. Enjoy our free tutorial on our YouTube channel and our website. Watch more videos on our YouTube channel at https://www.youtube.com/channel/UC19i1XD6k88KqHlET8atqFQ READ this as a book on Amazon by viewing at http://amzn.to/2gZGjbE (Linux) Visit our website for more! www.guru99.com FACEBOOK! Would you prefer to watch more about us? Like our page for more https://www.facebook.com/guru99com/ TWITTER! Tweet for us on Twitter with #guru99 and follow us on https://twitter.com/guru99com THANKS! We appreciate you reading this and hope you have a wonderful day! Sincerely, Guru99
Views: 242064 Guru99
See What's New with Cloud Spanner (Cloud Next '18)
 
38:32
Since launching, Cloud Spanner has taken the database world by storm. In this session, we discuss recent and upcoming advances and features to Cloud Spanner. Event schedule → http://g.co/next18 Watch more Infrastructure & Operations sessions here → http://bit.ly/2uEykpQ Next ‘18 All Sessions playlist → http://bit.ly/Allsessions Subscribe to the Google Cloud channel! → http://bit.ly/NextSub
Air Traffic Anomaly Detector - Numenta - Nupic
 
06:25
Submission for Numenta Challenge 2015 http://devpost.com/software/air-traffic-anomaly-detector Who has never suffer any flight’s delay? Could we use the causes of these issues to avoid bad flights? ATAD try to answer some of these questions. We believe that many flights are delayed by meteorological incidents, but there are others reasons of anomalies such as the plane or the airport or the route. We also are interested in known if a plane changes its typical flight path in order to detect possible security breach. This first stage was focused on analyzing flights between LA and NY, assessing the flight path and to detect abnormal movements in flight in relation to its geo-position and heading. We got two different features. 1) The first allows us to view the history of flights and find anomalous points detected by NUPIC 2) But we also, we want to detect if any current flight is having an anomaly, so we can inform the airline about this situation. To do this, we have created a map having real time data, it’ll notify the user if it find any anomaly. We know that there are thousands of flights above our heads everyday. One problem we noticed is that scalability for this kind of system is crutial. Because of this we built HTM-MOCLU. By definition HTM-MOCLU is short for Hierarchical Temporal Memory Models Cluster. Htm-Moclu provides a platform similar to HtmEngine for htm.java applications, and has the ability to scale horizontally using multiple servers. Then we built our app on top of Moclu, that way we can add hardware on demand to deal with tons of data for realtime flights. On the UI side we are using AngularJS that integrates with Lift 3 and Comet actors, a google maps angular implementation called angular-google-maps and D3 charts. The backend is built using 2 different web servers. One of them is used to connect to the models cluster, get and push new flights data coming from external sources also it saves results into MongoDB. The second web server is used to serve this data to the client. Both web servers can be scaled horizontally. A lot of value can be delivered by ATAD in a short-term future, such as: * Give the possibility to a person who is about to buy a ticket to select a flight not only based on costs and benefits but also for the possibility of having a fault, making the travel experience better. * Find which airports have more anomalies than others, in order to provide this information for later use by airlines or passagers. * Report on the number of anomalies by flight to assess their personal onboard. * Add weather information to understand it impact and to help plan situations where airports are closed to prevent early collapse secondary airport facilities like hotels. * Analyze routes and airports can enable airlines to enhance their routes management in order to reduce costs generated by anomalies. We believe this information is useful for all the stakeholders, but primarily for the passenger, who will receive a better travel experience. https://github.com/antidata/ATAD https://github.com/antidata/htm-moclu https://github.com/numenta/htm.java
Views: 721 Dev Mind
MS SQL   Command to show stored procedure definition
 
01:26
Simple example that shows how to display stored procedure code More: http://howtodomssqlcsharpexcelaccess.blogspot.ca/2014/10/ms-sql-command-to-show-code-of-stored.html
Views: 286 Vis Dotnet
What is ALATO? A Lightweight Administration Tool for Oracle Database
 
25:59
Webinar recorded Dec 22 2015 demonstrating the architecture and features of ALATO, an Oracle APEX-based DBA tool. Visit http://skillbuilders.com/alato for a free trial download and more information.
Views: 515 SkillBuilders
Get Rid of Black Blinking Cursor
 
01:45
Black blinking cursor fix it now in VBA. If this problem related to your system change its setting with control panel. In VBA when you are creating codes your cursor turns in black box because of hitting wrong key mistakenly but this problem is happening in all other program change cursor size with setting. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 42038 pc shastra
Use the My Account application to activate and monitor services
 
05:37
This video will show you how to activate and monitor Oracle Cloud services. Copyright © 2014 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.
Write Tiny Chunks of (Reusable) Code
 
17:48
Don't you hate spaghetti code? Loops that start on line 75 and end on line 243....uncommented, obscure algorithms that make you nervous just THINKING about trying to fix their bugs....we've all been there, we've all done it. But how do we STOP doing it? Steven explains in this video how to use one very wonderful technique - nested subprograms - to dramatically, radically improve code readability and banish spaghetti code from your application. ================================================== 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.
How to pass a text value from a Form to crystal reports?
 
05:58
In this video, i'd be demonstrating 'how you can pass a textbox value from a form to crystal reports?' using visual studio 2012 in C# language. Generally, we can easily pass the database values to the crystal reports by using datagridview but what if some values are not part of datagridview(i.e, labels, textbox or linktext)? I was in same dilemma when i need to pass a label. So, i've done some R&D and come up with this solution. Hope this helps who are needed the most! P.S- This is my first recorded video using just laptop microphone. Apologies if voice is not clear or background noise gets too much!
Views: 32541 Folded Hands
Java Embedded SQL from Informix to Oracle Migration Demo
 
07:47
The demo is showing an example of how SQLWays can convert Java Embedded SQL from Informix to Oracle database. http://www.ispirer.com/application-conversion/embedded_sql_database_api/dynamic-sql-jdbc-api-migration?click=Qj7lwdfZ5is&from=youtube
Views: 838 Ispirer Systems
Oracle APEX 5 Operacje na wielu pozycjach raportu
 
20:46
Przedstawiamy opis krok po kroku jak w Oracle APEX 5 utworzyć raport, a następnie tak go zmodyfikować, aby można było wybrać pozycje i wykonać na nich operacje. Wykorzystujemy tutaj dynamiczne itemy checkbox2, dynamiczne akcje javascript, procesy AJAX Call i kolekcje. Kod wykorzystany w filmie dostępny jest na naszym blogu: http://apex.dbe.pl/2017/10/operacje-na-wielu-pozycjach-raportu-w.html Nasza strona: http://www.dbe.pl
Views: 388 DBE
Excel Magic Trick 1335: Power Query We Couldn’t Refresh The Connection Data Source Not Found Error
 
01:43
Download File: http://people.highline.edu/mgirvin/excelisfun.htm In Power Query see how to use deal with the Refresh Error Message: We couldn’t refresh the connection. Here is the error message we got: [DataSource.NotFound] File or Folder: We couldn’t find the folder.
Views: 12045 ExcelIsFun
Java - JTable Mouse Clicked Event / Display The Row Columns Sum Using NetBeans [ with source code ]
 
09:17
Display The Selected Row Columns Sum JTable Mouse Clicked Event Using Java NetBeans Source Code: http://1bestcsharp.blogspot.com/2016/01/java-jtable-click-event-in-netbeans.html ------------------ Check out my Java Projects! -------------------- ▶ Inventory Management System - http://bit.ly/Java_Inventory ▶ Students Information System - http://bit.ly/JavaStudent_System ▶ Contacts Management System - http://bit.ly/Java_Contacts ▶ All My Programming Projects Here - http://bit.ly/2HrU8hK ▶ My Source Code Store Here - http://bit.ly/2OsC0TU -------------------------- JAVA COURSE ----------------------------- ▶ master Java core development step-by-step - http://bit.ly/2HXSuAn -------------------------------------------------------------------- C# And Java Programming Projects With Source Code: http://1bestcsharp.blogspot.com/p/programming-projects.html visit our blog https://1bestcsharp.blogspot.com/ facebook: https://www.facebook.com/1BestCsharp twitter: https://www.twitter.com/1BestCsharp_ subscribe: http://goo.gl/nRjPKk In this java Tutorial we will see How To Use A JTable Mouse Clicked In Java Using NetBeans To Display The Selected Row Columns Sum and display it in JOptionPane JAVA Tutorials: Insert Update Delete Data In MySQL Database Using Java https://www.youtube.com/watch?v=uKEgKETRCzE Add And Update A Row To JTable From JTextField + Delete Row In Java https://www.youtube.com/watch?v=22MBsRYuM4Q JAVA MySQL Database Rocords Navigation Buttons https://www.youtube.com/watch?v=WkPWPuGHTTI Search Values From MySQL Database And Set It Into JTextfield In Java https://www.youtube.com/watch?v=uuhEb0k3vVE bind jtable from mysql database in netbeans https://www.youtube.com/watch?v=G4JeKZ6nDUI Bind a JCombobox With Database Values In Java NetBeans https://www.youtube.com/watch?v=23-90p2xceg insert Image in MySQL Database using Java https://www.youtube.com/watch?v=UusZGBkV6HI Drag And Drop Image In Netbeans https://www.youtube.com/watch?v=bD3X_-QeLKc Java Graphics Tutorial Draw Chess Board https://www.youtube.com/watch?v=no4m-TIX-rc Java Login Form With MySQL Database Part 1 : https://www.youtube.com/watch?v=7sNYhlBz9xo Part 2 : https://www.youtube.com/watch?v=meGhTnlS9k4 Image Slideshow In netbeans https://www.youtube.com/watch?v=pN1uoJD_uSE Retrieve And Display Image From Mysql In Java https://www.youtube.com/watch?v=7QEgJnnEmnE Export JTable Data To Text File In NetBeans https://www.youtube.com/watch?v=tg7M9YvYDqo How To Bind JTable From MySQL Using ArrayList In NetBeans https://www.youtube.com/watch?v=2d4i6BXQPFA How To Browse Image To Jlabel Using JFilechooser In NetBeans https://www.youtube.com/watch?v=VHd29F_Tk04 How To display Image From Database To JTable In Java https://www.youtube.com/watch?v=-ekqLViEvHg How To Get JTable Column Sum, Avarage, Max, Min Value In Java https://www.youtube.com/watch?v=ZCfk6S2BksA How To Set A Timer In NetBeans https://www.youtube.com/watch?v=Vu31hcNuSXo Drag And Drop Text In Netbeans https://www.youtube.com/watch?v=CQpiplV3fXg Populate JTable Depending On a JCombobox Value Using NetBeans https://www.youtube.com/watch?v=9NO0AHxvgio How To Connect Java To MySQL Database And Display Data Using NetBeans https://www.youtube.com/watch?v=zM7oe2_S-jY Display Image From JTable To JLabel In Java https://www.youtube.com/watch?v=nHCCubgd74s How To Filter Data From MySQL And Show It In JTable https://www.youtube.com/watch?v=TfuC_bxwr3w https://www.youtube.com/watch?v=i9_Kx_79RWo Populate a HashMap From MySQL DataBase https://www.youtube.com/watch?v=WAIcC3pl94o Import A Text From Tex File To A JTextPane https://www.youtube.com/watch?v=QWKkE1wbiAQ How To Use Stored Procedure In Java And MySQL https://www.youtube.com/watch?v=pux1p52ZaQw Populate JCombobox From MySQL With Key And Value https://www.youtube.com/watch?v=gheAMX-MGN8 Populate JCombobox Depending On Another JCombobox https://www.youtube.com/watch?v=O_aSNfGSD20 How To Sort JTable Data https://www.youtube.com/watch?v=trWVSIq-6Mo Add And clear All JTexfields Using Table https://www.youtube.com/watch?v=-zTvjp84sk4 jtable click https://www.youtube.com/watch?v=91Rp2MA0i94 jtable click and show image https://www.youtube.com/watch?v=Dg6aHH-35SU show jtable row data in another jframe https://www.youtube.com/watch?v=9Ot-cWh0Rhw images navigation from a folder https://www.youtube.com/watch?v=OTTIsOSzSts JTable display selected rows to another jtabel https://www.youtube.com/watch?v=R_ybbxZLS3c Populate A Jtable With A List Of Files Names From Resource Folder https://www.youtube.com/watch?v=ODZAhWZitlk image and data navigation from mysql https://www.youtube.com/watch?v=2NIHOMvlTRY https://www.youtube.com/watch?v=JEcO4p_1_7c insert update delete and display data in jtable https://www.youtube.com/watch?v=QKsfHqu4Pps https://www.youtube.com/watch?v=WIMojkwMTa0
Views: 32610 1BestCsharp blog
Oracle Clinical / Remote Data Capture (RDC) 4.6 Features
 
01:01:01
Learn about several features in Oracle Clinical and Remote Data Capture (RDC).-- Implementation of Oracle Clinical (OC) and Remote Data Capture (RDC) 4.6 provides life sciences organizations with more options for designing clinical trials. This most recent version of OC/RDC offers features that support adaptive trials and provide ease of use for the end user, while better securing a sponsor's data. Join BioPharm Systems' Principal Consultant, Mari Clovis, for this one-hour session to learn about these new features and other updates: -Defining conditional logic within forms -Using flexible study options for adaptive trials -Restricting access to selected forms -Hiding and preventing updates to queries based on user roles -Miscellaneous updates To view this webinar in its entirety, please visit: http://www.biopharm.com or https://cc.readytalk.com/r/5t2q59ufjbpx. Twitter: http://www.twitter.com/BioPharmSystems Facebook: http://www.facebook.com/BioPharmSystems LinkedIn: http://www.linkedin.com/companies/biopharm-systems-inc
Views: 3831 BioPharmSystems
UiPath Studio - Introduction to Desktop Automation
 
06:34
In this video, I will introduce you to desktop automation. We'll be using the UiPath record feature to capture the action in our computer screen. In this example, I will be using Windows calculator app but of course this is also applicable to any software installed in your machine. To find out more about UiPath or to request a free trial, please contact us: http://www.uipath.com/contact-us.
Views: 94263 UiPath
Spinosaurus fishes for prey | Planet Dinosaur | BBC
 
04:04
New David Attenborough series Dynasties coming soon! Watch the first trailer here: https://www.youtube.com/watch?v=JWI1eCbksdE --~-- Check out BBC Earth on BBC online - http://www.bbc.com/earth/world John Hurts tells the stories of the biggest, deadliest and weirdest Dinosaurs ever to walk the Earth. Massive carnivorous hunter Spinosaurus hunts the giant fresh water fish Onchopristis. Planet Dinosaur tells the stories of the biggest, deadliest and weirdest creatures ever to walk the Earth, using the latest fossil evidence and immersive computer graphics. Narrated by John Hurt. Visit http://www.bbcearth.com for all the latest animal news and wildlife videos BBC Earth Facebook http://www.facebook.com/bbcearth (ex-UK only) BBC Earth Twitter http://www.twitter.com/bbcearth Subscribe to BBC Earth: http://bit.ly/ydxvrP BBC Earth Channel: http://www.youtube.com/BBCEarth Latest BBC Earth videos: http://bit.ly/y1wtbi
Views: 14206912 BBC Earth
Excel 2013 Data Analytics Webinar: How to Structure and Analyze large data with Power BI tools
 
01:02:47
In this 1 hour Webinar, Dr. Nitin Paranjape (Office MVP) will show you how to structure and analyze large amount of data in just a few seconds using Excel 2013's Power BI features: Pivot Table, Power Pivot, Power Query and Power View. Topics covered: - Purpose of data analysis (2:30) - Data Analysis process (4:06) - Good data vs Bad data (5:34) - Rules for Good data (9:05) - Common Examples of badly formatted data (10:41) - How to handle cross-tab data with Power Query (14:44) - Gather data from the web with (18:57) - Power Query's Data Catalogue Search (20:00) - Split Column by Delimiter (20:05) - Refresh live data in Power Query (23:20) - Summarize Data in Pivot Tables (24:26) - Do Calculation right inside Pivot Tables with Calculated Fields (27:33) - Avoid Wrong calculations with Get Pivot Data (29:10) - Data Visualization with Conditional Formatting & Quick Analysis (31:12) - Limitations of Pivot Table (34:38) - Why use Power Pivot (35:19) - Analyze 43 million rows of data within Power Pivot (36:40) - Build interactive dashboards with Power View (41:42) - Share Power View reports on Sharepoint (47:15) - Manage viewing rights with Excel's Browser View option - Create 3D map reports in Power Map (49:38) - Power BI Preview (55:20) - Summary: Which tool to use in which scenario? (59:03) - Notes to Developers (59:17) This is a recording of the Data Analytics Webinar for Microsoft, powered by Economic Times. The webinar was conducted by Dr. Nitin Paranjape, Office MVP and Microsoft Regional Director.
Views: 13125 Efficiency 365
RHCSA 7 LAB Station Execution [RHCSA Exam Tasks] (2 of 2 videos)
 
52:37
This video provides step-by-step instructions on how to execute mock RHCSA exam tasks on a Linux system. An RHCSA/RHCE/LFCS/LFCE essential. [Website: http://www.nixeducation.com] [LinkedIn: https://www.linkedin.com/in/asghar-ghori-0315632]
Views: 19674 NixEducation
Java User Login System - 2 - User Verification
 
13:03
Please Rate, Comment and Subscribe.
Views: 111063 Naveed Ziarab

Investment banking cover letter sample analyst interview
What the best essay writing service
The tell tale heart annotated bibliography
Annotated bibliography example mla format 2010 dodge
Cover letter for pharmacy intern position