Read Online or Download Oracle 9i SQL Reference (8) PDF
Similar databases books
It doesn't matter what DBMS you're using—Oracle, DB2, SQL Server, MySQL, PostgreSQL—misunderstandings can continually come up over the fitting meanings of phrases, misunderstandings which may have a major impression at the luck of your database tasks. for instance, listed below are a few universal database phrases: characteristic, BCNF, consistency, denormalization, predicate, repeating workforce, sign up for dependency.
Extra resources for Oracle 9i SQL Reference (8)
The data reports use these Command objects. To use this scenario, first a data environment was added to your Visual Basic project. You do this by selecting Project | More ActiveX Designers | Date Environment from the Visual Basic menu. When you do that, a data environment is added to your project. Figure 5-7 shows the data environment used in this Visual Basic application. Figure 5-7: Data environment If you select the Data Environment object in this tree view and press F4, you can view the properties for the object.
CREATE PROCEDURE CategoryAdd @CategoryName varchar(50) AS Declare @IsInUse integer Select @IsInUse = Count(CategoryID) from Categories Where CategoryName = @CategoryName If @IsInUse = 0 BEGIN Insert Into Categories (CategoryName) values (@CategoryName) Select @@Identity as TheNewID END Else BEGIN Select 0 as TheNewID END GO The procedure requires a single parameter. The name for the new category: @CategoryName varchar(50) You will also need a local variable: Declare @IsInUse integer which is set to the number of occurrences that the category name supplied is found in the Categories table: Select @IsInUse = Count(CategoryID) from Categories Where CategoryName = @CategoryName Brought to you by ownSky!
When they do that, the record is added to the grid, the balance is updated, and the total number of transactions is updated. Each of the entries made belongs to a particular category. The combo box on the form allows the user to select from this fixed list. If the user wanted to add a new category, they press the Add Category button. When they do that, they see the dialog box displayed in Figure 4-3. Figure 4-3: Add Category dialog box If the user enters a category that does not yet exist, the category is added to the Categories table and the new category becomes part of the combo box so that the user can select it.