Home
Search results “Find all invalid objects oracle”
SQL Prompt - find invalid objects
 
01:47
SQL Prompt is a code completion, code formatting, and refactoring tool for SQL Server. It’ll plug into SQL Server Management Studio or Visual Studio. You’ll find you can work more quickly and accurately with SQL queries, as well as standardize across your team by sharing formatting styles and commonly used SQL snippets. Try it free for 28 days at www.red-gate.com/sqlprompt In this tip Data Platform MVP Ike Ellis explains how to use SQL Prompt to find invalid objects, so you can catch problems earlier in development and resolve issues quickly. For more tips for writing SQL effortlessly check out the #SuperSQLTips playlist: https://www.youtube.com/playlist?list=PLhFdCK734P8A_q6XHDXi4CQzys3R0Jw3X Transcript: Hi I'm Ike Ellis and I’m going to show you a cool feature of SQL Prompt. One of the issues with T-SQL is that doesn't really tell you when you have dependencies with your objects by default. So if I create a table right here like the customers table and then I create a stored procedure that's dependent on the customers table and then later on at some point I delete the customers table like I drop table customers, there's no warning here telling me that I've got a procedure using that table. Software development teams have struggled with this for a very long time. Often what they'll do is at one step in the release pipeline they'll drop and recreate all the stored procedures, or all their views or all their functions and then it will warn them to tell them that they have a dependency in the drop and recreation. But the problem with that is you have to remember to do it - you have to do it manually or automatically - and you actually have to do it at the last step of your release pipeline, well after you've made any schema changes or else you really didn't do anything useful. But one thing you can do with Redgate SQL Prompt is you can right-click on your database and you can say ‘find invalid objects’ and it will warn you, it will say “hey this store procedure is dependent on a table that's no longer here”. And if you get used to doing this you can do it way earlier in the development process. You can do it every day or at the end of every day or before you check in a source control, and then you can catch your problem before any other developer on your team finds the problem. We know that when a developer finds his own problem or her own problem that it's far cheaper, way easier to resolve, all good things. So thanks, hope you enjoyed this tip and you find out for yourself by downloading the latest SQL Prompt. Thanks have a great day.
Views: 1563 Redgate Videos
How to compile objects in Oracle database
 
00:50
This tutorial show the compilation process in Oracle database using DreamCoder for Oracle.
Views: 3550 sqldeveloper
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: 183378 Manish Sharma
How to create an user and to grant all privileges to them in Oracle database
 
03:52
This video shows you how to create a new user and to grant privileges to them. Syntax to create a new user: create user username identified by password
Views: 37369 Thamizharasan Mohan
SQL tutorials 17: SQL Primary Key constraint,  Drop primary Key
 
09:22
Blog link: http://www.rebellionrider.com/sql-primary-key.htm SQL tutorial on Primary key / SQL Primary key, In this tutorial you will learn about simple primary key, composute primary key, how to drop primary key. defining primary key using create table and alter table along with many other things. Tool used in this tutorial is SQL Developer. 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 So Primary Key There are two types of Primary keys First is Simple primary Key: Primary key which Involves only one column and Second is Composite Primary Key: Primary Key which involves more than one column. We will start with Simple primary key. You can create Primary key either with Create Table statement of by using Alter table Statement. Let's define simple primary key using create table statements. With create table statement we can either define primary key at column level or at table level. We will start with defining Primary key at column level using create table statement. You just have to put keyword Primary key after data type and size of column while defining a column of a table. Here oracle server will create a primary key on product id with default constraint name which will be slightly difficult to understand. You can give your own name to your constraint which is also a good practice.
Views: 102137 Manish Sharma
Regular Expressions (Regex) Tutorial: How to Match Any Pattern of Text
 
37:55
In this regular expressions (regex) tutorial, we're going to be learning how to match patterns of text. Regular expressions are extremely useful for matching common patterns of text such as email addresses, phone numbers, URLs, etc. Almost every programming language has a regular expression library, so learning regular expressions with not only help you with finding patterns in your text editors, but also you'll be able to use these programming libraries to search for patterns programmatically as well. Let's get started... The code from this video can be found at: https://github.com/CoreyMSchafer/code_snippets/tree/master/Regular-Expressions Python Regex Tutorial: https://youtu.be/K8L6KVGG-7o If you enjoy these videos and would like to support my channel, I would greatly appreciate any assistance through my Patreon account: https://www.patreon.com/coreyms Or a one-time contribution through PayPal: https://goo.gl/649HFY If you would like to see additional ways in which you can support the channel, you can check out my support page: http://coreyms.com/support/ Equipment I use and books I recommend: https://www.amazon.com/shop/coreyschafer You can find me on: My website - http://coreyms.com/ Facebook - https://www.facebook.com/CoreyMSchafer Twitter - https://twitter.com/CoreyMSchafer Google Plus - https://plus.google.com/+CoreySchafer44/posts Instagram - https://www.instagram.com/coreymschafer/
Views: 214133 Corey Schafer
how to solve error invalid object name
 
01:10
how to solve error invalid object name
Views: 2965 Uus Rusmawan
002- |Solved|Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.
 
06:25
002- Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. Errors in vb
Views: 1665 Access Forever
OATS Troubleshooting #2 - solve rule file invalid openscript to generate xpath ebs forms
 
01:00
In this OATS Video tutorial, we cover the detailed steps to solve one of the issues which are displayed in run diagnosis tool, i.e. rule file to generate xpaths for oracle ebs forms is missing or invalid, in this video we cover the steps to solve it. Most of the times resolution steps are present as part of the diagnosis tool of openscript, i.e. when you click on the rows which are shown in red, then in the bottom of the window it also shows us steps to be followed to resolve the same.
Views: 138 testingtools.co
Solved Invalid object temp table in Stored Procedure while adding to dataset .NET
 
02:46
Solution for fixing this issue is: Add below script in beginning of your SP. IF 1=0 BEGIN SET FMTONLY OFF END FMTONLY returns only metadata to the dataset. Can be used to test the format of the response without actually running the query. Example SET FMTONLY ON; GO SELECT * FROM Orders; GO SET FMTONLY OFF; GO Above query will give column output without data.
Views: 1804 techsapphire
Oracle Database Tutorial 52 : Data Pump expdp - How to Export full database using expdp
 
07:26
Oracle Database tutorial/SQL Tutorial 52 On Data Pump expdp utility here in this tutorial you'll learn how to export full/complete Database using expdp data pump utility of oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/database-full-export-using-expdp Tut 48 Roles: http://youtu.be/tyYxSrCXzCM ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►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 [email protected] 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: 78022 Manish Sharma
Table Shrinking in Oracle Database
 
14:15
1.Shrink the Table: Shrinking is started from 10g. In this method I’m using user u1 and table name sm1. Now I’m deleting some rows in sm1 COUNT ---------- 1048576 Table sm1 has 1048576 rows. [email protected]: delete from sm1 where deptno=10; 262144 rows deleted. I deleted above number of rows. Rows COUNT ---------- 786432 And I’m giving commit [email protected]: commit; Commit complete. So now we have 786432 rows in sm1 table. Now see the following command [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ------ ---------- ---------- U1 U1TS SM1 TABLE 29 mb 3712 44 After I deleted some rows in sm1 table still above result showing same values, so now our duty is shrink this table. This is done by following 2 ways, i By using COMPACT key word: In this method shrinking is done in two phases. In the first phase all fragmented space are just defragmented, but still the High Water Mark is persist with last used block only. That mean used free blocks are not de allocated and HWM is not updated here. Issue the following command before use shrink command. [email protected] alter table sm1 enable row movement; Table altered. There is particular use with above command, when we shrink the table all rows are moves to contiguous blocks, so here row movement should be done. By default the row movement is disabled for any table, so above command enabled the row movement. Then execute shrink command now. [email protected]: alter table sm1 shrink space compact; Table altered. Now see the space of table by using below command. [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ------ ---------- ---------- U1 U1TS SM1 TABLE 29 mb 3712 44 So here seems nothing happened with above shrink command, but internally the fragmented space is defragmented. But the high water mark is not updated, used free blocks are also not de allocated. For de allocating the used blocks we have to execute below command. This is the second phase. [email protected]: alter table sm1 shrink space; Table altered. Now see the space by using below command. [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ---------- ---------- ---------- U1 U1TS SM1 TABLE 20.8125 mb 2664 36 So now the space of sm1 table is reduced. Note: Actually the alter table sm1 shrink space command will complete these two phases of the shrinking of table at a time. But here we done shrink process in two phases because when we use alter table sm1 shrink space command the table locked temporarily some time period, during this period users unable to access the table. So if we use alter table sm1 shrink space compact command the table is not locked but space is defragmented. When we not in business hours issue the second phase shrink command then users are won’t get any problem. ii Because of above method the table dependent objects are goes to invalid state, to overcome this problem we have to use below command. [email protected]: alter table sm1 shrink space cascade; Table altered. The above command also shrinks the space of all dependent objects. We also do this in two phases like above two phases. See the below command. [email protected]: alter table sm1 shrink space compact cascade; Table altered. And then [email protected]: alter table sm1 shrink space cascade; Table altered. Transporting tablespace to different platform by Using RMAN : https://www.youtube.com/watch?v=CN401PUKK4A Oracle EBS apps Upgrade from 12 2 to 12 2 5 (start CD 51) : https://www.youtube.com/watch?v=zeO4goqR70Y Transport tablespace by using RMAN.: https://www.youtube.com/watch?v=YG6kWX7Par8
Views: 7113 BhagyaRaj Katta
How to Detect Soft Corruption in Oracle 12c Database
 
18:19
Detection of Soft Corruption in 12c: To use the scripts below replace : , ",# and $ by proper bracket Lets Create a tablespace and small table. SQL: create tablespace DEMO1 datafile '/u02/tstdb1/TSTDB1/datafile/demo01.dbf' size 50M SQL: create table objects tablespace DEMO1 as select * from dba_objects; SQL: alter table objects add constraint pk_obj primary key #object_id$; SQL: create index idx_obj_name on objects#object_name$ tablespace demo1; Backup tablespace. RMAN: backup tablespace DEMO1; We need to put the DB in archivelog first Rebuild index with NOLOGGING option to simulate soft corruption later. RMAN: alter index idx_obj_name rebuild nologging; Confirm that we have datafiles that require backup because they have been affected with NOLOGGING operation. RMAN: report unrecoverable; Simulate corruption. RMAN: alter database datafile 5 offline; RMAN: restore datafile 5; RMAN: recover datafile 5; RMAN: alter database datafile 5 online; Query table with corrupted index and notice error. SQL: select count#*$ from objects where object_name like 'A%'; Let’s perform validation of datafile to check block corruption. RMAN: backup validate check logical datafile 5; Notice that we have 457 blocks marked corrupt but v$database_block_corruption view is empty. SQL: select count#*$ from v$database_block_corruption; Let’s query v$nonlogged_block view. set lines 200 set pages 999 select file#, block#, blocks,object#,reason from v$nonlogged_block; Will RMAN detect that we have corrupted blocks? RMAN: backup datafile 5; RMAN backup won’t fail due to NOLOGGING corrupt blocks and our backup will contain soft corrupted blocks. Let’s Identify corrupt segments using v$nonlogged_block view. set lines 2000 set pages 9999 col owner for a20 col partition_name for a10 col segment_name for a20 SELECT e.owner, e.segment_type, e.segment_name, e.partition_name, c.file# , greatest#e.block_id, c.block#$ corr_start_block# , least#e.block_id+e.blocks-1, c.block#+c.blocks-1$ corr_end_block# , least#e.block_id+e.blocks-1, c.block#+c.blocks-1$ - greatest#e.block_id, c.block#$ + 1 blocks_corrupted FROM dba_extents e, V$NONLOGGED_BLOCK c WHERE e.file_id = c.file# AND e.block_id "= c.block# + c.blocks - 1 AND e.block_id + e.blocks - 1 := c.block# UNION SELECT s.owner, s.segment_type, s.segment_name, s.partition_name, c.file# , header_block corr_start_block# , header_block corr_end_block# , 1 blocks_corrupted FROM dba_segments s, V$NONLOGGED_BLOCK c WHERE s.header_file = c.file# AND s.header_block between c.block# and c.block# + c.blocks - 1 UNION SELECT null owner, null segment_type, null segment_name, null partition_name, c.file# , greatest#f.block_id, c.block#$ corr_start_block# , least#f.block_id+f.blocks-1, c.block#+c.blocks-1$ corr_end_block# , least#f.block_id+f.blocks-1, c.block#+c.blocks-1$ - greatest#f.block_id, c.block#$ + 1 blocks_corrupted FROM dba_free_space f, V$NONLOGGED_BLOCK c WHERE f.file_id = c.file# AND f.block_id "= c.block# + c.blocks - 1 AND f.block_id + f.blocks - 1 := c.block# order by file#, corr_start_block# / This is the best outcome to get if you notice corruption errors. All errors are related to index corruption so we could fix this problem rebuilding index. alter index idx_obj_name rebuild; Simply issuing "alter index rebuild" command won't work. We should mark index unusable to drop segment before rebuilding it or just rebuild index with online option. It is better choice to mark index unusable because you don't need additional space then, but I will simply rebuild index with online option and see what will happen. SQL: alter index idx_obj_name rebuild online; Index altered. SQL: select count#*$ from objects where object_name like 'A%'; No errors... but, let's validate datafile for corruption. RMAN: backup validate check logical datafile 5; Notice "Marked Corrupt" column. Hm... 457 like before. Don't worry, this is not new corruption. These are FREE blocks which will be reused and Oracle will automatically re-format those blocks. Query the v$nonlogged_block view again as given above. We could force re-formatting creating dummy table and inserting data to dummy table. Check Doc ID 336133.1. create table s # n number, c varchar2#4000$ $ nologging tablespace DEMO1; SQL: BEGIN FOR i IN 1..1000000 LOOP INSERT /*+ APPEND */ INTO sys.s select i, lpad#'REFORMAT',3092, 'R'$ from dual; commit ; END LOOP; END; / SQL: drop table sys.s purge; Notice that we don't have corrupted blocks any more. RMAN: backup validate check logical datafile 5;
Views: 199 OracleDBA
SQL tutorial 38: How to create user using SQL Developer in Oracle database
 
06:52
How to create new user accounts using SQL Developer in oracle database. In This tutorial you will learn how to create a new user account. How to setup a database connection with SyS user. How to grant privileges to the user ----_Links_--- Blog :http://bit.ly/create_user_account Video Tut 4: http://youtu.be/wSqoXRlXDUU How to create database: http://youtu.be/enFFezPYhCg 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: 66695 Manish Sharma
PL/SQL (Solve Compilation Errors)
 
06:01
PL/SQL (Solve Compilation Errors)
Global Index rebuild scenario in Oracle Database 11g
 
08:41
Why and How we need to rebuild global Index in Oracle 11g
Views: 3388 Athar Fahad
Oracle Data Export and Import using DataPump expdp and impdp
 
09:38
Oracle Data Export and Import using DataPump expdp and impdp
Views: 183846 Abbasi Asif
Oracle Database Tutorial 66: How To Create Undo Tablespace By Manish Sharma RebellionRider
 
05:15
Oracle data base tutorial on how to create undo tablespace By Manish Sharma from RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/undo-tablespace-rebellionrider Previous Tutorial ► Tut 63 Intro: https://youtu.be/5i5RtUdxaHY ► Tut 64 Permanent Tablespace: https://youtu.be/vkwKZIssvfc ► Tut 65 Temporary Tablespace: https://youtu.be/Hc_OXitKgWM ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►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: 13278 Manish Sharma
Oracle Database Tutorial 58: How To Import Schema using REMAP_SCHEMA in impdp Data Pump Import
 
03:59
Learn how to import schema using REMAP_SCHEMA in impd data pump import in oracle database By Manish Sharma Rebellion Rider. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/how-to-import-schema-impdp-data-pump-oracle Previous Tutorial Tut 56 How to import table in same schema : http://youtu.be/oEnmEUlicY0 ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►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 [email protected]om 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: 23082 Manish Sharma
Frgmentation in oracle database
 
34:54
Fragmentation in oracle database,find and defragmentation
Views: 4046 Sainora Annanagar
Resetting Your Oracle Database Password with Oracle SQL Developer
 
02:43
Resetting your Oracle Database user password just got a LOT easier in version 4.2 of SQL Developer. In this video, the product manager shows you JUST how much easier.
Views: 23196 Jeff Smith
CHANGING THE CHARACTER SET TO AL32UTF8
 
02:55
By using these steps you can change the oracle database character set to AL32UTF8
Views: 30102 venkatesh sankala
Oracle Database Tutorial 56:Data Pump impdp table and Duplicate (Remap_table ) table
 
06:03
In this oracle database tutorial you will learn How to import table using impdp data pump import utility. And how to rename table using REMAP_TABLE in impdp Data Pump import. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/oracle-data-pump-impdp-import-and-duplicate-table-remap-table Previous Tutorial Tut 55 expdp table- http://youtu.be/5mdmCqGuok8 Tut 54 expdp Schema - http://youtu.be/t8TSLDGN5gg Tut 53 expdp Tablespace - http://youtu.be/-hXBZd-FCjs Tut 54 expdp Full Database - http://youtu.be/K8_PjUksT54 ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►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 [email protected] 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: 24260 Manish Sharma
DB2 Tips n Tricks Part 51 - How To List all Database Objects in a Schema
 
06:32
How To List all Database Objects in a Schema Solution: Use SYSIBMADM.OBJECTOWNERS Admin View or db2look -d dbname -e -z schema-name Happy Learning & Sharing
Views: 3272 DB2-LUW-ACADEMY
Let Oracle Do the Heavy Lifting: using compile-time warnings
 
13:35
The PL/SQL compiler does more than make sure your code can execute. If you turn on compile-time warnings, the compiler will also give you recommendations on improving performance, taking full advantage of PL/SQL features, improving overall code quality. Examples: the compiler can tell you under a number of circumstances that a runtime error will occur; that there are unreachable chunks of code, and more. ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
How to Find if Table/View is used by Stored Procedure in SQL Server - SQL Server Interview Questions
 
06:44
In this video, we are going to learn how to find out if the table is used in a Stored Procedure. we have multiple ways to do that. This System Stored Procedure will return you list of table/views used by the Stored procedure/View. You can pass the view name or Stored Procedure as parameter,it will return you tables/views which are used in the object. One disadvantage of using sp_depends is , it will not show you tables/views which are not in current database. If you have used objects from other databases, this information might be misleading. --By using sp_depends, You can provide Stored Procedure Name or View name as parameter EXEC sp_depends '[dbo].[GetCustomer]' The 2nd method is to use the sys.sysdepends view with combination of sys.sysobjects to get the information. This also works the same way. It will not show you cross database objects ( Tables,Views) if have used in Stored Procedure or view definition. --Get Information from sys.sysdepends SELECT DISTINCT OBJECT_NAME(SD.id) AS StoredProcedureNameName, OB.name AS TableOrViewName FROM sys.sysdepends SDINNER JOIN sys.sysobjects O ON SD.id=O.id INNER JOIN sys.sysobjects OB ON SD.depid=OB.id AND O.xtype='P' 3rd method is to use the sys.all_sql_modules system view. The definition column of this view has definition of Stored Procedure, Views, Functions etc.You can write query as given below to check if any of the Stored Procedure or object is using the table/view you are looking for. --Use sys.all_sql_modules system view to get information if table is used --in a Stored Procedure SELECT OBJECT_NAME(OBJECT_ID),definition FROM sys.all_sql_modules WHERE definition LIKE '%vw_Employee%' Link to post: http://sqlage.blogspot.com/2015/02/how-to-find-if-tableview-is-used-in.html
Views: 10343 TechBrothersIT
Set your SQL server default database to be the CM database
 
01:54
In this video we will show SCCM admins how to get rid of the invalid object name error that is caused by not being connected to the Configuration Manager database. You know the error, we have all seen it! Msg 208, Level 16, State 1, Line 1 Invalid object name 'dbo.v_R_System'. Blog post: https://www.enhansoft.com/blog/invalid-object-name-in-sql-server-management-studio-ssms
Views: 3621 Enhansoft Inc
SQL Error ORA-00942 Table or View Does Not Exist in Oracle Database
 
05:03
How to use Tab View (Data Dictionary) of Oracle Database to solve the SQL Error ORA-00942 Table or View Does Not Exist error in Oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/ora-00942 Previous Tutorial ► ------------------------------------------------------------------------- ►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: 7729 Manish Sharma
Allround Automations PL/SQL shouldn't be genetics
 
00:53
Allround Automations PL/SQL shouldn't be genetics
SQL Prompt - script object as ALTER
 
01:01
SQL Prompt is a code completion, code formatting, and refactoring tool for SQL Server. It’ll plug into SQL Server Management Studio or Visual Studio. You’ll find you can work more quickly and accurately with SQL queries, as well as standardize across your team by sharing formatting styles and commonly used SQL snippets. Try it free for 28 days at www.red-gate.com/sqlprompt In this tip Data Platform MVP Steve Jones explains how to use SQL Prompt to script out objects as an ALTER statement in just a couple of clicks. For more tips for writing SQL effortlessly check out the #SuperSQLTips playlist: https://www.youtube.com/playlist?list=PLhFdCK734P8A_q6XHDXi4CQzys3R0Jw3X Transcript: Hi I'm Steve Jones from SQL Server Central and I've got another quick SQL Prompt tip brought to you by Redgate Software. One of the things people love about SQL Prompt is that I can type things like this store procedure and I'll get information about it and if I actually highlight at the end of it I can click on this and I can see the code. But that's sometimes hard to read and I have to expand this out to look at the rest of the code. If I want a quick look at what's inside of this I can right-click it and select Script object as ALTER. When I do that I’ll get a new window with all the code for the stored procedure listed including the alter procedure already set up, so if I need to change some code - perhaps I wanted to actually change this - then I could actually do that and compile it very quickly. Or if I just want to look at the code I can see it and then when I'm ready, go back to my original query. Hopefully this quick tip is something you'll use in SQL Prompt. I'm Steve Jones for SQL Server Central and Redgate Software.
Views: 594 Redgate Videos
Create new connection with new user in Oracle SQL Developer
 
10:28
This video shows you how to create a new connection using a new user account (other than the system user account) in Oracle SQL Developer, so that you have a clean workspace without all the clutter of system tables. It is NOT a general introduction to using Oracle SQL Developer.
Views: 361249 Chitu Okoli
Best Way to Write Basic SQL Queries
 
13:33
SQL Server Query writing strategies is something I have yet to find in any book. When enthusiastic SQL students do this, they experience a revelation. The number of errors drops significantly and the speed at writing complex queries increases immediately. Knowing how to narrow down what we are looking for amongst a vast list of choices helps immensely. Grabbing the right tables first and then the fields second is akin to grabbing the right menu before ordering an item from it. In fact, one student named Tim took this back to his team of SQL developers and they immediately implemented this process. We are all used to following steps. Most of the time, actions are sequential from top to bottom or left to right. Other times we complete things in phases. The two phases we are going to use in this exercise apply to joining tables. This is easy to implement as we only need remember to organize first and clean up second. When visiting a new restaurant, we will ask to see the menu, because we want to see all they have to offer. The odds are that we might be interested in half of the items, but only need a few dishes for our group at the table. Looking at the menu is like starting a query with a ‘SELECT *’ statement. Once we have looked at all the fields, we narrow our choice(s) to only the items we want at the time. Sometimes restaurants have multiple menus. My favorite restaurant has a kids’ menu, an adult menu, a gluten-free menu and a drink menu. These menus were each gathered at our table. Ultimately, in my head, a selection was narrowed to what was needed. Phase I: Organize. When building a new query from many tables, we often find ourselves wondering, “Where do I start?” First, lay the steps out by identifying which tables contain the essential data. Second, get all the table joins working with a basic ‘SELECT *’ statement. Third, add any basic filtering criteria. Phase II: Itemize. Once all joins and criteria, such as SELECT, FROM and WHERE are working, we are ready for Phase II. This entails going back and changing our ‘SELECT *’ to an itemized SELECT field list as the final step. Let’s explore how this two-phase process of Organize and then Itemize can be a big time-saver. We are going to use one of the challenges from the last lab. In Lab 3.2 (Outer Joins), Skill Check 2, we needed to get four fields from two different tables. If we were to list all four desired fields and test one table at time, we will get an error as seen on the right side of the figure below. In the figure below we write a SELECT statement and part of the FROM clause. When completed, the FROM clause will have two tables, but for now we just want to get the Location table working. By using the ‘SELECT *’ strategy, we remove any possible errors from line 1. From there, we can focus on the more complicated logic used for joining tables together. We can add tables one at a time until everything is working. This is the Organize phase. NOTE: SELECT * never results in an Error message stating “invalid column name”, however; a SELECT list with itemized field(s) can have this error. After our query is organized and working, we can go back and itemize the SELECT field list to display only the fields that are necessary. This is done during Phase II (Itemize). The steps for this system are broken down as follows: Since SELECT is always the first statement in a query, it’s natural to want to write the field names before writing the FROM clause. However; we can save time and trouble by using the ‘*’ until the entire query is working properly. When this is complete, it is very easy to itemize the field list, with the confidence of knowing it will not cause any problems. Exercise: Simple membership for a club: Table1 (id_Member,name_Member, email_member, title, age, company) Table2 (id_Club,club_name, club_Location, address) Table3 (id_club, id_member,membership_date) Q1: Show all member names, email, age, and company from Table1 Q2: Show all club name, location, and address data Q3: Show member name, club name, club location (hint: Use joins and all 3 tables) You can find all other classes related to this video here: http://www.joes2pros.com/joes2pros/Course/Introduction_To_Microsoft_SQL_Server Enroll Today & Get the First Month for only $1! Use code: YOUTUBE1
Views: 243269 Joes2Pros SQL Trainings
Database Testing in Software Testing | SQL Tutorial for Beginners
 
52:33
Learn database testing concepts, database testing basics and how to perform database testing manually with this database testing tutorial with examples in SQL Server , by Software and Testing Training channel. Sample DB Test Plan : http://inderpsingh.blogspot.com/2010/05/sample-database-test-plan.html First Normal Form : https://youtu.be/m67fCU-Dmhg Second Normal Form : https://youtu.be/3vOAKZwyC6M Third Normal Form : https://youtu.be/WB0ONKK_y68 Database migration testing / ETL testing : https://youtu.be/eQG4W4Zr8eo Testing Tutorials complete : https://www.youtube.com/playlist?list=PLc3SzDYhhiGWuMK03uYO-UENAx0s2woWM Test Automation : https://www.youtube.com/playlist?list=PLc3SzDYhhiGXVcy8EcrTSfwsC-v8EUZvg Website: http://inderpsingh.blogspot.com/ Messages: https://plus.google.com/+InderPSingh Twitter: https://twitter.com/inder_p_singh * useful for data testing, database testing for beginners, manual database testing
CimTrak for Databases
 
02:54
CimTrak : The Ultimate Change Monitoring for Your Databases In this video we are going to show you how the CimTrak system works to detect changes to your critical database schemas. With the system in place you can be alerted to any changes and quickly respond. Supported Platforms Cimtrak for Databases supports Ms sql Server, Oracle, MySQL, IBM DB2 What Can be Monitored CimTrak can monitor items such as: groups, users, roles, triggers, stored procedures, index/table definitions With the CimTrak integrity monitoring and IT security solution your team can easily monitor your databases for changes. CimTrak has you covered. This is the CimTrak Management Console. Here we have a CimTrak Server Agent with the CimTrak for Databases plugin installed. To setup a policy to monitor a SQL SERVER database, first right click the server to a new object group. Next expand the SQL Server node and enter in the credentials CimTrak will display the database objects and settings that you can monitor Though there are a variety of options, here we are selecting all the instance info and the Test database This will cover all schemas, database objects, and security access settings for that database We will remote into the server and start making some changes. Here is SQL Server with the test database. Now it is time to make changes First a table is being deleted Next an index is added And finally a user privilege is changed Now that we that have some changes let go back to the management console. Here we have the 3 change events that show the modifications We can right click and compare to see what changed. Here we can see the "Company Name" field has been removed from this table as it is highlighted in red. We can also see that new test index in green. Lastly the Logins schema has been modified as you can see the user Rob has been added to each role highlighted in green. CimTrak is your comprehensive solution for easily monitoring your database schemas. Thank you for watching. We hope this has helped you to understand how CimTrak assists in monitoring your IT systems.
Views: 304 CimTrak
SQL Consulting | Connect SQL Developer to Oracle Database
 
05:34
Connect SQL Developer to Oracle Database Tutorial http://www.ReportingGuru.com Email us at [email protected] if you need help, custom reports, or reporting architecture setup. Our phone number is 1-(800) 921-4759. Reporting Guru is a US based development company with all resources located in the US. We have many senior level developers with over a decade of development experience. Please let us know if you would like to discuss your requirements or issues free of charge. Our process is taking your requirements and suggesting the best architecture or approach without trying to sell you any specific software. We work as needed and only charge for the hours we work. We do not charge a retainer and there is no minimum charge. We offer the following services: Custom Report Writing | Consulting | Database Development & Integration. Some of our specialties are: --SQL Server Reporting Services SSRS / SQL Server / SQL Server Integration --Services SSIS / SQL Server Analysis Services SSAS --Custom Application Development / Maintenance --Oracle --MySQL --Crystal Reports / Business Objects --BIRT --.NET Development --PHP Development --SharePoint --Microsoft Dynamics --Access --Excel and Pivot Tables --More! CUSTOM REPORT WRITING Our experienced data report writers take your report & business requirements to build the custom reports you need. We deliver reports on demand or on a timed schedule. CONSULTING When your data and reporting team needs guidance or whether you need to build new reports, convert reports, enhance existing reports or need advice on finding the right reporting solution for your business ReportingGuru is here to help. DATABASE DEVELOPMENT & INTEGRATION We create and develop the necessary structure to house business data in a clear and easily accessible manner, so you have the tools to pull the reports you need easily. CUSTOM SOFTWARE & APPS We also offer custom applications for our clients like our Dashboard Guru and Quickbooks Enterprise Connector http://www.reportingguru.com/products/. Reporting Guru's dashboarding software will give interactivity to static web based reports. Our Quickbooks Connector will pull data from Quickbooks into a database for custom reporting purposes. Connect SQL Developer to Oracle Database http://www.ReportingGuru.com Email us at [email protected] or call 1-(800) 921-4759.
Views: 101402 Reporting Guru
Using Code Analysis in SQL Prompt
 
01:37
In this Super SQL Tip Redgater Jamie Wallis explains how you can get suggestions to improve as you type with new code analysis rules in SQL Prompt. SQL Prompt is a code completion, code formatting, and refactoring tool for SQL Server. It’ll plug into SQL Server Management Studio or Visual Studio. You’ll find you can work more quickly and accurately with SQL queries, as well as standardize across your team by sharing formatting styles and commonly used SQL snippets. Try it free for 28 days at https://www.red-gate.com/sqlprompt For more tips for writing SQL effortlessly check out the #SuperSQLTips playlist: https://www.youtube.com/playlist?list=PLhFdCK734P8A_q6XHDXi4CQzys3R0Jw3X Transcript: Hi, it’s Jamie Wallis from Redgate software here and I’d like to show you how code analysis works in SQL Prompt. I’m going to use SSMS here, but code analysis is also available Visual Studio. First I’m going to use SQL Prompt tab history to open a query I’ve been working on. As you can see there a now green underlines beneath parts of my code. This indicates that there could be issues that need addressing. When I hover over I can see quick tip about the issue, and when I click the part of the code I am checking is highlighted in green. There is also a new lightbulb icon to the left of my query now, which opens the Issue Details panel when I click on it. Here I can see further information about the issue and how I could fix it. There is also a link to our online documentation which contains further reading about the rules. Finally in this panel I can choose to disable the rule, which stops it displaying in my code. To bring it back I simply click “Enable rule” again. But there is another way to manage your code analysis rules. In the SQL Prompt menu at the top here you can find “Manage code analysis rules”. This opens the code analysis options menu, which gives you the full list or rules available, grouped together into related section. To disable any I just uncheck the box next to the rule, and then press save when I’m done. So there you have it, code analysis in SQL Prompt. You can try it out now by downloading your free-trial from our website. This is Jamie Wallis from Redgate Software. Thank you for watching.
Views: 1136 Redgate Videos
Practice makes it perfect - Patanjali Yoga Sutras part 13 - Swami Mukundananda
 
09:48
We all at some point wish if we could control our mind, but what is the best way to control your mind? How can we successfully control the mind? Our mind is the most powerful tool we have for the creation of good in our life, but if not used correctly, it can also be the most destructive force in our life. Most of us don't realize how often our mind tries to control our lives because it's so habitual and strong. Most other who have tried to control their mind often fail to do so. So is truly possible to control our mind? Or is mind control a myth? Swami Mukundanada answer this question as very the same question was asked by Arjuna to Lord Krishna on the battle field of Kurukshetra some 5000 years ago. Arjuna who had conquered sleep & who had full control over his bodily senses found it impossible to control his mind. Arjuna says in the Bhagavad Gita that the mind is even more fickle than the wind. So how can anyone control such a force? To which Lord Krishna explained, while it is true that mind is extremely volatile however it is not impossible to control it. And the way to it is repeated practice of attaching mind in God & detaching mind from worldly objects . Only by repeated practice one can become master of their mind. Swami Mukundananda further explains, it takes effort to take mind away from worldly objects towards God but it takes no effort to bring it back to the world. So repeated practice of focusing mind in God & detaching it from the world is the sovereign recipe for controlling the mind. ********************************************************************* Buy the complete DVD-set of Patanjali Yoga Sutras here: https://www.jkyog.org/store/ Maharshi Patanjali, one of the six sages who wrote Shad Darshan (the six-philosophical theses,) is a highly regarded Sanskrit scholar with multifaceted dimensions. His Yog Sutras(also known as Yog Darshan) that primarily deals with sadhana or spiritual practices is in the form of sutras. These sutras are “simple yet effective aphorisms that have strung the philosophy,” says Swami Mukundananda ji. The Yog Sutras are not only ancient but also very practical. Modern Psychologists too are discovering its utility in guarding or in regaining mental health. In this preamble to Patanjali Yog Sutras, Swamiji introduces us to one of the primary requisites for spiritual progress, while answering these questions in a lucid manner - Who is Patanjali? What was the purpose of his birth? How did Yog Sutras come about? What are the elements of Yog Sutras?. About Swami Mukundananda: Swami Mukundananda is a renowned spiritual leader, philosopher, visionary, author, and humanitarian.  He is the founder of the yogic system called “JKYog.”  Swamiji is a unique sanyasi (in the renounced order of life), with distinguished degrees in Engineering and Management from two world famous Institutes in India, IIT and IIM.  He is the senior disciple of Jagadguru Shree Kripaluji Maharaj. Swamiji’s enlightening discourses clarify the deepest concepts of the Vedic scriptures with wit, humor, and perfect logic.  Along with his discourses, he teaches the comprehensive system “Yoga for the body, Mind and Soul”.  For the youth, Swamiji has conducted programs at prestigious universities such as Princeton, Stanford, Yale, MIT, Duke and Kellogg School of Management.  He has been invited to speak at various Fortune 500 companies like Google, Oracle, Intel, etc.  For children, he has established a special personality development program, called “Bal-Mukund Character Building Program.” He has inspired millions of people around the world on the path of spirituality, holistic health, yoga, meditation, service to society, and God-realization. Swamiji's warmth and humility touch all those who have had the fortune to have his association. For full profile, visit: https://www.jkyog.org/swami-mukundananda Like us on Facebook/Twitter: https://www.facebook.com/Swami.Mukundananda https://twitter.com/sw_mukundananda Art of Mind Management - Swami Mukundananda - How to control your mind? https://www.youtube.com/watch?v=4oxY10q48nk Patanjali Yoga Sutras By Swami Mukundananda https://www.youtube.com/watch?v=U84rbVi4dVU Bhagavad Gita by Swami Mukundananda in hindi - Kalyan Ka Marg https://www.youtube.com/watch?v=7k2igE8mnpM Bhagavad Gita in English By Swami Mukundananda https://www.youtube.com/watch?v=Zr3hEYRa1vE Why bad things happen to good people? [HANGOUT with Swami Mukundananda] https://www.youtube.com/watch?v=NerDMOdVD8o Bhagavad Gita - The Song of God - Commentary by Swami Mukundananda Read online for FREE : http://www.holy-bhagavad-gita.org/ -~-~~-~~~-~~-~- Please watch: "New Year New You 2018 | How To Recognize A Real Guru? -Swami Mukundananda " https://www.youtube.com/watch?v=Us29NfuF5hA -~-~~-~~~-~~-~- #Swami_Mukundananda #JKYog
Views: 5614 Swami Mukundananda
SQL Prompt column picker
 
01:13
SQL Prompt is a code completion, code formatting, and refactoring tool for SQL Server. It’ll plug into SQL Server Management Studio or Visual Studio. You’ll find you can work more quickly and accurately with SQL queries, as well as standardize across your team by sharing formatting styles and commonly used SQL snippets. Try it free for 28 days at www.red-gate.com/sqlprompt In this tip Data Platform MVP Steve Jones explains how to use SQL Prompt to retrieve just the columns you need in a SELECT statement for speedy results. For more tips for writing SQL effortlessly check out the #SuperSQLTips playlist: https://www.youtube.com/playlist?list=PLhFdCK734P8A_q6XHDXi4CQzys3R0Jw3X Transcript: Hi I'm Steve Jones from SQL Server Central and I've got a SQL Prompt tip for you brought to you by Redgate software. Some of you that use SQL Prompt may not realize you can do this. Often you'll use a select * to get some table details and you know make a quick query on the table and I can do that here, and I realized hey I don't really want all these columns now. Instead of doing the * I can certainly expand the tab but if I know that there are certain columns that I want. You'll see you as soon as I type an O I get a list of columns at the top, as well as other SQL commands that match an O. But the bottom you'll see there's a column picker and then there's a little tip that says control left arrow, so if I hit ctrl left arrow I can actually just see that really what I want to do is go to the column picker and I can pick certain ones and as it says here space to select columns and tab to insert columns. So i'll just hit tab and I've got all these columns inserted. Now when I run my query I only get what I want. Hopefully you'll find this quick tip useful to you. I'm Steve Jones for SQL Server Central and Redgate Software.
Views: 913 Redgate Videos
DB2 Basics Tutorial Part 14 - DB CFG - ALL Parameters
 
47:47
Rest of the DB2 parameters
Views: 1624 db2 nix
Planet Coaster University (P.C.U.) - Paths & Park Entrances
 
15:29
Welcome to the P.C.U.! This tutorial is all about paths and park entrances and covers basic placement all the way to the advanced settings and some pro tips that not everybody knows.
Views: 1562 Sim Park Observer
OATS Troubleshooting #1 - openscript troubleshoot with run diagnosis tool
 
00:48
In this OATS Video tutorial you will solve some of the frequently faced issues, many times you see that openscript is not behaving properly especially when you try to record or playback a script, openscript has given us a beautiful tool which can give insights to troubleshoot and there by the steps to solve them. Openscript troubleshoot starts with running the diagnosis tool, it lists out all the incompatibilities and any necessary steps to solve them. In this video you see that post running the diagnosis tool, i.e. available in help menu - run diagnosis tool, 2 issues are shown, one is firefox version need to be upgraded, second one is rule file for generating xpath for oracle ebs forms is invalid or missing. In the next video you will see how to solve the second issue, it is visible as part of the steps to be done, when we select the error in run diagnosis tool.
Views: 121 testingtools.co
Create Constraints
 
08:49
Creating Constraints up-front with the CREATE TABLE and then identifying the constraint definitions from the data dictionary
Views: 122 Hemant K Chitale
how to create user using sql plus
 
03:51
Oracle Guru Must like share and subscribe. how to create user using sql plus
Views: 119 Oracle Guru
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.
Part 8  Data access in mvc using entity framework
 
13:29
Tags asp.net mvc database tutorial asp.net mvc database application tutorial creating asp.net mvc application with database asp.net mvc database connection using entity framework asp.net mvc database project database connectivity in asp.net mvc Text version of the video http://csharp-video-tutorials.blogspot.com/2013/05/part-8-data-access-in-mvc-using-entity.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-8-data-access-in-mvc-using-entity.html All ASP .NET MVC Text Articles http://csharp-video-tutorials.blogspot.com/p/aspnet-mvc-tutorial-for-beginners.html All ASP .NET MVC Slides http://csharp-video-tutorials.blogspot.com/p/aspnet-mvc-slides.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists The controller responds to URL request, gets data from a model and hands it over to the view. The view then renders the data. Model can be entities or business objects. In part 7, we have built Employee entity. public class Employee { public int EmployeeId { get; set; } public string Name { get; set; } public string Gender { get; set; } public string City { get; set; } } In this video, we will discuss, retrieving data from a database table tblEmployee using entity framework. In a later video, we will discuss using business objects as our model. Step 1: Install entity framework, if you don't have it installed already on your computer. At the time of this recording the latest version is 5.0.0.0. Using nuget package manager, is the easiest way to install. A reference to EntityFramework.dll is automatically added. Open visual studio - Tools - Library Package Manager - Manage NuGet Packages for Solution Step 2: Add EmployeeContext.cs class file to the Models folder. Add the following "using" declaration. using System.Data.Entity; Copy & paste the following code in EmployeeContext.cs public class EmployeeContext : DbContext { // Replace square brackets, with angular brackets public DbSet[Employee] Employees {get; set;} } EmployeeContext class derives from DbContext class, and is responsible for establishing a connection to the database. So the next step, is to include connection string in web.config file. Step 3: Add a connection string, to the web.config file, in the root directory. Step 4: Map "Employee" model class to the database table, tblEmployee using "Table" attribute as shown below. [Table("tblEmployee")] public class Employee { public int EmployeeId { get; set; } public string Name { get; set; } public string Gender { get; set; } public string City { get; set; } } Note: "Table" attribute is present in "System.ComponentModel.DataAnnotations.Schema" namespace. Step 5: Make the changes to "Details()" action method in "EmployeeController" as shown below. public ActionResult Details(int id) { EmployeeContext employeeContext = new EmployeeContext(); Employee employee = employeeContext.Employees.Single(x =] x.EmployeeId == id); return View(employee); } Step 6: Finally, copy and paste the following code in Application_Start() function, in Global.asax file. Database class is present "in System.Data.Entity" namespace. Existing databases do not need, database initializer so it can be turned off. Database.SetInitializer[MVCDemo.Models.EmployeeContext](null); That's it, run the application and notice that the relevant employee details are displayed as expected.
Views: 675757 kudvenkat
DB2 Basics Tutorial Part 11 - DB CFG - Locklist
 
06:49
DB2 Important DB parameters Link to dba convertor : https://play.google.com/store/apps/details?id=in.blogspot.db2nix.dbaconvertor&hl=en App name : aconv
Views: 1570 db2 nix
DB2 Tips n Tricks Part 58 - How To Find Indexes used by Query without getting Explain Plan
 
05:50
How To Find Indexes used by Query without getting Explain Plan Solution: Use MON_GET_SECTION_OBJECT Routine No Need of Explain Tables and Format Explain Output Happy Learning & Sharing
Views: 2792 DB2-LUW-ACADEMY
Flash Player won't play local SWF file: Solution
 
04:08
Adobe updated their Flash Player component and purposely disabled access to local files. This means that the player will not play SWF files that are stored locally unless the SWF file or folder containing it is added to the Trusted Location list. This video presents the problem and the solution. URL for page to check Flash Player version: https://helpx.adobe.com/flash-player.html
Views: 23543 Solstice