Random Nerd Stuff

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,  ...

Touching deep quotes on life, love & motivation                                                                            PART 2

Deep quotes on life, motivation & love                                                                           PART 1

Windows Tips to view hidden files and file extensions View hidden Files            Go to file explorer and navigate to the desired folder.            Click on ‘View’ from the menu.            Click on the checkbox ‘Hidden Items’       2. View File Extensions            Go to file explorer and navigate to the desired folder.            Click on ‘View’ from the menu.            Click on the checkbox ‘File Name Extensions’