i can log on sqlplus useing : sqlplus “sys/oracle as sysdba” but on em log on: user : sys password : oracle give me error msg “invalid passowrd”
SET HEADING OFF; SELECT ‘Song Name: ‘, S.TITLE FROM SONG S I don want to display heading in the result table. I need result like: Song Name: Mungaru Male Song Name: Titanic Song Name: Milana But the Statement “SET HEADING OFF;” results in a result
Rename username in oracle 10g database without droping it
I hava created a column like: create table pen(no integer, name varchar(30)) It contains the following data: NO NAME 1 reynolds 2 [...]
wat is the difference between SYS and SYSTEM users in ORACLE?
In Oracle database- Assume that I have logged in as “jaga”(user name). can I use the user name “jaga” with the table name to refer a column. example : select jaga.emp.name from emp where age>100 here jaga is schema name(user name), emp is the table name and name is the column name. can i use [...]
I m using Oracle 10g Express Edition. when i type and execute the command COMMIT, I got the following error: “Commit statement not applicable. All statements are automatically committed.” please help me to get out of this.
I installed Oracle for Vista and when the enterprise manager screen came up I entered my username and password but it kept telling me it was incorrect. I closed out the web site, did a few things and came back. When I went to the Oracle Enterprise Manager again the page would not load and [...]
I connected vb6 to oracle 10g using ADODC…can u tell me how to connect data reports using 10g?
Does anyone have experience of translating the german table/column names in a SAP /Oracle database
Hi, I downloaded Oracle Database 10g Express Edition from Oracle site and i successfully installed in my system but while login i showed an error like “could not establish connection by network card” Please suggest me “how to install it”.
how to remove default window1 in 10g forms?
im new in oracle forms and i want to enter the industry number and when i press the retrieve button, name and surname must display, can you help.
I have two html files one is a template with certain data that must be transferred to the output file and the other file is also an html file which contains the most data that must be transferred to the same out put file. I have tried to write from both files to the output [...]
hello friends this is avishek behera.. recently i installed oracle 10g database software only in windows 7. after that i tried to create a database.. but i got an error like oermission denied.. i have installed in d drive which is not my system drive and also installed with administrator previlage “run as administrator”. still [...]
kindly provide me with details steps, as i will upgrade over 50 servers. what i am doing in three sites: 1) build temp server with same version. 2) uninstall Application. 3) uninstall 9i. 4) dis-join domain. 5) install Oracle 10g. 6) join domain mandatory for my application. 7) install my application. 8) imp sys/XXX@XXX file=xx.dmp [...]
i have a form c that operates a report report1 by using the following code: declare repid REPORT_OBJECT; v_rep VARCHAR2(100); rep_status VARCHAR2(20); BEGIN repid := FIND_REPORT_OBJECT(‘REPORT1′); if :global.struc_code=51 then SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,’p_year=’||:yy||’ paramform=no’); SET_REPORT_OBJECT_PROPERTY(repid, REPORT_server, ‘rep_app_oracle_forms’); SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESFORMAT, ‘htmlcss’); v_rep := RUN_REPORT_OBJECT(repid); rep_status := REPORT_OBJECT_STATUS(v_rep); WHILE rep_status in (‘RUNNING’,'OPENING_REPORT’,'ENQUEUED’) LOOP rep_status [...]
while i dumping one field in oracle i get result like this.. dump result : Typ=1 Len=7: 77,65,82,46,44,48,57 field : MAR.,09 so i try replace commond to avoid this ‘,’….then see dump for taht field again…. but still same dump result come…i dont know why??/please help me to solve this problem…
hello sir/mam i have a linux server loaded with oracle 10g with so many databses. i want other windows systems to access the databases of server through oracle 10g. could u please explain me in detail how to make this set up.
I have oracle 10g as the database and front-end. When I run my application in 2 different windows and run a report in one of the windows, the other goes blank until the report is finished running. Any ideas why? Appreciate your help.





