Use table name to reference the ambiguity column names : Column Names « Select Query « Oracle PL / SQL






Use table name to reference the ambiguity column names

  
SQL> CREATE TABLE emp
  2  (
  3     cid                NUMBER,
  4     address        VARCHAR2(40),
  5     customer_state             VARCHAR2(40),
  6     phone     VARCHAR2(25),
  7     income_level          VARCHAR2(30),
  8     customer_credit            NUMBER,
  9     city              VARCHAR2(30)
 10  );

Table created.

SQL>
SQL> CREATE TABLE sales(
  2    product_id               NUMBER(6),
  3    cid               NUMBER,
  4    channel_id            CHAR(1),
  5    sold         NUMBER(3),
  6    cost                  NUMBER(10,2)
  7  );

Table created.

SQL>
SQL> select product_id, sold, city, customer_state
  2  from   sales s, emp c
  3  where  s.cid = c.cid
  4  and    product_id = 117;

no rows selected

SQL>
SQL> select s.product_id, s.sold, c.cid,
  2  c.city, c.customer_state
  3  from   sales s, emp c
  4  where  s.cid = c.cid
  5  and    s.product_id = 117;

no rows selected

SQL>
SQL>
SQL>
SQL> drop table emp;

Table dropped.

SQL> drop table sales;

Table dropped.

   
    
  








Related examples in the same category

1.Insert string text between column names
2.Column Renaming
3.Column renaming for function
4.Combined columns and renaming
5.Use table name to reference column name
6.col columnName new_value BLAH
7.Reference column name from renamed table name
8.Reference column without table name during table join