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
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
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?
