what is sql*loader parameters and where we will use it.
Answer / arijitnit
sql*loader is a bulk importing tool to import data tables
present in various formats like CSV.
We have to define a control file and in it we have to give
some commands.
LOAD DATA
INFILE *(this assumes data is in the same ctl file)
INTO TABLE TABLE_NAME(COLUMNS)
FIELDS TERMINATED BY ;
BEGIN DATA
...DATA IN CSV FORMAT
now in command prompt type sqlldr USERID=scott/tiger
CONTROL=test.ctl
| Is This Answer Correct ? | 7 Yes | 0 No |
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
0 Answers Punjab National Bank,
What is store procedure?and how do u take the values from database and run in scripts?
Difference between transaction type and transaction sources. : oracle accounts receivable
Why more redos are generated when the oracle database is in begin backup mode?
how can it possibble to see the report output in excel sheet in oracle applications
What is an Oracle database Partial Backup?
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
What do you mean by hz_ in customer tables? : oracle accounts receivable