In Oracle, you can create an auto increment field using ‘sequence’ database object that can be assigned as primary keys. Using Oracle ‘sequence’ object, you can generate new values for a column. An Oracle sequence is an object like a table or a stored procedure. Examples with walkthrough explanations are provided.
Knowing how to copy existing table data is beneficial to any DBA. This tutorial will demonstrate how to copy an existing table’s data into a new table. Examples with walkthrough explanation are provided.
When you use Skype, you probably use some other third party apps for call recording or faxing to enhance the experiences. If you have stopped using these apps, you should revoke their access to Skype to maintain your privacy.
This guide will explain how to set an Application to run on startup and/or power on. Initially, the default Input is set to run on Power On; we can change this to startup an Application instead.
Amazon gives your Kindle Fire a generic name when you register your device. If you want to change the device name, you will need to go to Amazon’s site to configure it.
If your wireless router uses MAC filtering, you will need to know the Wi-Fi MAC address of your Kindle Fire so that it may connect to the internet.
Do you have a PlayStation 3 and wish you could change the theme on your PS3 without having to buy themes from the PSN? Here’s how you can download and install PS3 theme files from a usb harddrive or thumbdrive.
If you usually have to search for information in a particular website, it is quite handy to do the search directly from the address bar of your browser instead of going to the site and typing in the search box. This tutorial will show you how to do this in Firefox.
If you’ve forgotten the sa password for your SQL server, you are probably in a panic. Fear not, for you can reset the password and once again have access to the powers of the sa account by using the query window in the Management Studio.
Making changes to a database that has been created by a third pary can be a difficult task, especially when you don’t want to break any of the existing stored procedures. You can search the database’s stored procedures for keywords to find which procedures use a keyword that is involved in your change. This makes it much easier in identifying these procedures so you can make the appropriate changes.
If you’re running SQL Server, it’s very wise to make sure that you have the latest service pack installed for optimum performance. If you’re not sure what service pack you have installed (or if you’re still running RTM), follow these steps to find out:
A trigger allows for the execution of SQL code anytime an UPDATE, INSERT, or DELETE command is performed on a certain table. If you are having to perform manual modifications to the table, you may not want the trigger to fire off. Here’s how to disable the trigger so that you can perform your administrative tasks:
1...333334335...502Page 334 of 502 error: Content is protected !!
