 Related Questions How to store a bitmap or jpeg file on oracle database?which datatype is used and what is the retrival method ? Hi,I have scenario where I need to upload data from XML file into a table. XML file is a predifined format. How can I achieve this, Is there any built in package similar to SQL loader to extract required field values and upload them into table.Pls suggestThanks Read Answers (2) | Asked by : vishnu Latest Answer : Hi Friend,Here is simple defination initSID.ora will tell you SID is the database name where you are going to creating a new database.when you create database it'll take you as pfile and spfile is the system parameter file which you can convert if you ... Hai i have installed oracle 10g on my system.and it shows that Pro C has also been installed but i am not getting any access to PRO C i.e i am not getting PRO *C UI(user interface) .how to access or start PRO C UI. please help me out.also i installed Oracle HTTP server and oracle companion products on my system but but i am unable access HTML DB. on what port numnber it will be accessible .also need help how to access text file in oracle,pl/sqlplease helpits urgent.prabhash I have win xp having oracle 9.2 and on same system win 2k having oracle 9.0. can I share data , redolog and control file . if yes then how? please give example. as per me its just not possible. Hi All, How do i run the otrcsvr.sql file in Oracle9i, it is suppose to be available in @$ORACLE_HOME/rdbms/admin; But its is not present in that folder. Can i use another script on Oracle 9i to achieve the same ?Regards,Ashish Tags : RDBMS Is there any way to import the excel data in to oracle database without using the SQL loader, please let me know. Latest Answer : Well,if you have less data ,you can just copy the data; for exampleselect * from table for update then open the lock, then copy the data from excel to the database; ... How to determine whether particular parameter of parameter file is static or dynamic? Latest Answer : In v$parameter we can find one column ie. ISSYS_MODIFIABLE. This column
contains three phases 1) Immediate 2) DEFERRED 3) False
1. Immediate : We can change the parameter in fly database ie Dynamic.
2. DEFERRED : We can change the parameter in fly ... How do you send the output of your SQL* Plus session to a text operating system file Latest Answer : well you want to see the output ina text file............this can be done by spooling the data;for example..you want to see the output of the details of all employees:do the following steps:spool c:satya.txt/select * from emp/spool off;now you can ... What parameter must be set in init.ora file for utl_file package?
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
