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.
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.
Select salary, department-id, last-name From employees Count(distinct department-id); What is wrong with the query above? I need help please.
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
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
uestion: I am using Oracle 10g with SqlDeveloper. When I execute the following code, it says FUNCTION wafadar compiled Warning: execution completed with
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
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
is it possible to gave more than one constraint on particular column?
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;
Can we pass parameters in triggers like in procedures and Triggers?
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
SELECT Distinct persmain.IDENTIFIER ClientNo ,initcap(nvl(ltrim( persmain.FIRST_NAMES||' '||persmain.FAMILY_NAME) , 'Not Recorded')) NAME ,REPLACE(BOF_first_add(TO_NUMBER((
Whhat are the advantages of composite datatypes in oracle?
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
I need to write a single Oracle query without using AND/OR where the ename may starts with or may contain 'paul'.
What are Oracle Utilities?
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
I have the below student table with rows like this Hide Copy Code student_id subject_id Mark 1 1 60 1
How to find unused tables in Particular Schema in Oracle?
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
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
How to create and access multi-level PL/SQL collections in Oracle.
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
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
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.
sql aggregate functions, sql, oracle