⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 db7setup.html

📁 LOB objects for oracle database,inserting them to database
💻 HTML
字号:
🔍 
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
<head>
   <meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
   <meta name="Author" content="Reghu">
   <meta name="GENERATOR" content="Mozilla/4.51 [en] (WinNT; I) [Netscape]">
   <title>Databse setup</title>
</head>
<body>
<b><u><font face="Arial,Helvetica"><font color="#000099"><font size=+2>INSTRUCTIONS
FOR SETTING UP DATABASE TABLES REQUIRED BY THE OLEDB SAMPLES</font></font></font></u></b>
<p>This file explains the procedure to setup the&nbsp; tables used in the
OraOLEDB samples.
<p><b><u><font color="#000099"><font size=+1>To Create a New Database User</font></font></u></b>
<p><b>Step 1</b>. Connect to SQL*plus as a user with DBA priviliges eg.
system/manager@&lt;connect string>
<p><b>Step 2</b>. Execute
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <i>syntax</i>:
SQL> CREATE USER &lt;username> IDENTIFIED BY &lt;password> DEFAULT TABLESPACE
&lt;tablespace name>;
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <i>eg</i>.
SQL> CREATE USER Oraole&nbsp; IDENTIFIED BY Oraole DEFAULT TABLESPACE users;
<p><b>Step 3</b>. Grant privileges to the user created
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <i>syntax:

</i>SQL> GRANT CONNECT, RESOURCE&nbsp; TO &lt;username>;
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <i>eg:&nbsp;</i>
SQL> GRANT CONNECT, RESOURCE TO oraole;
<p><b><u><font color="#000099"><font size=+1>To Create Database Tables
Required for the OLEDB Samples</font></font></u></b>
<p><b>Step 1. </b>Connect to SQL*Plus using &lt;username>/&lt;password>@&lt;connect
string>
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
eg. Oraole/Oraole@mydatabase
<p><b>Step 2.</b> Execute&nbsp; SQL> @&lt;path>Ora7OLEDBScript.sql
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
This script should create the following tables with primary keys:
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
a) Supplier
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
b) Orders
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
c) Product_Information
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Foreign
key ORDERS_SUPPLIER_FK for Orders to Supplier table is also created.
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
The data also gets inserted in the above tables.
<p><b>Step 3</b>. To verify whether tables have been successfully created.
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
execute&nbsp;&nbsp; SQL> SELECT * FROM tab;
<br>&nbsp;
<br>&nbsp;
<br>&nbsp;
<br>&nbsp;
<br>&nbsp;
<br>&nbsp;
<br>&nbsp;
<br>&nbsp;
<br>&nbsp;
<br>&nbsp;
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -