Search Results

Search found 16176 results on 648 pages for 'oracle calendar'.

Page 313/648 | < Previous Page | 309 310 311 312 313 314 315 316 317 318 319 320  | Next Page >

• Is there a way to parametrize ORACLE 10g SELECT-query with IN-clause

  - by matti

  I saw couple of SO questions (SO) concerning SQL-server. For SQL-server there was no decent solution. All were hacks/workarounds. What about Oracle? Is it same answer (Paremeterizing each value)? Any Oracle example without LINQ would be appreciated (I have .NET 2.0). Thanks & BR -Matti

  Read the article

• Highlighting multiple dates in MonthCalender Control in window application

  - by user208466

  Hi All. i am create a Event Calender using MonthCalender control in window application asp.net can any one tell me how can i highlight multiple dates in MonthCalender thanks in advance

  Read the article

• How to select view in Oracle from another connection(other user)?

  - by Adomas

  Hi, I want to select a view from my sys user, but with other connection. I need to select view DBA_USERS. Is there any way of doing so? I am new in Oracle, so maybe it is silly question, but still, I have no idea how to do it.

  Read the article

• How can I replicate an Oracle 11g database(data+structure) on my local machine for development?

  - by bron

  I am working on a test server with an Oracle 11g installed. I was wondering if there is anyway I can replicate the database(environment + data) on my local Linux machine. I am using a CentOS 5.3 on Windows XP with SUN Virtual Box. On Windows I am using sqldeveloper client to connect to the 11g database.

  Read the article

• Oracle: What does `(+)` do in a WHERE clause?

  - by Jonathan Lonowski

  Found the following in an Oracle-based application that we're migrating (generalized): SELECT Table1.Category1, Table1.Category2, count(*) as Total, count(Tab2.Stat) AS Stat FROM Table1, Table2 WHERE (Table1.PrimaryKey = Table2.ForeignKey(+)) GROUP BY Table1.Category1, Table1.Category2 What does (+) do in a WHERE clause? I've never seen it used like that before.

  Read the article

• Oracle: Is there a way to get the column data types for a view?

  - by rally25rs

  For a table in oracle, I can query "all_tab_columns" and get table column information, like the data type, precision, whether or not the column is nullable. In SQL Developer or TOAD, you can click on a view in the GUI and it will spit out a list of the columns that the view returns and the same set of data (data type, precision, nullable, etc). So my question is, is there a way to query this column definition for a view, the way you can for a table? How do the GUI tools do it?

  Read the article

• Calculate business days

  - by AdamTheHutt

  Hi, I need a method for adding "business days" in PHP. For example, Friday 12/5 + 3 business days = Wednesday 12/10. At a minimum I need the code to understand weekends, but ideally it should account for US federal holidays as well. I'm sure I could come up with a solution by brute force if necessary, but I'm hoping there's a more elegant approach out there. Anyone? Thanks.

  Read the article

• Find the number of days in a month in Java

  - by chetan

  How do you find the number of days in a month in Java?

  Read the article

• Is it possible to create a DateFormatter which converts a two-digit year into a four-digit year?

  - by DR

  In my Java application I use a DateFormat instance to parse date inputs. DateFormat fmt; fmt = DateFormat.getDateInstance(DateFormat.DEFAULT) // dd.MM.yyyy for de_DE The problem is that the user insists to enter dates in the form 31.12.11. Unfortunately this is parsed to 31.12.11. (0011-12-31 in ISO format) Instead I want the parsed date to become 31.12.2011 (2011-12-31 in ISO format). Can I modify the date format to somehow parse inputs that way?

  Read the article

• Is using joins in select clause slow in Oracle?

  - by gniquil

  I would like to write a query like the following select username, (select state from addresses where addresses.username = users.username) email from users This works in Oracle (assuming the result from the inner query is unique). However, is there a performance penalty associated with this style of writing query?

  Read the article

• disable sunday in asp.net calender

  - by deep

  How to disable sunday in asp.net calender control? am using c#

  Read the article

• What are the BIN$... tables in Oracle's ALL_TAB_COLUMNS table?

  - by Aaron Digulla

  When I query ALL_TAB_COLUMNS in Oracle, I see tables called BIN$frKctA83wMPgQEOSh0Az+A==$0 BIN$frKctA8cwMPgQEOSh0Az+A==$0 BIN$frQ1pdU2TgXgQEOSh0APxA==$0 BIN$frQ1pdVGTgXgQEOSh0APxA==$0 There is no corresponding entry in ALL_TABLES. What are those?

  Read the article

• Does march have 32 days?

  - by santhan

  Once I found march showing 32 days in JCalendar. The critical part here is this condition seems to be transient. I couldn't reproduce this in a consistent fashion. Has anyone seen this before?? Any fixes possible?? Many thanks in advance!

  Read the article

• Oracle query nnnnnnnnnnnn

  - by kunj raman singh

  Hi, Please help me to achieve the below problem: I am having one "view" in the Oracle database,I want the output of that view and store that output in the .txt file on some other folder in UNIX box. The output which is generated from view is a report and I want to save that report in .txt format in one folder on UNIX box.Oracle is present on the UNIX box.

  Read the article

• Can compilation of several Oracle Pl/SQL package be an atomic operation?

  - by Alexey Kalmykov

  If I deploy N pl/sql packages to Oracle DB, can I make their compilation atomic i.e. the changes in these packages will be applied after the successful compilation of all packages?

  Read the article

• How to align Datepicker to text box right edge?

  - by Daj pan spokój

  I have jQuery UI Datepicker on the top right edge of my layout. By default, it opens aligned to the left edge of its text box. Thus, it falls out of the layout: How to make it open aligned to the right border of its text box?

  Read the article

• Java Date sorting method?

  - by sukitha

  Hi, I have an String array of dates in the format ex:'2010-05-04 11:26:46 +0530'. How can I check whether a particular date in the array is today? thanks

  Read the article

• How do I create a geo-tagged event feed?

  - by Colin Barnes

  What is the most standards compliant way to make a geo-tagged event feed that is also consumable by Google Maps?

  Read the article

• How do I replace absolute times ("1:30 PM") with relative times ("15 minutes ago") and have them aut

  - by acer

  Is there a Javascript script to change the time and date of blogs automaticly like facebook ??? for example "10 minutes ago" instead of "May 15 2010 12:30". -Thank You

  Read the article

• Quickest way to clone a GregorianCalendar?

  - by wds

  I'm trying to make a deep copy of an object, including a GregorianCalendar instance. I'm always wary of using clone() and it doesn't seem to have been overridden here, so I'm just doing the copy field by field. Ideally, there'd be a copy constructor, which I could use like so: GregorianCalendar newCalendar = new GregorianCalendar(oldCalendar); Unfortunately I can't find any such functionality in the API and am stuck trying to figure out which fields I need to get an exact copy. So, to make a copy of one of these calendars, how would you do it? Am I missing some simple shortcut here?

  Read the article

• How can I determine if a string is a Hebrew or Gregorian date?

  - by Alon

  Hi, I have a string value that contains or a Hebrew date, or a Gregorian date. How can I determine if it's Gregorian or Hebrew in C#?

  Read the article

• JPA: How do I get a scalar result of type Long-- not BigNumber-- from Oracle NUMBER?

  - by rektide

  The default mapping from an Oracle NUMBER value is into BigNumber... How can I get a scalar result query to return a Long instead?

  Read the article

• Java date processing

  - by Don

  Hi, Given an instance of java.util.Date which is a Sunday. If there are 4 Sundays in the month in question, I need to figure out whether the chosen date is 1st Sunday of month 2nd Sunday of month 2nd last Sunday of month Last Sunday of month If there are 5 Sundays in the month in question, then I need to figure out whether the chosen date is 1st Sunday of month 2nd Sunday of month 3rd Sunday of month 2nd last Sunday of month Last Sunday of month I've had a look in JodaTime, but haven't found the relevant functionality there yet. The project is actually a Groovy project, so I could use either Java or Groovy to solve this. Thanks, Donal

  Read the article

• When would isSearchable return false for an Oracle JDBC column?

  - by Ian Varley

  In what cases would a call to java.sql.ResultSetMetaData.isSearchable(int col) return false for an Oracle database? The documentation for the method doesn't really answer the question: "Indicates whether the designated column can be used in a where clause." I can think of only one case - when the column is the result of an aggregate function (in which case it would have to be part of a HAVING filter, not a WHERE filter). Are there any other cases?

  Read the article

• oracle index for string column - does format of data affects quality of index?

  - by Jayan

  We have following type of "Unique ID" column for many tables in the database (Oracle). It is a string with following format <randomnumber>-<ascendingnumber>-<machinename> So we have some thing like this U1234-12345-NBBJD U1234-12346-NBBJD U1234-12347-NBBJD U1234-12348-NBBJD U1234-12349-NBBJD The UID value is unique, we have unique index on them. Does the following format is more efficient than above for index scans? NBBJD-U1234-12345 NBBJD-U1234-12346 NBBJD-U1234-12347 NBBJD-U1234-12348 NBBJD-U1234-12349

  Read the article

< Previous Page | 309 310 311 312 313 314 315 316 317 318 319 320  | Next Page >