clearing the contents of file on unix machine

hi all,
if u want to clear the content of file on unix machine like solaris or linux u can do this using following command
>filename

loading csv files into database tables

hi friends,

if u have files like excel,notepad,.dat ,.csv that u want to load in database tables especially in oracle then u can follow the following procedure
1. first save the file in .csv format
2. then create a table in the target database of same credentials like in file.
3. then make a control file containing code of loading the data in table.
4.then both the control file and .csv file save it at same location.
5.open the command prompt run the sql loader command .
i am giving an example .....
first the .csv format file like below

then create a table using sql commands to create a table,
then make a control file like below to load the data

and save it as.ctl file
and finally using sql loader command in command prompt
c:> sqlldr scott/tiger@orcl control=c:\book.ctl data = c:\book.csv
it will load the data in table

Thanks and regards
Ankur Gupta

running oracle forms 10g on browser

hi friends,
if u r running oracle forms 10g on browser in windows vista, 2003 server then it will not run it will close the browser itself. for this to run u have to use sun jpi instead of jinitiator.
what u have to do is ....
In formsweb.cfg file change the value of basehtml,baseHTMLjinitiator,basehtmljpi to "basejpi.htm" and save it . then u can run it otherwise in windows xp u can run it using jinitiator.

for any queries u can contact me at : akshay35563@gmail.com

Regards
ankur gupta

quotes

more Quotes