1

Topic: Title to the table in a place value on a column!!

Good afternoon colleagues;
Question such,
I have a table, SALES in it there is a column ckg_monit_sales
Also there is table MONITORING_SALES which is registered on a column ckg_monit_sales in a place value.
More precisely instead of value on a column ckg_monit_sales it is registered a title to the table . MONITORING_SALES.
Do not prompt as I can  tables MONITORING_SALES of a column ckg_monit_sales??

2

Re: Title to the table in a place value on a column!!

?

3

Re: Title to the table in a place value on a column!!

proxy_911,   and type all is shorter , and then, well here is how, after that.

4

Re: Title to the table in a place value on a column!!

proxy_911;
Write in a native language, it can becomes more clear.

5

Re: Title to the table in a place value on a column!!

proxy_911;
The crystal full-sphere shows that you need something like

left join some_table t2 on t.some_id = t2.id and t.some_field = ' T2'

6

Re: Title to the table in a place value on a column!!

env;

Wants "dynamic"
(A name of a column from a variable (a field of the set-up table))
....
stax

7

Re: Title to the table in a place value on a column!!

Stax;
Yes Stax thanks are true!, that I wanted.

8

Re: Title to the table in a place value on a column!!

And how it to implement??

9

Re: Title to the table in a place value on a column!!

proxy_911;
In what environment will be  SALES?
If plus look
https://docs.oracle.com/cd/E11882_01/se … m#SQPUG073
.....
stax

10

Re: Title to the table in a place value on a column!!

Stax;
From what it is pores you links began to rush? Well set an example outline.

11

Re: Title to the table in a place value on a column!!

Lary Denis wrote:

proxy_911,   and type all is shorter , and then, well here is how, after that.

Lary's Penis wrote:

Stax;
From what it is pores you links began to rush? Well set an example outline.

Burn down children.:-D:-D:-D

12

Re: Title to the table in a place value on a column!!

Stax;
In 12 environment.

13

Re: Title to the table in a place value on a column!!

Lary's Penis wrote:

Stax;
From what it is pores you links began to rush? Well set an example outline.

Went too far,

SQL> ed
Wrote file afiedt.buf
1 declare
2 v_name varchar2 (30);
3 v_sum number;
4 procedure p (p_ncol number) is
5 begin
6 - yours MONITORING_SALES
7 select column_name into v_name from user_tab_columns where table_name ='EMP ' and COLUMN_ID=p_ncol;
8 - emp yours
9 execute immediate ' select sum (' || v_name || ') from emp ' into v_sum;
10 dbms_output.put_line (' Suma on a column ' || v_name || ' = ' || v_sum);
11 dbms_output.put_line (");
12 end;
13 begin
14 p (6);
15 p (7);
16* end;
SQL> /
 on column SAL = 29025
 on column COMM = 2200
PL/SQL procedure successfully completed.

.....
stax

14

Re: Title to the table in a place value on a column!!

proxy_911 wrote:

Stax;
In 12 environment.

At me ancient 11th
.....
stax