2009-07-29 02:14
In my previous article ANYDATA, we have seen how to store a value in a table column or PL/SQL variable of type ANYDATA. Now we will move further to know, how to access the stored values.Simi… Read More
Blog Directory > Technology Blogs > ORACLE LEARNINGS technology Blog >
Oracle Learnings Blog
technology4aeon.blogspot.com
Tags:
function
string
character
oracle
zone
otilde oslashwould
trigger
anydatastatic function
ascii string
todate
INSERT INTO THIS BLOG
SELECT * FROM YOUR KNOWLEDGE
2009-07-23 15:01
1) About reportsA report consists of objects that collectively define the report:1)data model objects (queries, groups, columns, links, user parameters)2)layout objects (repeating frames, fr… Read More
2009-07-23 15:01
Character DatatypesData TypeSyntaxOracle 9iOracle 10gOracle 11gExplanation(if applicable)char(size)Maximum size of 2000 bytes.Maximum size of 2000 bytes.Maximum size of 2000 bytes.Where siz… Read More
2009-07-23 15:01
Question: In PSQL, I want to declare a cursor within cursor. The second cursor should use a value from the first cursor in the "where clause". How can I do this?Answer: Below is an example… Read More
2009-07-23 15:01
In Oracle/PLSQL, the to_date function converts a string to a date.The syntax for the to_date function is:to_date( string1, [ format_mask ], [ nls_language ] )string1 is the string that will… Read More
2009-07-23 15:01
Whenever we need to pass the value for a database table column of type ANYDATA or to store a variable in PL/SQL block of type ANYDATA, we need to use the ANYDATA.CONVERTXXXX built-in, where… Read More
2009-07-23 15:01
DecHexOctCharDescription00000null11001start of heading22002start of text33003end of text44004end of transmission55005enquiry66006acknowledge77007bell88010backspace99011horizontal tab10A012n… Read More
2009-07-23 15:01
In Oracle/PLSQL, the ascii function returns the NUMBER code that represents the specified character.The syntax for the ascii function is:ascii( single_character )single_character is the spe… Read More
2009-07-23 15:01
In Oracle/PLSQL, the asciistr function converts a string in any character set to an ASCII string using the database character set.The syntax for the asciistr function is:asciistr( string )s… Read More
2009-07-23 15:01
The USER_JOBS Data Dictionary provides the details of all the jobs scheduled by the user. The following columns form the USER_JOBS table. JOB Identifier of job. Neither import/export… Read More
2009-07-23 15:01
An Oracle database cannot determine the work done by a packaged function when the function is executed from inside a DML statement. Therefore, if packaged functions are to be executed from w… Read More
2009-07-23 15:01
In Oracle/PLSQL, the decode function has the functionality of an IF-THEN-ELSE statement.The syntax for the decode function is:decode( expression , search , result [, search , result]... [… Read More
2009-07-23 15:01
In Oracle/PLSQL, the to_char function converts a number or date to a string.The syntax for the to_char function is:to_char( value, [ format_mask ], [ nls_language ] )value can either be a n… Read More
2009-07-23 15:01
ANYDATA is a new data type introduced with Oracle 9i. As the name implies, it allows the user to store values of any data type (Oracle Defined/User defined) in it.ANYDATA data type, could be… Read More
2009-07-23 15:01
Oracle Database 11g Top New Features:Database ReplayExplore Database Replay, the new tool that captures SQL statements and lets you replay them at will.Transaction ManagementGet an introduct… Read More
2009-07-23 15:01
Hi,Try to answer the following question.Is it possible to create a trigger using “CREATE OR REPLACE TRIGGER TRIGGER_NAME”, where the trigger_name is already being used by another… Read More
2009-07-23 15:01
We all know, that the default format support by Oracle (from 9i) is DD-Mon-RR.Does this mean, we need to give the same format, while inserting records to the table?. If your answer is Yes, t… Read More
2009-07-23 15:01
Understanding The Basic Terminologies: Tablespaces, Extents, and BlocksAn Oracle database can contain many files. But you don't directly choose which file to store your data in. Instead, you… Read More
2009-07-23 15:01
Hi,I would like to share, some details on “Mutating and Constraining table in Oracle”. Mutating error won’t occur when we go for statement level trigger. In general, it is… Read More
Subscribe to Oracle Learnings
Get updates delivered right to your inbox!