Holidays

The list of holidays in your organization.

Table-Specific Information

SELECT

The 本製品 will use the Oracle Service Cloud API to process WHERE clause conditions built with =,!=,<,>,<=,>=,IN,NOT_IN,IS,IS_NOT,LIKE operators. The rest of the filters are executed client side within the 本製品.

SELECT * FROM Holidays WHERE id = 12
SELECT * FROM Holidays WHERE id > 15
SELECT * FROM Holidays WHERE lookUpName LIKE '%test'
SELECT * FROM Holidays WHERE id IN (12, 23, 123)
SELECT * FROM Holidays WHERE lookUpName IS NOT NULL

INSERT

INSERT can be executed by specifying the holidayDate and name columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO Holidays (holidayDate, name) VALUES ('2011-01-17', 'testinsert')

UPDATE

Update can be executed by specifying the id column in WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Holidays SET holidayDate = '2012-01-17' WHERE id = '1'

DELETE

Following is an example of how to Delete a record in this table.

DELETE FROM Holidays WHERE holidayDate = '2012-01-17'

Columns


Name	Type	ReadOnly	Description
CreatedTime	Datetime	True	The date and time when the holiday was created. This attribute is read-only.
DisplayOrder	Int	False	The display position relative to other holidays.
HolidayDate	Date	False	The date the holiday falls on. The maximum allowed value of the date is 12/31/2032.
Id [KEY]	Long	True	The unique identifier of the holiday.
LookupName	String	True	The name used to look up the holiday.
Name	String	False	The name of the holiday.
UpdatedTime	Datetime	True	The date and time when the holiday was last updated. This attribute is read-only.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
adminVisibleInterfaces	String	The list of interfaces on which the holiday is available for administration use.

ODBC Driver for Oracle Service Cloud