Question about Oracle 10g Database Standard (ODBSEONUPP0)

1 Answer

Oracle date problem

I have an Oracle date problem I want to use in the where also a time filter not just a date filter, how do I add it?

select count(*)
from table
where DTTM > '10-Jun-08';

Thank you.

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

All dates are actually date-time fields - if you don't specify the time, Oracle defaults to midnight. To filter date-time specify the date-time string as a formatted field like this:

select count(*) from mytable where dttm > to_date('20080610181907','YYYYMMDDHH24MISS');

This is the date June 10, 2008 at 6:19:07 PM as an example.

Posted on Nov 28, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I installed oracle 10g express edition.now I dono how to remove it. please let me kno how to uninstall it.I even stopped the oracle services but i dino abythin further.


Follow these steps:
  1. Open the Windows Services utility: From the Start menu, select All Programs, then Administrative Tools, and then Services.
  2. If any of the following Oracle services exist and have the status Started, then select each of the services, and click Stop:
    • OracleXE
    • OracleXETNSListener
    • OracleJobSchedulerXE
    • OracleXEClrAgent
    • OracleMTSRecoveryService
  3. Exit Services.
See also the Microsoft online help for more information on stopping services.
7.2.2 Step 2: Remove the Oracle Database XE Registry Editor Settings Follow these steps:
  1. Log on to Windows with Windows administrative privileges.
  2. Ensure that you followed the instructions under "Step 1: Stop the Oracle Database XE Services" to stop the Oracle Database XE services.
  3. Start the Registry Editor at a command prompt:
    SYSTEM_DRIVE:\> regedit
  4. Go to HKEY_CLASSES_ROOT.
  5. Delete the following keys:
    • NEED TO CONFIRM THE XE-SPECIFIC ONES.
  6. Go to HKEY_CURRENT_USER\Software.
  7. Under Microsoft\Windows\CurrentVersion\Explorer\MenuOrder\Start Menu\Programs, delete the Oracle Database 10g Express Edition key.
  8. Go to HKEY_LOCAL_MACHINE\SOFTWARE and search for the ORACLE group key.
  9. Expand the ORACLE group key and then delete the KEY_XE and OracleMTSRecoveryService keys.
  10. Go to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI.
  11. Expand the ODBCINST.INI key and remove the Oracle in XE key.
  12. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services.
  13. Delete the following keys:
    • OracleServiceXE
    • OracleXEClrAgent
    • OracleXETNSListener
  14. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application.
  15. Delete the Oracle.xe key.
  16. Exit the Registry Editor.
  17. Restart your computer.
7.2.3 Step 3: Update the System Variable Path Follow these steps:
  1. Open System from the Control Panel.
  2. In the System Properties dialog box, click the Advanced tab, then click the Environment Variables button.
  3. Select the system variable Path and edit the Path variable to remove the Oracle Database XE entry. For example:
    C:\oraclexe\app\oracle\product\10.2.0\server\bin;
  4. Save your changes and then exit the Control Panel.
7.2.4 Step 4: Remove Oracle Database XE from the Start Menu and Desktop Follow these steps:
  1. Select Start, then All Programs, and then Oracle Database 10g Express Edtion.
  2. Right-click Oracle Database 10g Express Edtion and from the menu, select Delete.
  3. On the desktop, right-click the Get Started with Oracle Database 10g Express Edition icon and from the menu, select Cut.
7.2.5 Step 5: Remove the Oracle Database XE Directories Follow these steps:
  1. Ensure that you have followed the instructions under "Step 1: Stop the Oracle Database XE Services" to stop all Oracle Database XE services.
  2. From the Windows Explorer, navigate to the directory where you installed Oracle Database XE, for example, c:\oraclexe.
  3. Right-click the Oracle Database XE installation directory and from the menu, select Delete.
7.2.6 Step 6: Install and Run the Windows Installer CleanUp Utility Run the Windows Installer CleanUp utility to remove the Windows Installation configuration information for the Oracle Database XE installation. You can download it from Microsoft at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;290301
he deinstallation completes, click Finish.

Sep 14, 2010 | Oracle Database 10g

3 Answers

Transforming birthdates into year codes


Here is a solution that might work for you. Please be mindful that there are several different solutions that will achieve the same thing in Excel (I am assuming Excel is your software).

1) Make sure each column in your spreadsheet has a heading.

2) Highlight (select) the column of birthdays.

3) Choose Format from the menu bar.

4) Choose Cells... from the drop-down menu.

5) For the "category", choose Custom.

6) In the "type" box, type yyyy

7) Click OK and when you return to your spreadsheet, you will see only the years displayed. However, when you try to edit a cell, you will see that the entire birth date is stored and preserved.

8) Now, highlight the entire table

9) Then, choose Data from the menu bar

10) Choose Subtotals... from the drop-down menu

11) In the "At each change in" box, choose the name of the column with the birth dates

12) In the "Use function" box, choose Count

13) Leave all other choices at their defaults

14) Click OK, and you are done.

Using this method, you can continue to enter the data as you always have. In that way, the birth date info is never actually destroyed or converted. What you are doing is simply deciding what is displayed.

I hope this helps.

Aug 02, 2009 | Microsoft Office Excel 2007

1 Answer

In excel how to display date in previous cell, a hyphen, and the end of that month


I'm not sure exactly what you mean, but you can highlight the cell that you want, right click, select "format cells", select "date" in the "numbers" tab and scroll through a bunch of different options for displaying the date.

Jun 08, 2009 | Oracle Database Enterprise Named User Plus

2 Answers

Steps in saving file in excel to database


severals solution :
- save file as text separated by comma and use sqloader from oracle
- use function in excel to concatenate insert order : "insert into TABLE_NAME (field1,...,fieldn) values (A1,B1,...,??n);". Save file as text with sql extension. Connect against roacle db and execute file previously saved.
- use ODBC from MicroSoft

Dec 11, 2008 | Microsoft Business & Productivity Software

1 Answer

How to print only selected fields in ms access.


open your table in query, follow steps to do this...

1. open new query in access
2. locate the table
3. once table selected, select field name in selected table you only want to include in query
3. once finished selecting the field save the query
4. you can now view selected field in your table and print as well
5. you can edit the query anytime if you want to add or remove field
6. query will not affect your table since this is only query.

hope this will help you....

Oct 22, 2008 | Microsoft Access 2002 for PC

2 Answers

Oracle 10g Error


You're using the wrong password.

Sep 10, 2008 | Oracle 10g Database Standard (ODBSEONUPP0)

1 Answer

Excel counting


Use Pivot table, it might help you reach your target..!!

Aug 12, 2008 | Microsoft Excel for PC

1 Answer

Microsoft Access Query


Your date form is what it wrong. In order to use dates in Access with a BETWEEN function clause the values have to specifically be dates.

You can create dates in literal strings using the # sign to bound them, as in:

Select DISTINCT [ActivityDate] between #1/1/08# and #12/31/08#

#....# tells Access to treat this literal string as a date.

If you are using non-literal values, such as a parameter handed into the query, which would then be a variable, you can't use #some_variable# to cause Access to view it as a Date since #...# is for literal values only. To convert (also called "casting" a variable), use the CDate function. CDate likes to know what format to expect the string to come in though so it helps to pass that along, as in:

Select DISTINCT [ActivityDate] between CDate(begin_dt_string) and CDate(end_dt_string)

Remember the date string you pass into CDate has to be readable as a date by CDate. So make sure you pass in something that it can handle (use the IsDate() function to check to be sure so you can avoid a runtime datatype casting error). If your locale is US, then passing in x/y/z it will take for MM/DD/YYYY. If Europe, it will take it as DD/MM/YYYY. So keep that in mind.

To convert out of a date, use the FORMAT() function. That is how you get a date data type value to become a string value.

More fun reading:
http://www.techonthenet.com/access/functions/datatype/cdate.php
http://www.techonthenet.com/access/functions/advanced/isdate.php
http://www.techonthenet.com/access/functions/date/format.php

Hope this helps!

Feb 11, 2008 | Microsoft Office Access 2003 (077-02871)...

Not finding what you are looking for?
Oracle 10g Database Standard (ODBSEONUPP0) Logo

Related Topics:

757 people viewed this question

Ask a Question

Usually answered in minutes!

Top Oracle Business & Productivity Software Experts

robertmoore1

Level 2 Expert

179 Answers

Fred Block
Fred Block

Level 2 Expert

289 Answers

cwradio73

Level 3 Expert

899 Answers

Are you an Oracle Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...