Today's Messages (off)  | Unanswered Messages (on)

Forum: Forms
 Topic: Biometric ZDKeco
Biometric ZDKeco [message #681643] Wed, 12 August 2020 03:06
Amjad_1975
Messages: 82
Registered: January 2017
Member
Hello.everyone

My question is i have a biometric machine ZDKeco which i have successfully installed in pc and i.also registered my test thumb in machine now my problem is how to view record on screen which we scanned thumb i.need guidence how use thus machine with oracle application


Thanks
Forum: SQL & PL/SQL
 Topic: update foreign key of all the referenced table of table
update foreign key of all the referenced table of table [message #681637] Mon, 10 August 2020 23:26
sinha73
Messages: 5
Registered: November 2006
Location: ST LOUISELOPER
Junior Member

I am working on the conversion of tables from the old system to the new system.
I want to update the foreign key value of the referenced table of my table with the new value.
I ran the following query to get the result of all referenced table:

SELECT *
FROM all_constraints
WHERE r_constraint_name IN (SELECT constraint_name
FROM all_constraints
WHERE table_name = 'ADDR');

Query results in 20 rows of the referenced table. I want to loop this table and make the updates.

I want to update the FK value in all the referenced tables with the new value that I will get from a temptable(CONV_TB_2315_1) that has old_id(id) from the ADDR table and new_id(ADDR_id) from the new_ADDR table.

UPDATE
ref_tab_1 rt
SET
ADDR_ID = (
SELECT
ADDR_ID
FROM
CONV_TB_2315_1 CONV
WHERE
rt.ADDR_ID = CONV.id
),
UPDATED_BY = STAFF_ID
where
rt,ADDR_ID IS NOT NULL;

how can I loop all the tables to make the updates?

Forum: Client Tools
 Topic: SqlDeveloper tools in a secure environment
SqlDeveloper tools in a secure environment [message #681559] Tue, 04 August 2020 02:13
keenweng2001
Messages: 6
Registered: August 2020
Junior Member
we have a number of programmer who want to connect to the ORACLE Instance using SQLDeveloper. is there a way to force the 2FA (password + token) authentication when they login to the instance through the SQL Developer ?
Forum: NoSQL
 Topic: Latest month Partition in hive
Latest month Partition in hive [message #681546] Wed, 29 July 2020 11:39
rohit_shinez
Messages: 139
Registered: January 2015
Senior Member
Hi Guys
I have a table in hive that holds daily date partition column

[code][
My_tab
part_col
2020-03-31
2020-03-30
2020-03-29
2020-04-30
2020-04-29
2020-04-28

/code]
I need the latest partition value i.e. 2020-03-30 reason being 2020-03-31 doesn't hold data. So latest month partition that holds data if i pass 2020-03 i.e.(YYYY-MM)



Current Time: Wed Aug 12 07:59:46 CDT 2020