Oracle sql and compare date
Hello! I need help. I want to compare two dates and count how many days its between them. ex. 2006-09-22 and 2006-10-06 resulst: 14 days Hope fore help. //Lin
Hello! I need help. I want to compare two dates and count how many days its between them. ex. 2006-09-22 and 2006-10-06 resulst: 14 days Hope fore help. //Lin
0 pts.
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...
ORA-12535
My database runs on 9i.There are remote databases that connected to it.Today all of them are failing to connect because of the error message ora-12535.I increased the CONNECT_TIMEOUT but error still persists.I even set it to zero (0) and the system hangs indefinately.tnsping to these remote...
My database runs on 9i.There are remote databases that connected to it.Today all of them are failing to connect because of the error message ora-12535.I increased the CONNECT_TIMEOUT but error still persists.I even set it to zero (0) and the system hangs indefinately.tnsping to these remote...
VB.Net of Visual Studio.Net 2003 VS Visual Basic 2005 Express Edition
Good Day! Would be appreciate if there is solution for the following problem: - In VB.Net of Visual Studio.Net 2003, developer can click and drag a table listed in the Server Explorer from a connected database to the form. This will add OleDbConnection control and OleDbDataAdapter control to the...
Good Day! Would be appreciate if there is solution for the following problem: - In VB.Net of Visual Studio.Net 2003, developer can click and drag a table listed in the Server Explorer from a connected database to the form. This will add OleDbConnection control and OleDbDataAdapter control to the...
sql update command to update certain digits in a row of a column with VARCHAR2(9) DATATYPE.
Please I need an sql command that I can use to update only the fourth and fifth digits in a particular column in an Oracle 9i database.The column has a VARCHAR2(9) datatype.My oracle database is on windows 2003 environment. Eg: The row in question reads '063150987' and I want to replace the fourth...
Please I need an sql command that I can use to update only the fourth and fifth digits in a particular column in an Oracle 9i database.The column has a VARCHAR2(9) datatype.My oracle database is on windows 2003 environment. Eg: The row in question reads '063150987' and I want to replace the fourth...
problem in installing the second oracle home
Hi all, Iam having problem in installing the second Oracle_Home to install my SAP Test server , iam already having one Oracle_Home configured which is for my development server on the same box which should not be disturbed. In the Oracle Universal Installer iam giving the Oralce_Home and the path...
Hi all, Iam having problem in installing the second Oracle_Home to install my SAP Test server , iam already having one Oracle_Home configured which is for my development server on the same box which should not be disturbed. In the Oracle Universal Installer iam giving the Oralce_Home and the path...
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
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
Oracle 9i Reports Developer
I'm trying to open the Reports Builder 9i on my Windows XP Prof. SP1. The problem is that I can see the Reports Builder Start Screen and thats all. It always hangs at that point. I can open Oracle Forms Builder and everything else in the Developer Suite.
I'm trying to open the Reports Builder 9i on my Windows XP Prof. SP1. The problem is that I can see the Reports Builder Start Screen and thats all. It always hangs at that point. I can open Oracle Forms Builder and everything else in the Developer Suite.
Import utility in Oracle
When importing a table (as a means of restoring), and specify ROWS = Y, does the data in the table get overridden?
When importing a table (as a means of restoring), and specify ROWS = Y, does the data in the table get overridden?
time-based & change-based recovery
i was reading abt these methods of recovery. In classrooms, the lecturer always simulate this sort of recovery by noticing the time (for time-based recovery), or the log seq# (for changed-based recovery). In reality, there will always be careless users who deleted a record they shldnt and now...
i was reading abt these methods of recovery. In classrooms, the lecturer always simulate this sort of recovery by noticing the time (for time-based recovery), or the log seq# (for changed-based recovery). In reality, there will always be careless users who deleted a record they shldnt and now...
Configuring OEM to access Oracle on 2 systems
Background: oracle_sid=opteldb runs on win2k v9.2.0 (IP=10.201.132.40) oracle_sid = GLDBWH runs on solaris 2.6 v8.1.7(IP:10.201.135.101) OEM is configured on win2k (client platform--not the oracle win2k server). I now can access opteldb and tnsnames.ora is configured with opteldb (stored in...
Background: oracle_sid=opteldb runs on win2k v9.2.0 (IP=10.201.132.40) oracle_sid = GLDBWH runs on solaris 2.6 v8.1.7(IP:10.201.135.101) OEM is configured on win2k (client platform--not the oracle win2k server). I now can access opteldb and tnsnames.ora is configured with opteldb (stored in...
Trying to solve ORA-00980: synonym translation is no longer valid
I ran the catalog.sql script on my Enterprise DB in preparation for exporting a schema from my Oracle 9i version 9.2.0.1.0 Enterprise DB with an Enterprise Manager Server and Intelligent Agent to an Oracle 9i version 9.0.1.1.0 Personal Edition DB(Each DB running on separate PCs in my LAN). I ran...
I ran the catalog.sql script on my Enterprise DB in preparation for exporting a schema from my Oracle 9i version 9.2.0.1.0 Enterprise DB with an Enterprise Manager Server and Intelligent Agent to an Oracle 9i version 9.0.1.1.0 Personal Edition DB(Each DB running on separate PCs in my LAN). I ran...
Tablespace recovery
Q1: How do i find out which datafile i need to recover when doing a tablespace recovery? Is it thru V$DATAFILE? Will oracle indicate this? Q2: Under which circumstances shld i consider recovering a datafile / a tablespace? It seems that i could recover a tablespace by just recovering a datafile...
Q1: How do i find out which datafile i need to recover when doing a tablespace recovery? Is it thru V$DATAFILE? Will oracle indicate this? Q2: Under which circumstances shld i consider recovering a datafile / a tablespace? It seems that i could recover a tablespace by just recovering a datafile...
Email alerts and export report to Excel
I'm running oracle9.2 on win2k. I need to do the following: 1) Run a script to monitor my storage percentage,number of extents of a tablespace, free space. After which i need to email this report to myself via MS outlook so that i have a record of this. The email shld be on a daily basis. This is...
I'm running oracle9.2 on win2k. I need to do the following: 1) Run a script to monitor my storage percentage,number of extents of a tablespace, free space. After which i need to email this report to myself via MS outlook so that i have a record of this. The email shld be on a daily basis. This is...
Naming Constraints and Moving Tables
Hi i hv started on Oracle9.2 running on win2k. A consultant we hired wrote all the shop floor programs and define all the tables, indexes, constraints. He also define for us the database config (init.ora). Because he is more into programming, i need to "clean-up" his act 1)Move all my uses even...
Hi i hv started on Oracle9.2 running on win2k. A consultant we hired wrote all the shop floor programs and define all the tables, indexes, constraints. He also define for us the database config (init.ora). Because he is more into programming, i need to "clean-up" his act 1)Move all my uses even...
Oracle ./runInstaller problem
Dear Oracle Experts, I came across the following problem when trying to update my Oracle 9.2 to Oracle 9.2.0.4 When I typed > ./runInstaller for the Oracle 9.2.0.4 patch. I get the following error. "You do not have permission to write to the inventory /oracle/product/db/920/$ORACLE_HOME....
Dear Oracle Experts, I came across the following problem when trying to update my Oracle 9.2 to Oracle 9.2.0.4 When I typed > ./runInstaller for the Oracle 9.2.0.4 patch. I get the following error. "You do not have permission to write to the inventory /oracle/product/db/920/$ORACLE_HOME....
what is the best STORAGE solution for ORACLE db - SAN or NAS ?
one of my project is very critical for the client . the application will run in 10 different sites . the infrastructure of each site will be : 4 linux servers (2 for ORACLE DB , 2 for websphere) + 1 linux/win server for backup software + DB oracle (~100GB) + storage. i have a very good experience...
one of my project is very critical for the client . the application will run in 10 different sites . the infrastructure of each site will be : 4 linux servers (2 for ORACLE DB , 2 for websphere) + 1 linux/win server for backup software + DB oracle (~100GB) + storage. i have a very good experience...
