Pages: 2
Rating : ⭐⭐⭐⭐⭐
Price: $10.99
Page 1 Preview
the default password manager system you are logged

The default password manager system you are logged


Chapter 3

If you are loading into a different database, do this as follows:

>imp scott/tiger@SAMPLE_DB doyouxml.dmp

Hello, XSQL! 37

Now that the demos provided by Oracle are in place, we are going to get started on the example that we will use for the rest of the book. As discussed in Chapter 1 our sample application is an online catalog. In this section, you will create our example user and a single table using SQL*PLUS. In the next section, you will create a connection defini-tion that accesses the database as this user. From there, you will create your first XSQL application using the data in the table that you create here.

You will create the MOMNPUP user for our client company, Mom N’ Pop Retail. Oracle gives you a huge amount of flexibility in creating users. Among other things, you can specify the default tablespace, the temporary tablespace, the quota, the user’s profile, and the rollback segment. For this exercise, we will create the user as simply as possible. You should consult your administrator’s guide for in-depth information about all of the different options.


Now that the user is created, log out and log back in as the user:

firstname VARCHAR2(15),

job VARCHAR2(30));


You are viewing 1/3rd of the document.Purchase the document to get full access instantly

Immediately available after payment
Both online and downloadable
No strings attached
How It Works
Login account
Login Your Account
Place in cart
Add to Cart
send in the money
Make payment
Document download
Download File

Uploaded by : Gloria Rodriguez