Using connect_by to get the depth of a node in a tree in Oracle DB table
I have a oracle table which looks like this: Schema: (number) node_id (number) parent_id (number) parent_seq Each entry in the ...
I have a oracle table which looks like this: Schema: (number) node_id (number) parent_id (number) parent_seq Each entry in the ...
I have a table PO_HEADER with ~20 million records. Considering our future load on the table we have decided to ...
I have the entity: /** * @ORM\Entity * @ORM\Table(name="TERCEROS") */ class Empleado { /** * @ORM\Id * @ORM\Column(type="string", name="CODIGO", length=15) ...
In one table few columns are there and in 3 columns i want to merge values from these 3 columns ...
I want to join 2 tables based on columns priority ex. Suppose Table1 has six columns(Col1,Col2,Col3,Col4,Col5,Col6) If i want to ...
This is a shortended down procedure for example purposes. The problem i am have is when i go to the ...
I have 2 tables, the first one is MASTER_TABLE with fields ID, STATUS_CODE, STATUS_SUBCODE, SUBJECT_CODE, SUBJECT_SUBCODE and the second table ...
This question already has answers here: (14 answers) Closed 7 months ago. How do I do the following? select top ...
I am new to Oracle, I have tried to add a foreign key "SupplyMGR"."SUPPLIES" to an "OrderMGR"."USEDIN". But I am ...
Why am I getting following errors with this query? -- NOT NULL ALTER TABLE employee MODIFY FirstName NOT NULL; Error ...
create table divorced_females select cust_id, cust_first_name,cust_last_name, cust_gender, cust_marital_status from customers where cust_gender = 'F' and cust_marital_status = 'divorced'; I am ...
create table careers (s_no number(2), course varchar2(20), topic1 varchar2(20), status1 varchar2(20), topic2 varchar2(20), status2 varchar2(20), topic3 varchar2(20), status3 varchar2(20)) values ...