Home
Search results “Current of statement in oracle” for the 2014
oracle date and time functions
 
21:33
Video from our Oracle SQL course. Check out the full course at.. http://learn.hackpress.co/courses/oracle-sql-learning-by-example
Views: 45155 etldeveloper
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: 179448 Manish Sharma
Oracle Database tutorials 4:  database connectivity using SQL developer and command prompt
 
09:19
Blog Link: http://bit.ly/how-to-create-new-connection-in-sql-developer Wishlist: http://bit.ly/wishlist-amazon This SQL tutorial and Oracle database 11g tutorial for beginners will show how to connect to database either on a local machine or on a machine in your LAN using ip address. Tool used in this tutorial is SQL developer & 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 Email [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/RebellionRider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos The Code makers
Views: 279075 Manish Sharma
Oracle Architecture
 
04:11
This video describes the best architecture of the oracle after trying more than times to Oracle structure I decided to produce an animated video let's start first with the database structure on the left side you have the client here on the right side you have to serve a two-year the server side is divided in three main structures to memory the logical structure and the physical structure so let's use SQL Plus application to provide you every step up a transaction will be using Scott sample schema it is important to note that the whole string is an alias and not a database name district will be compared to this alias inside of a file called pianist named doc or this file is similar to a DNS and with up pain all the necessary detail to reach a database server locally a user process will be allocated and will validate the connection through a listener the listener will be in charge to allocate a server process the user processes da link to the server process let's now execute our first transaction for this example we will execute an update first to state that will be validated we call this step the parsing this server process sense back to confirmation of the parsing that statement with be written into their share pool and the redo log buffer an execution plan will also be created it to the fair share Paul that database book they choose fought the transaction will be read and copy into the database buffer cache only that feel implicated in that transaction will be held it to a - segment till the transaction is completed we call those copies the before image a copy of this block will be duplicated with the updated feel this copy is called me after image a confirmation will be sent to to use a process the commit statement will complete the transaction and will be written into to redo log buffer to commit statement triggers the log writer process and we'll send all statement for the current transaction into the redo log file the before image into undo segment could be then deleted went that threshold up to undo retention parameters reach alaskan from Asian will be sent to the user process went to current law kiss Paul it generates a switch lock triggering at the same time the archiver process and to log sequence number the archiver will generate and archive the file with the content of the current loc a switch up with them trigger a checkpoint process that will incriminate the checkpoint number by applying this last number into each data file header the checkpoint process with finally trigger the database writer process enright the last image from that database buffer cache into thirty people
Views: 20613 Ezylearning
Part 5   SQL query to find employees hired in last n months
 
04:53
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-5-sql-query-to-find-employees.html This question is asked is many sql server interviews. If you have used DATEDIFF() sql server function then you already know the answer. -- Replace N with number of months Select * FROM Employees Where DATEDIFF(MONTH, HireDate, GETDATE()) Between 1 and N
Views: 173463 kudvenkat
ADD DATE COLUMN DATATYPE, INSERT DATE VALUES in Oracle SQL
 
03:48
Oracle SQL tutorials, How to add date datatype, insert date datatype values
Real Time SQL Monitorin Demo in Oracle SQL Developer
 
03:42
See how to watch a query execute in real time using this Oracle Database Tuning Pack feature in Oracle SQL Developer.
Views: 24925 Jeff Smith
Accounts Payable vs. Accrued Expenses - Interview Question
 
12:44
Accounts Payable vs. Accrued Expenses on the 3 Financial Statements: Why Does It Matter? By http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" It's a common interview question! You may be asked about the differences between them, how changes are reflected on the 3 financial statements, and so on. And most Google search results on this topic are AWFUL and do not answer the actual question at all, or do so in a confusing way that misses the point (trust me, I looked). THE SHORT ANSWER: Accounts Payable (AP) and Accrued Expenses (AE) work in a VERY similar way... IF they both correspond to Operating Expense line items, or other items that appear directly on the Income Statement. However, AP is more likely to correspond to events such as the purchase of Inventory, which would NOT show up on the Income Statement initially, and so you're more likely to see different treatment with Accounts Payable (no Income Statement impact - just an Asset on the Balance Sheet increasing and AP on the Liabilities & Equity side increasing to balance the change). Both these items represent cases where we've INCURRED an expense but not actually paid for it in cash yet. Example 1: We get an invoice for a legal bill from a law firm we hired. They already performed the service, so we incurred the expense, but we haven't paid them in cash yet. Example 2: We pay rent at the beginning of each month. In between, that expense accrues because we use the building or office every day of the month... so it's not accurate just to view it as an expense on one day of the month, but rather an expense that gets accrued every single day and then paid in cash at the beginning of the month. Example 1 corresponds to Accounts Payable, because we typically use AP for items with specific invoices. Example 2 corresponds to Accrued Expenses, which we typically use for recurring, monthly/quarterly/weekly items WITHOUT specific invoices, such as rent, utilities, employees' wages, and so on. What Happens on the 3 Statements When AP or AE Change? IF they both correspond to COGS or Operating Expenses IN THE CURRENT PERIOD and therefore refer to actual expenses listed on the Income Statement: Let's use the example of AP or AE of $100 on the 3 statements: 1) Income Statement - Expenses (most likely OpEx) will increase by $100, reducing Pre-Tax Income by $100 and Net Income by $60 assuming a 40% tax rate. 2) Cash Flow Statement - Net Income is down by $60, but this expense we just recognized was non-cash, so we record the increase in AP or AE as a cash increase of $100. Our cash flow and ending cash at the bottom are up by $40. 3) Balance Sheet - Cash is up by $40 on the Assets side; on the L&E side, AP or AE is up by $100, but Retained Earnings is down by $60 due to the reduced Net Income, so both sides are up by $40. INTUITION: You've saved on taxes because you recorded an expense, took the tax deduction, and reduced your tax bill... but you haven't paid that expense in cash yet! It's all about the tax savings in this first step. Now, Step 2: What Happens When You Pay the AP or AE in Cash, For Real 1) No changes on the Income Statement - already recognized this as an expense! 2) Cash Flow Statement: Net Income is still down by $60... and now we REMOVE that adjusting entry for AP or AE, so cash no longer goes up by $100 from that. As a result, cash at the bottom is just down by $60. 3) Balance Sheet: Cash is now down by $60 rather than being up by $40, because we just paid that expense in cash. On the other side, AP or AE is now back to its old level and is no longer up by $100. Retained Earnings is still down by $60, so both sides are down by $60 and balance. BUT HERE'S THE IMPORTANT DIFFERENCE BETWEEN THEM: AE almost always correspond to Operating Expenses or other Income Statement expense items... but Accounts Payable often do not. EXAMPLE: Company buys $100 of Inventory on credit - supplier sends over the Inventory, "in good faith," and sends the company an invoice, which goes to its Accounts Payable account. In this case, there are NO CHANGES on the Income Statement because nothing happens there until this Inventory is turned into products and sold to customers! Instead, Inventory on the BS simply goes up by $100, and AP on the other side goes up by $100 to balance it. That scenario happens a lot with AP, but very-rarely-to-never with AE. Further Resources http://breakingintowallstreet.com/biws/3-statement-excel-model-interview-questions/
part3 drop,nextval,currval sequence
 
01:46
create sequence, next value, current value, drop sequence, sql, oracle 10g,drop sequence
Views: 1065 Dr. Girija Narasimhan
Financial reporting tutorial: What is a financial statement? | lynda.com
 
02:59
A wealth of information is available to you if you know how to read financial statements, but what exactly is a financial statement? In this tutorial, Rudolph Rosenberg explains the four types of financial statements in depth. Watch more at http://www.lynda.com/Business-Finance-tutorials/Financial-Literacy-Reading-Financial-Reports/135826-2.html?utm_campaign=8G832H-BPEA&utm_medium=viral&utm_source=youtube. This tutorial is a single movie from the Financial Literacy: Reading Financial Reports course presented by lynda.com author Rudolph Rosenberg. The complete course is 1 hour and 25 minutes and shows how to read income statements, cash flow statements, and balance sheets and assess the financial health of your business and your competition. Introduction 1. Financial Statements 2. The Balance Sheet 3. The Income Statement 4. The Cash Flow Statement Conclusion
Views: 8293 LinkedIn Learning
Part 8   SQL Query to find department with highest number of employees
 
04:03
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/06/part-8-sql-query-to-find-department.html Scenario asked in the SQL Server Interview Based on the above two tables write a SQL Query to get the name of the Department that has got the maximum number of Employees. To answer this question it will be helpful if you the knowledge of JOINS & GROUP BY in SQL Server. We discusses these in Parts 11 & 12 of SQL Server Tutorial video series. SQL query that retrieves the department name with maximum number of employees SELECT TOP 1 DepartmentName FROM Employees JOIN Departments ON Employees.DepartmentID = Departments.DepartmentID GROUP BY DepartmentName ORDER BY COUNT(*) DESC Scenario asked in the SQL Server Interview Based on the above two tables write a SQL Query to get the name of the Department that has got the maximum number of Employees. To answer this question it will be helpful if you the knowledge of JOINS & GROUP BY in SQL Server. We discusses these in Parts 11 & 12 of SQL Server Tutorial video series. SQL query that retrieves the department name with maximum number of employees SELECT TOP 1 DepartmentName FROM Employees JOIN Departments ON Employees.DepartmentID = Departments.DepartmentID GROUP BY DepartmentName ORDER BY COUNT(*) DESC
Views: 121542 kudvenkat
US GAAP vs. IFRS on the Financial Statements
 
21:58
You'll learn the key differences between US GAAP and IFRS on the 3 main financial statements (Income Statement, Balance Sheet, and Cash Flow Statement). By http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" You'll also learn how to adjust an international company's financial statements to make it easier to model and project over time. Table of Contents: 1:46 Why US GAAP vs. IFRS Matters 5:28 Income Statement Terminology Differences 7:34 Balance Sheet Differences 14:09 How to Adjust the Financial Statements for an IFRS Company 20:02 Recap and Summary Income Statement: The Income Statement is very similar regardless of the accounting system. Some items have different names (e.g., Revenue is often called Turnover and Net Income is often called Profit), but that's about it. Balance Sheet: There are more differences on the Balance Sheet - items are often arranged in a different order (sometimes Long-Term Assets are listed first, then Current Assets, then Equity, then Long-Term Liabilities and Current Liabilities at the end). The Balance Sheet itself is usually called the "Statement of Financial Position." Also, items within the Equity section often have different names: Common Stock is called "Share Capital" or "Issued Capital." Additional Paid-In Capital is often called the "Share Premium." Retained Earnings and Treasury Stock tend to have similar names. IFRS-based companies also have many "Reserve" categories for items such as FX translation differences and unrealized gains and losses. For US-based companies, these items show up within Accumulated Other Comprehensive Income (AOIC) rather than being split out into separate "Reserve" categories. But the FUNCTIONALITY of the Balance Sheet is still very similar (items still flow in and change the same way), even if items have different names or are grouped differently. Cash Flow Statement There are more differences on the Cash Flow Statement, because most US-based companies use the INDIRECT method and most international companies use the DIRECT method. The Indirect Method starts with Net Income, makes non-cash adjustments, and lists the changes in Working Capital in the Cash Flow from Operations section. The Direct Method simply lists the cash received from customers and cash paid to suppliers and employees, along with income taxes and interest and other expenses, and so you don't see the full details behind the non-cash adjustments and working capital spending. When this happens, it is much, much harder to link the financial statements because changes in items such as Accounts Receivable and Accounts Payable won't flow into anything on the Cash Flow Statement. So we recommend ADJUSTING the financial statements as follows: First, find a reconciliation between this Cash Flow Statement and the company's operating income and/or net income. Then, make the Cash Flow Statement start with Net Income instead, as it normally does, and include all the line items from this reconciliation (non-cash adjustments, Working Capital changes, etc.). And if there are still remaining differences between items such as income taxes and interest expense on the Income Statement vs. Cash Flow Statement, make adjusting entries on the CFS that indicate the true cash amount that a company paid for those. Further Resources http://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-09-US-GAAP-vs-IFRS.xlsx Examples of Financial Statements for US-Based Companies: http://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-09-US-Chuck-E-Cheese.pdf http://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-09-US-Jazz-Pharmaceuticals.pdf Examples of Financial Statements for International Companies: http://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-09-Australia-Telstra.pdf http://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-09-Brazil-Ambev.pdf http://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-09-China-TenCent.pdf http://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-09-France-Vivendi.pdf http://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-09-India-Infosys.pdf http://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-09-Japan-Suntory.pdf http://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-09-Korea-Samsung.pdf http://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-09-Mexico-FEMSA.pdf http://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-09-Russia-Rostelecom.pdf http://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-09-Saudi-Arabia-Saudi-Telecom.pdf http://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-09-Singapore-SG-Airlines.pdf http://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-09-South-Africa-PPC.pdf http://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-09-UAE-DP-World.pdf http://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-09-UK-Easyjet.pdf
How to call Oracle Reports run-time from Oracle Forms using Runproduct.
 
16:29
This training video shows how to call Oracle Reports run-time from Oracle Forms 6i using runproduct functions.
Views: 25732 Subhroneel Ganguly
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
Update queries - simple stock level in access
 
06:05
This video will show you how to create an update query in access.
Views: 25157 computingmrh
Reporting in Fusion OTBI on the previous 12 months and setup default report date parameters
 
04:20
Short video showing how to report in Oracle Fusion OTBI using OBIEE to report on the previous 12 months. The video goes on to show how to report between two parameterised dates and how to set the parameter dates to useful defaults. 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.
Part 4   Delete duplicate rows in sql
 
03:26
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-4-delete-duplicate-rows-in-sql.html In this video, we will discuss deleting all duplicate rows except one from a sql server table. SQL Script to create Employees table Create table Employees ( ID int, FirstName nvarchar(50), LastName nvarchar(50), Gender nvarchar(50), Salary int ) GO Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (2, 'Mary', 'Lambeth', 'Female', 30000) Insert into Employees values (2, 'Mary', 'Lambeth', 'Female', 30000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) The delete query should delete all duplicate rows except one. Here is the SQL query that does the job. PARTITION BY divides the query result set into partitions. WITH EmployeesCTE AS ( SELECT *, ROW_NUMBER()OVER(PARTITION BY ID ORDER BY ID) AS RowNumber FROM Employees ) DELETE FROM EmployeesCTE WHERE RowNumber ] 1
Views: 339932 kudvenkat
How to calculate date,year,moth,week from date in sql server  -Sql Server
 
02:11
How to calculate date,year,moth,week from date -Sql Server
Views: 2359 GoPro
SQL tutorial 36: how to create database using database configuration assistant DBCA
 
12:11
Step by step process of creating oracle database using DBCA database configuration assistant, how to unlock user account of sample schema WATCH FULL VIDEO TO KNOW HOW TO UNLOCK HR SCHEMA Tutorial Consist: How to create general purpose transaction database using DBCA database configuration assistant in Oracle 11g, Links How to create database detail blog: http://bit.ly/how-to-create-database-using-dbca What is archiving and archivelog mode: http://bit.ly/what-is-archiving-in-oracle-database Video Tutorial 1 How to install oracle 11g database http://youtu.be/0NLsJQCvKXY Video tutorial http://youtu.be/-13SbeDavwk Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 Amazon Wishlist: http://bit.ly/wishlist-amazon 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 liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Views: 61664 Manish Sharma
Oracle Database 12c: Improved Defaults
 
05:59
Tom Kyte and Chuck Murray describe several improvements to default behavior in Oracle Database 12c: defaults based on sequences, default on NULL, Identity type columns, and metadata-only defaults. For more information: "CREATE TABLE" statement in Oracle® Database SQL Language Reference http://www.oracle.com/pls/topic/lookup?ctx=db121&id=SQLRF01402 "ALTER TABLE" statement in Oracle® Database SQL Language Reference http://www.oracle.com/pls/topic/lookup?ctx=db121&id=SQLRF01001 "Identity Columns" in Oracle® Database Migration Guide http://www.oracle.com/pls/topic/lookup?ctx=db121&id=DRDAA109
Views: 2173 OracleDBVision
SQL Complete Tutorial - ADD or SUBSTRACT or MULTIPLY between two columns - Chapter 6
 
03:47
In this video, I have explained how to add_subtract_multiply the two columns from the particular table. Comment - Follow - Like : https://www.facebook.com/TechyVickyBlog https://www.twitter.com/techyvicky https://www.pinterest.com/techyvicky/techy-vicky-blog https://plus.google.com/109896475845510580320/
Views: 34345 Vicky's Blog
Part 1   How to retrieve data from different databases in asp net
 
11:43
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-1-how-to-retrieve-data-from.html Several of our youtube channel subscribers faced this question in a dot net written test. We have 2 databases 1. USADB - Contains Employees table that stores only US Employees 2. UKDB - Contains Employees table that stores only UK Employees Implement an asp.net web page that retrieves data from the Employees table both from USADB and UKDB databases. Add a webform to the project. Drag and drop a GridView control on the webform. Copy and paste the following code in the code-behind file. using System; using System.Configuration; using System.Data; using System.Data.SqlClient; namespace Demo { public partial class WebForm1 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { string USADBCS = ConfigurationManager.ConnectionStrings["USADB"].ConnectionString; string UKDBCS = ConfigurationManager.ConnectionStrings["UKDB"].ConnectionString; SqlConnection con = new SqlConnection(USADBCS); SqlDataAdapter da = new SqlDataAdapter("select * from Employees", con); DataSet ds1 = new DataSet(); da.Fill(ds1); con = new SqlConnection(UKDBCS); da.SelectCommand.Connection = con; DataSet ds2 = new DataSet(); da.Fill(ds2); ds1.Merge(ds2); Gridview1.DataSource = ds1; Gridview1.DataBind(); } } }
Views: 88941 kudvenkat
Java Tutorial 10: Create a simple Bank Account
 
12:19
Java Tutorial 10: Create a simple Bank Account. Demo on creating a simple bank account with multiple classes. Topics covered include working with multiple classes, creating objects and private variables in java.
Views: 93773 10minutetrain
LEAD Analytical function in PL SQL.
 
10:29
How to get nth highest record using Lead Analytical function in PL SQL. Use of Analytical Functions in Oracle pl sql makes it easy to find the nth leading value with respect to your current record. Watch this pl sql tutorial and you can understant the use of lead function in sql.
Views: 629 Subhroneel Ganguly
What is Oracle Exadata Smart Scan (Demonstration)
 
03:47
How does Oracle Exadata Smart Scan work? What is Smart Scan. How to insure Oracle is offloading work to the Storage Tier? Learn this and more in this demonstration by OC Master John Watson of SkillBuilders. See all 11 lessons in this tutorial at http://skillbuilders.com/exadata-tutorials. John Watson: I want to show you very briefly how offload Smart Scan or flow processing can actually function. I'm working here just in the little demonstration Scott schema. I'll enable auto tracing so that we can see the effect on execution plans, which will also show me whether offload processing is indeed possible. So it's a simple query. I'll use a function here to check that to get offloaded as well as the column selection and the row selection and column projection. We'll have a predicate. Right. So there is the statement. It returned these three scalar values, as you would expect. How was this actually executed? There was a select statement, then it was executed, table access full. That's the only way to run that statement given the index on that table because in the middle of this, we see the key word, "storage." That key word tells me that this statement could indeed be offloaded to the storage tier. Furthermore, we see down here in the predicate information, "storage." That key word again tells me that the row filtering could have been done by the storage tier. So what happened is that the storage tier did not return every block of the empty* table to the database buffer cache, where my session would then have had to extract these values. All it returned to the instance was these three scalar values directly into the PGA of my server process. Now, there's also the initcap function there. Was that offloadable or not? There is a view "Read our SQL fm letter data," and that will tell us for each function whether or not it can be offloaded. So, just select its name, whether it's offloadable. Declare offloadable as yes and put in a sort order as well, and we see that in the current release, there are 393 functions that can be offloaded. Which ones? All the typecasting functions, truncations, trims. These are functions that get executed millions of times an hour in many, many environments. Note here two particularly important ones, balloon filters. The offload capability for balloon filters allows us to offload joins or facts to dimension tables. Those two in star schemas can be offloaded. The function I used was, in fact, initcap. Just for completeness, we'll scroll through all of these and we'll see that initcap itself is an offloadable function, and there it is along with many others. There are two classes of function that cannot be offloaded, and those are the aggregation functions and the analytic functions. I mention them just for completeness. There's an architectural issue there because aggregations and analytics potentially require access to all rows in the table. The row might be distributed across a cell. So it's a technical issue why they can't be offloaded, but virtually, all other functions can be offloaded with terrific drops in CPU usage, and combining that with the reduction of data traffic into the instances will give us vast performance improvements.
Views: 3869 SkillBuilders
How to change opening balances after accounts finalisation
 
06:39
#gaddamsubramanyam #tallyprofessor #tallytutorials #tallyerp9classes In this video i have described how to compare previous year closing balances into current year opening balances and also how change opening balances in current year after finalised / audited your prev year accounts balance sheet Most useful videos from my channel 1.GST sales and purchase entries in tally erp9 https://youtu.be/zecdq-DT6qY https://youtu.be/QrOciPJ_Jog 2. GST Expenses in tally erp9 https://youtu.be/8izU2ANXBgE 3. C forms register in tally erp9 https://youtu.be/pXXlsh2TG_A 4. Tally erp9 full tutorial https://youtu.be/wIFdDoYc6Zc 5. Vat adjustment entries https://youtu.be/HOJpVnAC7pM 6. Import and export ledgers in tally https://youtu.be/MsirLZoqk48 7. Tally basic course https://youtu.be/pnMUF63rU2Q tags compare columnar reports #gaddam subramanyam
Views: 203477 Subramanyam Gaddam
how to import oracle database or dmp file
 
05:50
This video will tell you how to import a user from oracle data to you oracle data base
Views: 90151 brijesh kumar
MSSQL - How to send a Query result as an Email Attachment
 
09:45
How to create a query and email the results as an attachment
Views: 36452 CodeCowboyOrg
Matching transactions (reconciling) using Excel Pivot Tables | ExcelTutorials
 
13:38
Matching transactions (reconciling) using Excel Pivot Tables | ExcelTutorials Learn how to reconcile (or match) transactions using Excel Pivot Tables. Example workbook and more here: http://chandoo.org/wp/2014/06/10/matching-transactions-pivot-tables/ Do Subscribe, Like & Share my video if you like!! Click The Below Link To SUBSCRIBE: https://www.youtube.com/channel/UC8uU_wruBMHeeRma49dtZKA
Views: 137344 Learn Excel from Chandoo
How to import Data into Table using Teradata SQL Assistant
 
02:01
We can use Teradata SQL Assistant to load data from file into table present in Teradata. Refer to below link for more details: http://usefulfreetips.com/Teradata-SQL-Tutorial/teradata-sql-assistant-import-data/
Views: 60114 TeradataSQLTutorials
Search Records with Single Quotes - SQL in Sixty Seconds #075
 
01:09
In this quick video we see four different methods to search records with single quotes from database table. All the methods give same performance. Read more over here: http://blog.sqlauthority.com/2014/10/22/sql-server-search-records-with-single-quotes-sql-in-sixty-seconds-075/
Views: 5541 Pinal Dave
How to write post query trigger in Oracle Forms.
 
06:57
How to write post query trigger in Oracle Forms. Post query triggers at block level to retrieve data from other table. This is a small tutorial in Oracle forms to show you creating forms post query trigger, writing pl sql code into triggers.
Views: 8461 Subhroneel Ganguly
Automate Excel To PDF & Send PDF Document As Mail Attachment
 
13:26
How to automate the conversion of an Excel file to a PDF document and email the PDF document via Outlook automatically using VBA. Complete code and sample file available here: http://www.exceltrainingvideos.com/automate-excel-to-pdf-and-email-pdf-document-using-vba/ For more knowledge read the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Views: 133268 Dinesh Kumar Takyar
SQL Tutorial #2 Distinct, Like, Wildcards and Char List
 
03:39
How to use the like statement, wildcards and char list in SQL.
Views: 500 David Lent
QMF Best Practice: QMF 11 Classic...Multiple statement query and Query confirmation prompting
 
04:57
QMF version 11 allows multiple SELECT and COMMIT statements in a query object. This video demonstrates this enhancement and shows you how to set it up. How to use a multiple statement query with Global Temporary Tables is also discussed. With the information in this video you will be better prepared to exploit these new capabilities.
Views: 1112 World of Db2
How To Display PDFs In A Form
 
10:04
How to display PDFs in an Access 2013 form. This video explains how to create a form that displays the contents of another file, such as a PDF file, inside of your form. You will also learn how to use a File Dialog window to allow your users to dynamically pick the file to view.
Views: 77115 Programming
Excel Magic Trick 1133: Aging Accounts Receivable Reports: PivotTable & Unique Identifier
 
09:37
Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to create Aging Accounts Receivable Reports On Multiple Sheets With PivotTable where or not there are duplicate records: 1) (01:49 min) Days Late Helper Column Formula: TODAY function and relative cell reference 2) (02:46 min) Report Category Helper Column Formula using VLOOKUP 3) (03:45 min) Unique identifier Helper Column Formula using COUNTIF, expandable range and Join Symbol 4) (05:55 min) PivotTable based on Invoice Column 5) (08:48 min) PivotTable based on Unique identifier column What is an Aging Report: Aging means how many days past the due date the invoice is. Accounts Receivable Customers must pay their bill by a certain date, if they pay late, they would be listed in one of the aging reports. If they are 1-30 days late, they are listed in the first report. 31-60, the second. And so on. Further, once the customer is so late, like 300 days, the company stops wasting its time trying to collect and writes the Accounts Receivables amount as "Bad Debt" and runs that expense through the Income Statement.
Views: 83887 ExcelIsFun
Quick Coding with Brackets - Multiple Cursors
 
11:44
There are many ways to access Multiple Cursors in Brackets. The first part of the lesson is spent teaching the different ways to get multiple cursors. The second part of the lesson is demonstrating most of these ways in my project. If you are short on time, you can just watch from 1:40 to 4:50 to see the overview. 1:40 - Alt+Drag mouse 2:00 - Select a column of text 2:15 - Alt+Shift+Arrow to add cursors 2:40 - Cmd/Ctrl and click to add a cursor 3:00 - Cmd/Ctrl+B - Add next match to selection 3:50 - Alt+F3 (Cmd+Ctrl+G) - Select all of current selection 4:18 - Split selection into lines 4:50 - Demonstration of different methods 6:35 - ESC to get out of multiple cursor mode
Views: 4146 Lisa Catalano
How to Create a Stock Management Database in Microsoft Access - Full Tutorial with Free Download
 
26:08
This tutorial will explain how to use Microsoft Access to create a working stock control database with some basic features. Follow along with our free download of the basic stock database we created in this video: http://www.software-matters.co.uk/free-access-stock-control-database.asp All you need to get started is a copy of Access and a beginner's knowledge of how it works. Get more help and advice on Excel, Access or VBA projects: http://www.software-matters.co.uk/youtube_links.html If you want to find out whether a bespoke database would be right for you, get in contact: http://www.software-matters.co.uk/contact.asp Learn more about our work: http://www.software-matters.co.uk/projects-blog.html Music by Kevin MacLeod http://incompetech.com/music/royalty-free/ We have now uploaded a no music version of this video: https://www.youtube.com/watch?v=049IlFNcrl0 --------------------------------------------- If you found this video helpful, please consider giving it a Like, leaving a comment or sharing it. More from the Software-Matters channel: https://www.youtube.com/channel/UCk-MVP61VQHMdfETVNQEFww Visit the Software-Matters website: http://www.software-matters.co.uk Software-Matters is based in Gillingham, Dorset, in the south-west of the United Kingdom (UK), near Somerset, Wiltshire and Hampshire and the cities of Bournemouth, Poole, Southampton, Bristol, Bath and Salisbury. ---------------------------------------------- MORE INFORMATION: To follow this tutorial you will need a full copy of Microsoft Access. The video was made using Access 2010, however the process is very similar in Access 2007 and Access 2013. We'll be going as far as setting up the database tables, which traditionally would be stored in a so-called 'back end' database file, while forms, queries and report, which are not covered in any details by this tutorial, would be stored in a separate 'front end' database file. The tables from the back end are then 'linked' to the front end, so that it behaved as if all the objects were in one file. In some places we have made the design deliberately simple in order to keep our relationships clean and the number of tables low. This helps those new to Access to get their heads around how to create the database, but for actual use, might cause problems. We recommend that you learn more about database design from other sources before beginning your project if you intend to use it for a real business. Key topics to consider are: database normalisation theory; Inner, Left, Right and Outer Joins; Basic SQL (structured query language) use; Software Development Methodologies; UX (user experience) enhancement techniques; and of course, the very specific needs of your business, project or client. All together, a broad knowledge of these topics will allow you to design your tables with enough foresight to make the setting up of the queries, forms and reports you'll need later as easy as possible. Plus it should make the system easy to use and less likely to be corrupted or crash. Keep in mind that even if your stock database needs don't fit very well with our example parts database, or if you need an entirely different kind of system like an accounts database or CRM database, the lessons in this tutorial can still apply.
Views: 456248 Software-Matters
Introduction to the Kelverion Integration Pack for SQL Server
 
00:58
The IP for SQL Server provides an enhanced user experience and capabilities over the current objects shipped with Orchestrator. The key capabilities added to your Orchestrator solution include: * Automatically builds and executes the necessary commands without the user having to write or understand SQL. * Simplifies policy design by automatically mapping table columns to Orchestrator input properties, filters and published data items. * Prevents errors by controlling access to read-only fields, enforcing mandatory inputs and by providing value browsers for common data types. * Improves performance by using connection pools to reduce the overhead of repeatedly opening and closing database connections. * Introduces the ability to monitor database tables for new and/or modified rows. * Provides the ability to use a single configuration for Orchestrator connection to a database. http://www.kelverion.com/integration-packs/ip-sql-server/
Views: 13639 Kelverion
MySQL VB.NET Tutorial 14 : Search data in database and Filter in datagridview
 
07:34
Code for searching data from database using Visual Basic Visual Basic Search in database VB.NET how to search data in database in asp.net with Visual Basic VB.NET how to search data with data grid in asp.net using Visual Basic VB.NET how to make search in sql database in asp.net using Visual Basic To Search The Data From Database Using Visual Basic.net(Visual Basic) VB.NET Search as you type implementation in Visual Basicusing Sql Database Visual Basic display data from database using sqlparameters VB.NET Visual Basic - Displaying selected data in a datagridview VB.NET Visual Basic - How to Display data in datagridview from access database VB.NET updating data in database using datagridview Visual Basic Datatable Search
Views: 94681 ProgrammingKnowledge
Oracle Drop database
 
02:27
A short video on how you can drop an Oracle database using drop database command from SQL*PLUS
Views: 1427 André Karlsson
Financial reporting tutorial: Introduction to the cash flow statement | lynda.com
 
04:04
A key financial report, the cash flow statement provides information on the cash available in the bank over a period of time, which can be particularly useful when tracking outstanding invoices, for example. Learn about the cash flow statement in this tutorial. Watch more at http://www.lynda.com/Business-Finance-tutorials/Financial-Literacy-Reading-Financial-Reports/135826-2.html?utm_campaign=5YStSfvSSP0&utm_medium=viral&utm_source=youtube. This tutorial is a single movie from the Financial Literacy: Reading Financial Reports course presented by lynda.com author Rudolph Rosenberg. The complete course is 1 hour and 25 minutes and shows how to read income statements, cash flow statements, and balance sheets and assess the financial health of your business and your competition. Introduction 1. Financial Statements 2. The Balance Sheet 3. The Income Statement 4. The Cash Flow Statement Conclusion
Views: 3380 LinkedIn Learning
SQL QUERY WHERE CLAUSE BETWEEN EXAMPLE
 
02:51
SQL QUERY WHERE CLAUSE BETWEEN EXAMPLE A Job Portal http://www.InterviewDot.com http://www.InterviewDot.com http://www.InterviewDot.com One Click Dream Job - http://www.interviewdot.com/upload-resume/uploadresume.htm Are you looking for a new Job ? InterviewDot.com - A Job Portal http://www.InterviewDot.com http://www.InterviewDot.com http://www.InterviewDot.com One Click Dream Job - http://www.interviewdot.com/upload-resume/uploadresume.htm JAVA/SPRING/SQL/JUNIT INTERVIEW QUESTION AND ANSWER SQL QUERY WHERE CLAUSE BETWEEN EXAMPLE
Views: 297 Interview Dot
Crystal Reports - Display Date Range Parameter
 
01:31
http://www.ReportingGuru.com produced this video. This video shows how to display your date range parameter values in your report. Email us at [email protected] if you need help, custom reports, or reporting architecture setup. Our phone number is 1-(800) 921-4759
Views: 19664 Reporting Guru
C# MS Access Database Tutorial 6 # Insert/Save data to database
 
18:32
How to: Insert New Records into a Database Database Access with Visual C#.NET sql server - Insert Data into database in C# How to insert Data to Ms SQL server 2008 using C#.net .net - C# insert data into SQL table MS Access Using Visual C# and SQL cannot insert data into table..‎ c# import data from text file into sql databse line by line‎ store xml in SQL Server 2008 from C#‎ MS Access Using SQL in C# - Cannot insert data into SQL table visual C# - Could not Insert the data using VC# in MS Access Add, save & retrieve data in SQL MS Access insert data in sql 2005 from excel file through c# asp.net‎ insert data into SQL table from pre filled boxes in C# 4.0‎ insert into database unsing ado.net and C#‎ MS Access Insert DateTime into SQL Server using C#‎ Searches related to c# insert data into sql MS Access c# insert data into sql table c# insert data into sql server MS Access inserting data into sql table MS Access insert query MS Access sql insert statement from another table
Views: 118086 ProgrammingKnowledge
OBIEE Dynamic Session Variables - Creating and Using in an Analysis - OBIEE Online Training
 
12:33
This video tutorial demonstrates how to create an OBIEE database-driven session variable using the BI Admin Tool. The initialization block selects data from a database table to set the value of the variable. After creating the session variable and init block, we can then use the variable in an analysis filter, and well as display the value in the title view.- https://www.fireboxtraining.com/obiee-training
Views: 30138 Firebox Training