Top 10 Protein rich foods for vegetarians
Home Made Peanut Butter, Almonds
Legumes, Skimmed Milk
Soy Chunks, Soy Milk
Panneer, Broccoli
Tofu Panneer, Cheese
Egg whites (If you eat)
SQL*Loader is a powerful and easy way to load data into database tables from external files. We will cover the basics of SQL*Loader with a simple example. STEP 1: Create your table (if not done already) STEP 2: Create folder structure as shown below STEP 3: Create the control file for your table in the folder CTL STEP 4: Prepare your data file as per the format (delimiter etc.,) in your control file in the folder DATA STEP 5: Create the batch file to run SQL*Loader command with required parameters in the folder BATCH STEP 6: Run the batch file and verify the data in the table. STEP 7: Check the log file, bad file and discard for any rejects/errors. Below shown is the folder structure I have for my SQL*Loader. Scroll down for example. EXAMPLE: Step 1: Create a table CREATE TABLE EMPLOYEE ( ID NUMBER(20) PRIMARY KEY, ...
Comments
Post a Comment