Oracle 10g date column
That is not a command that would run on Oracle. There is no DATETIME data type in Oracle, and trying to cast a date to a float would produce an error. This is probably from SQL Server, and the goal of the command I suppose is to remove the time portion of the datetime column. [...]
View Answer
| December 21, 2010 3:38 PM
Oracle 10g, Oracle 10g administration, Oracle 10g Express, Oracle administration
That is not a command that would run on Oracle. There is no DATETIME data type in Oracle, and trying to cast a date to a float would produce an error. This is probably from SQL Server, and the goal of the command I suppose is to remove the time portion of the datetime column. [...]
View Answer
| December 21, 2010 3:38 PM
Oracle 10g, Oracle 10g administration, Oracle 10g Express, Oracle administration
SOLAP in SQL 2008R2
I do not think that there is. Check the Microsoft.com/sql website for a full feature list. You may also wish to wait and see what will be release in the next release which is code named “Denali”.
View Answer
| December 20, 2010 4:45 AM
GEOSpatial, Oracle OLAP, SQL Server 2008, SQL Server 2008 R2, Windows Server 2008, Windows Server 2008 R2
I do not think that there is. Check the Microsoft.com/sql website for a full feature list. You may also wish to wait and see what will be release in the next release which is code named “Denali”.
View Answer
| December 20, 2010 4:45 AM
GEOSpatial, Oracle OLAP, SQL Server 2008, SQL Server 2008 R2, Windows Server 2008, Windows Server 2008 R2
Is their any conflict between Oracle 8i and Windows 2003 Server
There were some issues with some specific versions and hardware combinations. This could be the solution in most cases: -Copy the CD files to a local drive -Search and rename this file: symcjit.dll (rename it to symcjit.dll.old or something else) -Open the oraparm.ini file (\install\oraparam.ini) -Look for the JRE_MEMORY_OPTIONS parameter and replace it with “JRE_MEMORY_OPTIONS= [...]
View Answer
| December 15, 2010 11:23 PM
Oracle 8i, Oracle installation, Windows Server 2003
There were some issues with some specific versions and hardware combinations. This could be the solution in most cases: -Copy the CD files to a local drive -Search and rename this file: symcjit.dll (rename it to symcjit.dll.old or something else) -Open the oraparm.ini file (\install\oraparam.ini) -Look for the JRE_MEMORY_OPTIONS parameter and replace it with “JRE_MEMORY_OPTIONS= [...]
View Answer
| December 15, 2010 11:23 PM
Oracle 8i, Oracle installation, Windows Server 2003
install oracle developer suite 10g in windows
Sure you can, provided you have a database server you can connect to (well, you don’t really need a server to install Developer, but you will need it to design your forms). Developer includes basic database client software. If necessary, you can download an Express edition of the database, which would be free.
View Answer
| December 15, 2010 11:21 PM
Oracle 10g, Oracle developers, Oracle development
Sure you can, provided you have a database server you can connect to (well, you don’t really need a server to install Developer, but you will need it to design your forms). Developer includes basic database client software. If necessary, you can download an Express edition of the database, which would be free.
View Answer
| December 15, 2010 11:21 PM
Oracle 10g, Oracle developers, Oracle development
oracle report is hanging
Reports should never hang, so the best practice is to investigate the root cause and correct it.
View Answer
| December 15, 2010 11:20 PM
Oracle Reports
Reports should never hang, so the best practice is to investigate the root cause and correct it.
View Answer
| December 15, 2010 11:20 PM
Oracle Reports
Date conversion (to_char) behavior
In case someone else finds a similar situation, the problem was that the Oracle client software was installed in Spanish. Some of the options to fix it were: -create a logon trigger to change the nls session parameters if needed -modify the machine’s registry -reinstall Oracle client software We opted by the third one.
View Answer
| December 15, 2010 11:20 PM
Oracle, SQL, Windows
In case someone else finds a similar situation, the problem was that the Oracle client software was installed in Spanish. Some of the options to fix it were: -create a logon trigger to change the nls session parameters if needed -modify the machine’s registry -reinstall Oracle client software We opted by the third one.
View Answer
| December 15, 2010 11:20 PM
Oracle, SQL, Windows
How can I connect my application server to my Oracle 10g database?
1. Click Connections Navigator tab in navigator window 2. Right-click Application Server in the Connections window and select New Application Server Connection from the context menu 3. Click Next to skip 4. On Type page of wizard, name the connection OC4J and choose Standalone OC4J 10g, and click Next NOTE: If there is no connection [...]
View Answer
| December 15, 2010 11:54 AM
Application Server, Oracle 10g, Oracle 10g administration, Oracle 10g Database
1. Click Connections Navigator tab in navigator window 2. Right-click Application Server in the Connections window and select New Application Server Connection from the context menu 3. Click Next to skip 4. On Type page of wizard, name the connection OC4J and choose Standalone OC4J 10g, and click Next NOTE: If there is no connection [...]
View Answer
| December 15, 2010 11:54 AM
Application Server, Oracle 10g, Oracle 10g administration, Oracle 10g Database
Crystal Reports 8.5 and Oracle 9i
Try out this: Start > Settings > Printers > File > Server Properties Select the Form > mention here the paper size of the form. Click Ports > Select port > Click Drivers and select appropriate now click Save Now open Crystal Reports > Page Setup > The form is listed there Sets horizontal and [...]
View Answer
| December 11, 2010 5:22 AM
Crystal Reports, Crystal Reports 8.5, Oracle 9i
Try out this: Start > Settings > Printers > File > Server Properties Select the Form > mention here the paper size of the form. Click Ports > Select port > Click Drivers and select appropriate now click Save Now open Crystal Reports > Page Setup > The form is listed there Sets horizontal and [...]
View Answer
| December 11, 2010 5:22 AM
Crystal Reports, Crystal Reports 8.5, Oracle 9i
XFS filesystem performance
First doing optimization, U have to analyze processes & processor Utilization, analyze memory utilization & performance and analyze network utilization and performance. Also consider the following, if u think it is necessary…. Change Network Environment viz., Monitor all other system components, Limit the collision domain, Check cable quality, Check both sides of a connection, Change [...]
View Answer
| December 9, 2010 7:17 AM
Oracle Database, Oracle Database 11g, ZFS Filesystem
First doing optimization, U have to analyze processes & processor Utilization, analyze memory utilization & performance and analyze network utilization and performance. Also consider the following, if u think it is necessary…. Change Network Environment viz., Monitor all other system components, Limit the collision domain, Check cable quality, Check both sides of a connection, Change [...]
View Answer
| December 9, 2010 7:17 AM
Oracle Database, Oracle Database 11g, ZFS Filesystem
What are the pitfalls of moving old windows server to a new location in the computer room?
If it is going to stay on the same VLAN and keep the same IP there are no pitfalls. Will it be keeping these the same?
View Answer
| December 7, 2010 8:55 PM
Data center relocation, Hardware relocation, Oracle 9i, Windows Server, Windows Server Migrations and Upgrades
If it is going to stay on the same VLAN and keep the same IP there are no pitfalls. Will it be keeping these the same?
View Answer
| December 7, 2010 8:55 PM
Data center relocation, Hardware relocation, Oracle 9i, Windows Server, Windows Server Migrations and Upgrades
What is a good book for SQL?
Did u want free reading or by cost. There r several opinions u will get soon. It is better to search on net and u may get huge answers. Though I am providing the link below : http://itknowledgeexchange.techtarget.com/itanswers/sql-server-books/ OR if u want it by cost then loom here : 1. SQL in a Nutshell: A [...]
View Answer
| December 5, 2010 6:37 PM
IT Books, Oracle, Oracle Books, SQL, SQL Server
Did u want free reading or by cost. There r several opinions u will get soon. It is better to search on net and u may get huge answers. Though I am providing the link below : http://itknowledgeexchange.techtarget.com/itanswers/sql-server-books/ OR if u want it by cost then loom here : 1. SQL in a Nutshell: A [...]
View Answer
| December 5, 2010 6:37 PM
IT Books, Oracle, Oracle Books, SQL, SQL Server
oracle forms 6i
For Oracle Forms 6i, u may go for IVAN BAYROSS Book. This book is very good for beginners. But for starting with forms u should have some knowledge of sql , pl/sql also. And also u may link here for a good pdf about ur subject: www.cs.txstate.edu/labs/docs/Oracle%20Reports%20Developer%206i%20-%20Publishing%20Reports.pdf Hope it helps u !
View Answer
| December 3, 2010 12:04 PM
Oracle Forms 6i, Oracle reporting, Oracle Reports
For Oracle Forms 6i, u may go for IVAN BAYROSS Book. This book is very good for beginners. But for starting with forms u should have some knowledge of sql , pl/sql also. And also u may link here for a good pdf about ur subject: www.cs.txstate.edu/labs/docs/Oracle%20Reports%20Developer%206i%20-%20Publishing%20Reports.pdf Hope it helps u !
View Answer
| December 3, 2010 12:04 PM
Oracle Forms 6i, Oracle reporting, Oracle Reports
Running SQL PLUS on a server
I beleive that you will need to have SQLPlus installed locally as you’ll need the Oracle drivers and tnsnames.ora locally.
View Answer
| November 29, 2010 8:41 PM
Oracle, SQL Plus, SQL Server, SQLPlus
I beleive that you will need to have SQLPlus installed locally as you’ll need the Oracle drivers and tnsnames.ora locally.
View Answer
| November 29, 2010 8:41 PM
Oracle, SQL Plus, SQL Server, SQLPlus
Oracle Enterprise Manager for Vista
hi if you are loogin into the system as sys — select the option as sysdba in the drop down menu. if the enterprise manager doesnt show up try typing these commands in the command line <pre> set oracle_sid=orcl ====> (your oracle sid) emctl start dbconsole</pre> The Database Control URL is http://hostname:1158/em Try the above [...]
View Answer
| November 27, 2010 12:56 AM
Oracle 10g, Oracle 10g administration, Oracle Enterprise Edition, Oracle error messages, Windows Vista
hi if you are loogin into the system as sys — select the option as sysdba in the drop down menu. if the enterprise manager doesnt show up try typing these commands in the command line <pre> set oracle_sid=orcl ====> (your oracle sid) emctl start dbconsole</pre> The Database Control URL is http://hostname:1158/em Try the above [...]
View Answer
| November 27, 2010 12:56 AM
Oracle 10g, Oracle 10g administration, Oracle Enterprise Edition, Oracle error messages, Windows Vista
Error with this Oracle 10g Express Edition query
The question is not very clear. You might want to try something like this: <pre>SELECT ‘Song Name: ‘ || s.title FROM song s;</pre> If this is not whay you need, or you are getting errors, please provide more details.
View Answer
| November 24, 2010 4:37 PM
Oracle 10g, Oracle 10g administration, Oracle 10g Express, Oracle Query
The question is not very clear. You might want to try something like this: <pre>SELECT ‘Song Name: ‘ || s.title FROM song s;</pre> If this is not whay you need, or you are getting errors, please provide more details.
View Answer
| November 24, 2010 4:37 PM
Oracle 10g, Oracle 10g administration, Oracle 10g Express, Oracle Query
IN and Exists in SQL?
There is difference in between them : When coding a SQL statement with tables in master-detail relationships, it’s common to have to decide whether to write the query using the WHERE EXISTS clause or the WHERE value IN clause. U may resist using WHERE EXISTS because it has the awkward syntax of returning a value, [...]
View Answer
| November 24, 2010 9:47 AM
Oracle 10g Express, Oracle SQL, SQL, SQL commands, SQL Server
There is difference in between them : When coding a SQL statement with tables in master-detail relationships, it’s common to have to decide whether to write the query using the WHERE EXISTS clause or the WHERE value IN clause. U may resist using WHERE EXISTS because it has the awkward syntax of returning a value, [...]
View Answer
| November 24, 2010 9:47 AM
Oracle 10g Express, Oracle SQL, SQL, SQL commands, SQL Server
Rename username in Oracle 10g database
There is no way to rename a user. You could create a new user and import all objects from the old user. You should then drop the old user, but that step is optional
View Answer
| November 24, 2010 12:02 AM
Oracle 10g, Oracle 10g Database, Oracle 9i, Oracle administration, Oracle User Profiles
There is no way to rename a user. You could create a new user and import all objects from the old user. You should then drop the old user, but that step is optional
View Answer
| November 24, 2010 12:02 AM
Oracle 10g, Oracle 10g Database, Oracle 9i, Oracle administration, Oracle User Profiles
How to set oracle database path with oracle developer
You don’t specify the database path in Oracle Developer. You specify the server address, the port and the SID or service name in a configuration file named TNSNAMES.ORA, which is usually in the following path: <ORACLE_DEVELOPER_HOME>\NETWORK\ADMIN
View Answer
| November 23, 2010 3:43 PM
Oracle, Oracle administration, Oracle Database, Oracle Developer, Windows Server 2003
You don’t specify the database path in Oracle Developer. You specify the server address, the port and the SID or service name in a configuration file named TNSNAMES.ORA, which is usually in the following path: <ORACLE_DEVELOPER_HOME>\NETWORK\ADMIN
View Answer
| November 23, 2010 3:43 PM
Oracle, Oracle administration, Oracle Database, Oracle Developer, Windows Server 2003
Duplicate data in column in Oracle 10g Express Edition
There is no need to use parenthesis. This will produce the results you expect: <pre>select distinct no, name from pen</pre> The DISTINCT keywork eliminates duplicate <b>rows </b>from the results of the query. It applies to all of the columns included in the select list. You can use parenthesis with one column, but when including more [...]
View Answer
| November 23, 2010 3:35 PM
Oracle 10g, Oracle 10g administration, Oracle 10g Express, Oracle administration
There is no need to use parenthesis. This will produce the results you expect: <pre>select distinct no, name from pen</pre> The DISTINCT keywork eliminates duplicate <b>rows </b>from the results of the query. It applies to all of the columns included in the select list. You can use parenthesis with one column, but when including more [...]
View Answer
| November 23, 2010 3:35 PM
Oracle 10g, Oracle 10g administration, Oracle 10g Express, Oracle administration
Oracle Spatial certification
Oracle Spatial is an option for Oracle Enterprise Edition that provides advanced spatial features to support high-end GIS and LBS solutions. Oracle Spatial is an option to Oracle Database 11g, Enterprise Edition—includes full 3-D and Web services support to manage all geospatial data including vector and raster data, topology, and network models. It’s designed to [...]
View Answer
| November 23, 2010 11:09 AM
IT certification, IT certification and training, IT certification preparation, Oracle certifications, Oracle Spatial
Oracle Spatial is an option for Oracle Enterprise Edition that provides advanced spatial features to support high-end GIS and LBS solutions. Oracle Spatial is an option to Oracle Database 11g, Enterprise Edition—includes full 3-D and Web services support to manage all geospatial data including vector and raster data, topology, and network models. It’s designed to [...]
View Answer
| November 23, 2010 11:09 AM
IT certification, IT certification and training, IT certification preparation, Oracle certifications, Oracle Spatial
