Skip to main content
Home
Paul's Linux Box

Main navigation

  • Home
  • Contact
User account menu
  • Log in
By Paulus, 23 February, 2007

More Database Objects

A database object is anything that has a name and a defined structure. Other database objects that are used in Oracle 10g are sequences, indexes, and synonyms.

  • Read more about More Database Objects
By Paulus, 19 February, 2007

Manipulating Data and Transaction Control

The keywords that Manipulate data and control transactions are called Data Manipulation Language or DML. With out the DML a database would be useless and a waste.

Inserting Data

Syntax INSERT INTO tablename [(columnname, ...)] VALUES (datavalue, ...); When inserting data if you are inserting a full row of data, placing data in all columns then you can omit the column names as long as you follow the order of the columns in the table.
  • Read more about Manipulating Data and Transaction Control
By Paulus, 14 February, 2007

Oracle Constraints

Constraints are used to keep accurate data. In oracle you can apply these policies to a column or table. There are five different types of constraints:
Constraint Abbreviation Description
PRIMARY KEY _pk This is a unique field that is not allowed to have null values.
FOREIGN KEY _fk This constraint is placed in the "many" table.
  • Read more about Oracle Constraints
By Paulus, 14 February, 2007

Creating and Managing Tables in Oracle 10g

When creating tables in Oracle we have to follow some rules in order to successfully create a table:

  • Read more about Creating and Managing Tables in Oracle 10g
By Paulus, 7 February, 2007

Multibooting with Vista

With every new operating system comes headaches as we find that our favorite programs or hardware no longer works with it. If you're like me, you're probably being forced into using Windows because everyone else does. Then again, if I had Linux installed on my box along side Vista, I'd feel a bit dirty and I'd be using a real boot loader like GRUB. In Vista Microsoft did away with the ntldr.exe and boot.ini files and replaced it with a new program.

  • Read more about Multibooting with Vista

Pagination

  • First page
  • Previous page
  • …
  • Page 7
  • Page 8
  • Page 9
  • Page 10
  • Page 11
  • Page 12
  • Page 13
  • Page 14
  • Current page 15

Recent content

  • SMART Alerts with msmtp and curl
    2 weeks ago
  • Debugging Laravel Apps with Laradock and XDebug
    2 months ago
  • Sending HTTP Requests Through a Proxy in Laravel
    2 months ago
  • Setting up a Kubernetes Cluster
    6 months ago
  • Mounting Raw Disk Images
    9 months ago
  • Updating Gentoo
    9 months ago
  • Consuming Web Services
    1 year 4 months ago
  • Borg Backup
    2 years ago
  • Laravel Administration Panels
    2 years ago
  • Drupal 8 Local Development
    2 years 3 months ago
RSS feed
Powered by Drupal