Hand-picked news on Oracle and technology in general from AskTheOracle.net

AskTheOracle's Blog

  • lets you know when pages change or new pages are added to the AskTheOracle.net web site
  • provides hand-picked highlights of interesting articles and blog posts from others in the Oracle world
  • provides hand-picked highlights of interesting articles and blog posts from the world of technology in general, including hardware innovations, new software releases, job/career advice, etc.
  • provides advance notice of webinars and training events from Oracle and other organisations
Sign up today to ensure you don't miss out on the most relevant and important changes in your world.

You don't even need to give us your email address to subscribe so if you're inbox is already overflowing, just relax.

So, just RIGHT-click on the orange RSS button on the left under the menu and then copy and paste the URL of into your RSS reader.

OR...

Click on one of the Google, My Yahoo!, My MSN, or Bloglnes button if you use any of those and follow the instructions given and you'll start receiving our latest updates straight away.

I am learning Oracle 11g. I do not have any prior knowledge of it.

Select salary, department-id, last-name From employees Count(distinct department-id); What is wrong with the query above? I need help please.

Continue reading "I am learning Oracle 11g. I do not have any prior knowledge of it."

Content Management Systems for Oracle

Question: Any pointers on cost effective content management software, which can be easily integrated with Oracle EBS R12 1.3 and its key features. Client

Continue reading "Content Management Systems for Oracle"

connecting to different databses in oracle?

Question: I am using Oracle DBCA for creating a new database. While creating new database it asks for hostname & SID. The hostname of my system is empmngt

Continue reading "connecting to different databses in oracle?"

Can't understand warnings in this simple PL/SQL function

uestion: I am using Oracle 10g with SqlDeveloper. When I execute the following code, it says FUNCTION wafadar compiled Warning: execution completed with

Continue reading "Can't understand warnings in this simple PL/SQL function"

Can you provide some interview questions for sql and pl/sql?

Could you provide a link or a file that contains sql and pl/sql interview questions with answers? I'm going for an interview next week for a sql support

Continue reading "Can you provide some interview questions for sql and pl/sql?"

What is the answer of 100 added to null in SQL?

Question: I want to know the answer of this question: 100+null=? in sql Answer: This is a question that goes to the heart of SQL. What is NULL? Null in

Continue reading "What is the answer of 100 added to null in SQL?"

can we use more than one constraint on perticuler column?

is it possible to gave more than one constraint on particular column?

Continue reading "can we use more than one constraint on perticuler column?"

Can we use BREAK ON and COMPUTE within an Oracle stored procedure

Is it possible to create a pl/sql package like the following? CREATE OR REPLACE PACKAGE CONS_REP1 AS    TYPE CUR_TEMP IS REF CURSOR;

Continue reading "Can we use BREAK ON and COMPUTE within an Oracle stored procedure"

Can we pass parameters in triggers like in procedures?

Can we pass parameters in triggers like in procedures and Triggers?

Continue reading "Can we pass parameters in triggers like in procedures?"

Beginners courses in Oracle

I have no background about Oracle and I do not know how to start learning oracle. My interesting filed in business is marketing specifically CRM. Can you

Continue reading "Beginners courses in Oracle"

Help on retrieving null values in SQL

SELECT Distinct persmain.IDENTIFIER ClientNo ,initcap(nvl(ltrim( persmain.FIRST_NAMES||' '||persmain.FAMILY_NAME) , 'Not Recorded')) NAME ,REPLACE(BOF_first_add(TO_NUMBER((

Continue reading "Help on retrieving null values in SQL"

advantages of composite datatypes in oracle

Whhat are the advantages of composite datatypes in oracle?

Continue reading "advantages of composite datatypes in oracle"

Accessing blobs from an Oracle database in a Delphi 7 program

Hi, I create table in oracle 10g xe as: create table empblob( empno int, name varchar2(30), pic blob); How can I insert and manage blob files this table

Continue reading "Accessing blobs from an Oracle database in a Delphi 7 program"

a single query where the ename starts with or contains 'paul'

I need to write a single Oracle query without using AND/OR where the ename may starts with or may contain 'paul'.

Continue reading "a single query where the ename starts with or contains 'paul'"

What are Oracle Utilities?

What are Oracle Utilities?

Continue reading " What are Oracle Utilities?"

I require assistance with an Oracle SQL query

Record name is TREE. The two fields are PARENT & CHILD. It's a tree structure i.e. PARENT = 0001 CHILD = 2000 CHILD = 3000 PARENT = 2000 CHILD = 2500

Continue reading " I require assistance with an Oracle SQL query"

Oracle query to find the maximum of total

I have the below student table with rows like this Hide Copy Code student_id subject_id Mark 1 1 60 1

Continue reading "Oracle query to find the maximum of total"

I have a doubt regarding oracle sql

How to find unused tables in Particular Schema in Oracle?

Continue reading "I have a doubt regarding oracle sql"

Automated Stats gather on schema is not gathering Index stats

Hi. We have automated stats gather on the schema in a database. This job runs everyday. when i check last_analysed date for tables in the schema, it has

Continue reading "Automated Stats gather on schema is not gathering Index stats"

I need filter the phone Records from table with following requirmnet?

I/P : Phone column data are like Phone ------ 77---78-584--12 77---7-8584--12 77-45---78584--12 77----78584--12-545 O/P: 77-78-584-12 77-7-8584-12 77-45-78584-12

Continue reading "I need filter the phone Records from table with following requirmnet?"

Multi Level PL/SQL Collections

How to create and access multi-level PL/SQL collections in Oracle.

Continue reading "Multi Level PL/SQL Collections"

I would like to know the SQL coding to total records into a new field based on a string in a different field?

I have a contributor table with amounts listed for several contributors. Each contributor has an ID associated with them. Some have made one payment, some

Continue reading "I would like to know the SQL coding to total records into a new field based on a string in a different field?"

The command create or replace PACKAGE ... is not being honored.

The command create or replace PACKAGE ... is not being honored. I have had numerous times where if I use @ command in a driver file on a Package Body

Continue reading "The command create or replace PACKAGE ... is not being honored."

What are the advantages of using joins in Oracle?

I'd like to know what are the advantages or disadvantages of using joins over sub queries in Oracle To answer this question let's first define a subquery.

Continue reading "What are the advantages of using joins in Oracle?"

Oracle SQL Aggregate Functions

sql aggregate functions, sql, oracle

Continue reading "Oracle SQL Aggregate Functions"