Oracle PL/SQL news, help and research


	Oracle PL/SQL


	Home > Oracle Topics > Oracle development languages > Oracle PL/SQL > Expert Technical Advice

Oracle Topics:

EMAIL THIS

TOPICS HOME

BROWSE ALL ORACLE TOPICS

ORACLE INFO CENTERS

RESOURCE CENTERS

RSS FEEDS


Oracle PL/SQL



IN THIS TOPIC:	NEWS (19) , EXPERT TECHNICAL ADVICE (341) , BEST WEB LINKS (7) , DEFINITIONS (1)

Display in sets of:


1 - 10 of 341 in Expert Technical Advice		<< Previous page 1 2 3 ... 33 34 35 Next >>



ORACLE PL/SQL EXPERTS



	Frank Kulash Oracle Database Administrator ASK A QUESTION	Azim Fahmi Senior Systems Analyst ASK A QUESTION


	Confused about Oracle certification exams 17 Jul 2007 EXPERT ANSWER - I am really confused about taking the exams for Oracle certification. I am planning to take 1Z0-007. Is this exam for both Oracle 9i and 10g?


	ORA-01422 error when procedure returns more than one row 13 Jul 2007 EXPERT ANSWER - I have the following Oracle procedure that returns one or more rows depending upon the input into the SQL statement. When there is greater than one row returned I get the ORA-01422 error.


	Calling procedure inside another procedure in anonymous block 11 Jul 2007 EXPERT ANSWER - I have a procedure p1 which holds another procedure p2. I want to call this p2 procedure in an anonymous block.


	How to import comma-delimited text file to Oracle table 15 Jun 2007 EXPERT ANSWER - We have to import a text file (delimited with commas) to an Oracle table via our application with PL/SQL.


	PLS-00103 errors 24 May 2007 EXPERT ANSWER - How do I resolve these PLS-00103 errors?


	PL/SQL do's and don't's: Five questions with Steven Feuerstein Submitted By: SearchOracle.com \| 25 Apr 2007 TIP - Oracle PL/SQL expert Steven Feuerstein advises on what we should never do in PL/SQL -- and always do.


	Definition of force view 16 Apr 2007 EXPERT ANSWER - What is the force view?


	ORA-04082: NEW or OLD references not allowed in table level triggers 02 Apr 2007 EXPERT ANSWER - I am calling a stored procedure from a trigger. It shows the error: "ORA-04082: NEW or OLD references not allowed in table level triggers."


	Script to revoke access from user 05 Mar 2007 EXPERT ANSWER - I'm trying to write a script to revoke all access from any given user. I've done the following so far, but can't figure out all the errors -- can you help?


	Mike Ault's Oracle "good practices": Oracle coding Submitted By: SearchOracle.com \| 23 Feb 2007 TIP - Mike Ault offers "good practices" for Oracle coding, including using array processing and proper variable types and placing code within stored procedures.


1 - 10 of 341 in Expert Technical Advice		<< Previous page 1 2 3 ... 33 34 35 Next >>

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2003 - 2008, TechTarget \| Read our Privacy Policy