Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Avoiding TOO_MANY_ROWS errors in PL/SQL
- Why not use a cursorDECLARE CURSOR c_emp(p_last_name VARCHAR2) IS SELECT last_name || ', ' || first_name FROM employees WHERE last_name = p_last_name; l_employee_full_name...
- Tags: Programming languages, Databases, michael.roblin@..., Varchar2, PL/SQL
- Discussion threads 2007-08-01
- Oracle join table and calculation problem
- Hi all and thanks in advance,I need to output the patient's name, patient's address, item_code, description, and total cost for a particular month in the folloing tables.Here are the tables CREATE TABLE patient( pati_Ref_no ...
- Tags: Oracle Corp., alan.sarchnar@..., pati_Ref_no, Varchar2, Primary Key, patient
- Discussion threads 2007-04-23
- Oracle join table and calculation problem
- Hi all and thanks in advance,I need to output the patient's name, patient's address, item_code, description, and total cost for a particular month in the folloing tables.Here are the tables CREATE TABLE patient( pati_Ref_no ...
- Tags: alan.sarchnar@..., Oracle Corp., pati_Ref_no NUMBER, Varchar2, Primary Key, patient
- Discussion threads 2007-04-23
- Oracle join table and calculation problem
- Hi all and thanks in advance,I need to output the patient's name, patient's address, item_code, description, and total cost for a particular month in the folloing tables.Here are the tables CREATE TABLE patient( pati_Ref_no NUMBER(6) NOT NULL, ...
- Tags: alan.sarchnar@..., Oracle Corp., pati_Ref_no NUMBER, Varchar2, Primary Key, patient
- Discussion threads 2007-04-23
- Simplify PL/SQL INDEX BY tables using text subscripts
- Associative arrays can simplify the lookup of temporary data in PL/SQL programs because text values can be used directly as subscripts to locate array elements. Learn how to apply associative array techniques in your development environment. Associative arrays, formerly called INDEX BY tables, have been a feature of...
- Tags: Oracle Corp., PL/SQL, Databases, Bob Watkins, Programming languages, Storage, associative array, Varchar2, Oracle Tips Newsletter, Array, Data, INDEX, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Technical articles 2006-09-12
- Mini-Tip #3: Associative Array - Retrieve and Sort Array Index
- This tip will answer twoquestions I get very frequently. Definitely a FAQ. "How do I retrieveand use the VARCHAR2 index of an associative array?" and "How can Isort a PL/SQL table?" These questions pertain to PL/SQL functionality;not SQL functionality. SORTI'll answer the sortfirst and I'll kind of cheat. When I...
- Tags: Programming languages, Databases, VARCHAR2, PL/SQL
- Blog posts 2006-08-19
- SQL constraint question
- Hello, does anyone know how to do this? I'm supposed to for an assignment and dont even know how to begin. I was hoping someone might be able to explain it. Using the following CREATE TABLE statements, add AND EXPLICITLY NAME the listed constraints specified for each table. Use the...
- Tags: bradq@..., CREATE TABLE, Null, programming, SQL, VARCHAR2
- Q&A 2005-11-08
Additional Resources
- Oracle PL/SQL
- When i use the Oracle built-in function GET_APPLICATION_PROPERTY within the sub-query of an sql statement i get an error which states "You may not use GET_APPLICATION_PROPERTY function in SQL"...what can be the workaround for this problem?Sounds like you're using forms. Since you did not post the sql statement, I...
- Tags: Programming languages, SQL
- Q&A 2005-07-17
- Sending blob attachments in e-mail with utl_smtp
- Last time, I showed how to send an HTML-formatted e-mail from an Oracle PL/SQL application using utl_smtp. I promised I would extend the package a little with a second method that allows you to send Binary Large OBject blob attachments in the e-mails. The most common application where I work is...
- Tags: Method, Integer, E-mail, Online Communications, Rex Baldazo
- Blog posts 2007-09-30
- Mini-Tip #8 - Extending XMLType to Access Scalar XPath Functions
- For some reason, the XMLType XPath implementation does not allow scalar results. According to the documentation:EXTRACTXML is similar to the EXISTSNODE function. It applies a VARCHAR2XPath string and returns an XMLType instance containing an XML fragment.Extractwill only return an XMLType. A scalar value would be a function thatreturns a...
- Tags: Extending XMLType, Microsoft Access, XMLType XPath, XPath
- Blog posts 2006-09-22
- Oracle Tip: Consider MD5 checksums for application passwords
- It's common to store username and passwordcombinations in a database table for application-level security.This is a good practice because it avoids giving your actualdatabase username and password combinations, which someone coulduse to access the tables and application code directly. There is still a slight risk that someone...
- Tags: Databases, Scott Stephens, Oracle Corp., MD5, password, database
- Technical articles 2004-05-23
- Sending e-mail from an Oracle database with utl_smtp
- If you're running Oracle 10g or later, you can use the nice modern utl_mail package to send e-mails from your PL/SQL applications. Even though the application I maintain is now running on Oracle 10g, it was built back on an Oracle 8i database, so it sends e-mails via the older...
- Tags: Database, Oracle Corp., Domain, Oracle Application Server 10g, Oracle Database, SMTP Server, E-mail, E-mail Servers, Online Communications, Enterprise Software, Software, Rex Baldazo
- Blog posts 2007-09-26
- OraLobEditor (exe)
- Working with lob data too complex? Want to view/saveimage/word/excel/xml/pdf/mp3/ in Oracle? Want to view/save long varchar data simply? OraLobEditor is a Oracle LOB (CLOB, BLOB) field edit tool. View/edit LOB (CLOB, BLOB) field (plain text, RTF, image, hex, html, and xml). Common image formats support (JPEG, GIF, BMP, PNG, TIFF)....
- Tags: Oracle Corp., Mode, OraLobEditor
- Software downloads 2007-10-23
- Encripting a package through wrap utility
- I have convert the package in hexadecimal through wrap utilty in Oracle 10g.But When I am compiling the converted code it is giving error "PLS-00222: no function with name 'VARCHAR2' exists in this scope".Can anybody tell me why it is happening..
- Tags: raviagra@...
- Discussion threads 2007-02-16
- Handling HTML multi-selects in PL/SQL
- Dealing with HTML multi-selects in Oracle's PL/SQL is a bit trickier than I'd like. Depending on how many items the user picks out of the multi-select, you either get back a simple VARCHAR2 object or a special array object. This means you have to write two separate methods to deal...
- Tags: Method, HTML, PL/SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Rex Baldazo
- Blog posts 2008-01-19
- How to improve the query speed?
- How should I consider to improve query speed in oracle9i.Thanks for the suggestion!How long have you got ?They write books about this topic.Your going to have to hand out a bit more info, otherwise I'm going to wear the letters off my keyboard.Like what query, table structures, available indexes, sorting,...
- Tags: Programming languages, Java, Databases, Jason Dong
- Discussion threads 2005-10-10
- Sometimes a variables table is better than hard coding into a package
- When writing PL/SQL packages, there are times where it's better to store a variable in a table instead of coding it into the package. It's most useful for a variable that you might want to change fairly often. If you put such a variable directly in the package (either...
- Tags: Variable, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Rex Baldazo
- Blog posts 2007-10-31
- Hi all and thanks in advance,
- I have the following table but when I insert some values, the program displays an error message it says "(101,'Smith',30000)ERROR at line 2: ORA-01438: value larger than specified precision allows for this column" Here are the table and insert value:CREATE TABLE physican( phys_Ref_no NUMBER(3) NOT...
- Tags: alan.sarchnar@...
- Discussion threads 2007-04-22
- Oracle Tip: How to use default values with database columns
- This article originally appeared in the Oracle e-newsletter. Click here to subscribe automatically. When you create a database table, you havethe option to specify a DEFAULT value. Using default values ondatabase columns helps to insulate database design issues fromapplication code. You can change the default value of...
- Tags: Network technology, Databases, Programming languages, Scott Stephens, Default Value, DEFAULT keyword, Oracle Corp., database
- Technical articles 2004-06-18
- Oracle Tip: Understand the difference between star and snowflake schemas in OLAP
- This article originally appeared in the Oracle e-newsletter. Click here to subscribe automatically. At the core of data warehouse applicationsand OLAP online analytical processing is a specialized schemathat relaxes the rules of Third Normal Form RDBMS schemas in favorof faster analysis and processing of large amounts of data. It'simportant to...
- Tags: Data mining, Databases, Storage, OLAP, Scott Stephens, Oracle Corp., schema, foreign key, primary key, id number
- Technical articles 2004-05-27
- << Previous
- page 1 of 1
- Next >>
