install oracle developer suite 10g in windows
without oracle database can i install oracle developer suite 10g in windows
without oracle database can i install oracle developer suite 10g in windows
5 pts.
Subtracting two Julian Dates
I am very new to this position with limited knowledge. I would like to know how we can subtract two JULIAN dates in ORACLE. I have "ADMIT_DDT" and "DISCHARGE_DDT". Each of these dates consist of 10 digit number. I know first 5 numbers represent DATE and last five TIME. I would like to know to how...
I am very new to this position with limited knowledge. I would like to know how we can subtract two JULIAN dates in ORACLE. I have "ADMIT_DDT" and "DISCHARGE_DDT". Each of these dates consist of 10 digit number. I know first 5 numbers represent DATE and last five TIME. I would like to know to how...
media recovery
Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as "need media recovery". Please Guide me....
Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as "need media recovery". Please Guide me....
Count Distinct Rows on Multiple Columns
I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane ...
I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane ...
XML Publisher with Shipping Docs
We are trying to use rtf Templates for our shipping docs. When we launch the concurrent request individually they work great. But when we use Ship confirm (which launches the doc set automatically) the xml is generated but the pdf format is not. Looking at the submitted requests, the layout has...
We are trying to use rtf Templates for our shipping docs. When we launch the concurrent request individually they work great. But when we use Ship confirm (which launches the doc set automatically) the xml is generated but the pdf format is not. Looking at the submitted requests, the layout has...
XML Publisher Issue
We can't output a concurrent request via XML Publisher... We can create data definitions and link data templates (.rtf files) through the app, when we attach a data.xml preview file, we can preview the output correctly. When we actually attempt to run the concurrent request, the output shows the...
We can't output a concurrent request via XML Publisher... We can create data definitions and link data templates (.rtf files) through the app, when we attach a data.xml preview file, we can preview the output correctly. When we actually attempt to run the concurrent request, the output shows the...
Executing a Function or Procedure from ouside Oracle
I have verified the code below as a valid Function and it executes from TOAD. It does not work if called from: SELECT F_T_TOTALE_TO_T_SCRAP_SC(V_TIRE_ID_EXTRACT) FROM T_TOTALE The Error is 14551. I have researched this error and it states that a function cannot be executed from a SELECT statement...
I have verified the code below as a valid Function and it executes from TOAD. It does not work if called from: SELECT F_T_TOTALE_TO_T_SCRAP_SC(V_TIRE_ID_EXTRACT) FROM T_TOTALE The Error is 14551. I have researched this error and it states that a function cannot be executed from a SELECT statement...
Table not using index
Good day, I have a table containing 4 billion records and adding 7 million records per day, working with a date and timestamp. Currently the table is created with a date (charging_date) and a timestamp (named timestamp but with format varchar2(6) - i.e. '065000' for 06H50 AM). I created a new...
Good day, I have a table containing 4 billion records and adding 7 million records per day, working with a date and timestamp. Currently the table is created with a date (charging_date) and a timestamp (named timestamp but with format varchar2(6) - i.e. '065000' for 06H50 AM). I created a new...
Urgent Help: web-Forms 6i don't work after Upgrading the db from 8i to 10g
Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B. The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we're using now for the server B the alias we've used for the server C....
Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B. The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we're using now for the server B the alias we've used for the server C....
help! - - - trigger compilation error when calling a stored procedure.
my trigger wont compile. below is the code and errors. Any help is greatly welcomed. thanks very much. DECLARE ROWCNT NUMBER; PIN NUMBER; SIGNUP_URL VARCHAR; -- -- BEGIN SIGNUP_URL := 'http://signup.2gn.com/signup.pl'; SELECT COUNT(*) INTO ROWCNT FROM SUBSSHORTCODE WHERE SHORT_CODE...
my trigger wont compile. below is the code and errors. Any help is greatly welcomed. thanks very much. DECLARE ROWCNT NUMBER; PIN NUMBER; SIGNUP_URL VARCHAR; -- -- BEGIN SIGNUP_URL := 'http://signup.2gn.com/signup.pl'; SELECT COUNT(*) INTO ROWCNT FROM SUBSSHORTCODE WHERE SHORT_CODE...
please solve this query
Create Emp table containing an Empno column with the following sample data:- EMP ------- EMPNO ----------- 1 5 9 14 20 25 Write a SELECT statement to display the range of missing numbers. Your output should be as follows:- MISSING ------------ 2 ?- 4 6 ?-8 10 ?- 13 15 ?- 19 21 ?- 24 Don?t...
Create Emp table containing an Empno column with the following sample data:- EMP ------- EMPNO ----------- 1 5 9 14 20 25 Write a SELECT statement to display the range of missing numbers. Your output should be as follows:- MISSING ------------ 2 ?- 4 6 ?-8 10 ?- 13 15 ?- 19 21 ?- 24 Don?t...
HELP : I retrieve a blank page with UTL_HTTP in a request to a server which listen in a different Port than 80
Dear colleagues I have a problem because a developer form our team, has a problem to retrieve a webpage in Oracle Portal whit UTL_HTTP. If he attempts to retrieve a webpage (pending to Oracle Portal) by a PACKAGE whit the next sentence: URL_TABLE := utl_http.request_pieces(p_website, 99999,...
Dear colleagues I have a problem because a developer form our team, has a problem to retrieve a webpage in Oracle Portal whit UTL_HTTP. If he attempts to retrieve a webpage (pending to Oracle Portal) by a PACKAGE whit the next sentence: URL_TABLE := utl_http.request_pieces(p_website, 99999,...
Running a script at specified runtime
I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime? Thanks
I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime? Thanks
Oracle Reference to Table_Name, Column_Name, etc by reference to variable
Does Oracle prohibit reference to Table_Name, Column_Name, etc by reference to a declared variable? I am trying to create a simple routine to print documentation whenever any changes are made to the database using the following routine: DECLARE CURSOR Table_cursor is SELECT * FROM...
Does Oracle prohibit reference to Table_Name, Column_Name, etc by reference to a declared variable? I am trying to create a simple routine to print documentation whenever any changes are made to the database using the following routine: DECLARE CURSOR Table_cursor is SELECT * FROM...
Oracle ODBC Drivers from Oracle vs. Microsoft
I am wrestling with whether Microsoft products (e.g., Excel-MS Query) that use ODBC to access Oracle databases would benefit more by using the latest driver from Oracle or Microsoft. If using a driver from Microsoft, is it likely to be significantly less efficient in exploiting the latest features...
I am wrestling with whether Microsoft products (e.g., Excel-MS Query) that use ODBC to access Oracle databases would benefit more by using the latest driver from Oracle or Microsoft. If using a driver from Microsoft, is it likely to be significantly less efficient in exploiting the latest features...
inserts through a database link
Hello every body. Here I go again... Do you know if there is a restriction about performing inserts through a database link ? We are experiencing the following situation: We have two Oracle 8i instances running on a win 2k3 server, and a Forms applications needs to insert data from one instance...
Hello every body. Here I go again... Do you know if there is a restriction about performing inserts through a database link ? We are experiencing the following situation: We have two Oracle 8i instances running on a win 2k3 server, and a Forms applications needs to insert data from one instance...
Difference between length and vsize functions
Hi I have got same results for both the vsize and length functions. Why the two functions are giving the same result? Can any one clarify this? Thanks in advance, Regards, P. Karthik
Hi I have got same results for both the vsize and length functions. Why the two functions are giving the same result? Can any one clarify this? Thanks in advance, Regards, P. Karthik
Configuring isql *plus
Hi, I want to configure isql *plus in my oracle server. Can any one give me the configuration steps to invoke the isql * plus in my oracle server. Thanks in advance, Regards, P. Karthik
Hi, I want to configure isql *plus in my oracle server. Can any one give me the configuration steps to invoke the isql * plus in my oracle server. Thanks in advance, Regards, P. Karthik
Using optimizer hints in Forms
Hello everybody. A few weeks ago I posted a question about Sql Tuning in Oracle, and I have been experimenting with optimizer hints and execution plans (all this in Sql Plus), but now, a doubt arises to me. Can I use the optimizer hints in Forms 6i (program units or triggers) ? Since they look like...
Hello everybody. A few weeks ago I posted a question about Sql Tuning in Oracle, and I have been experimenting with optimizer hints and execution plans (all this in Sql Plus), but now, a doubt arises to me. Can I use the optimizer hints in Forms 6i (program units or triggers) ? Since they look like...
