Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Do not include in the LoV the car numbers already used in the second table

AndriiPrincipSep 7 2019 — edited Sep 8 2019

I have two tables, in one table “Car number”, I have a list of car numbers there. In the second table “Registered numbers” I have registered car numbers there. In the “Registered Numbers” table, I fill out the form using the LOV list taken from the “Number Table” table. Is it possible to make sure that in the form when filling out "Registered numbers" in the LOV list there are only those numbers that have not been registered before. Since now all the numbers from the “Car number” table appear in the list. Thanks for the help)

CREATE TABLE number_car
id NUMBER(10) ,
number varcahar2(10),
date_add varcahar2(30)
);

CREATE TABLE registered_numbers
id NUMBER(10) ,
reg_number varcahar2(10),
date_reg varcahar2(30)
);

select for form table  registered_numbers (LoV);
select number as num,number from number_car

Comments

Pravin Takpire

There would be no logs for normal transactions. All other transactions like adding tablespace/dropping tablespaces will be recored in alert_SID.log and it would be in DIAGNOSTIC_DEST directory.

regards

Pravin

unknown-951199 
2841596 wrote:




I'm learning about oracle database and I created a user and started creating tables, doing queries on Oracle Database 12c. I would like to know where can I see the transaction log, so I can see what's happening, the access and stuff. I can't find the log file anywhere. Where is it located?

does  not exist.

why do you think it should exist?

Martin Preiss

maybe it's a question of terminology: Oracle has redo log files with information on data changes und undo tablespaces containing undo records to undo changes that were made to the database by the uncommitted transaction. Some other databases (for example MS SQL Server) use a transaction log file to store these information.

ddf_dba

To actually read through a redo log you'll need to use DBMS_LOGMNR.  Read here:

https://dfitzjarrell.wordpress.com/2008/10/31/workin-in-the-mines/

David Fitzjarrell

23ai

As said earlier about the actual block level changes  are recorded into redo logs and undo data go to undo tablespace.

You can monitor live queries under v$transaction, and what you see there is sql queries submitted by the users.

Fastfwd75 
sol.beach wrote:






2841596 wrote:




I'm learning about oracle database and I created a user and started creating tables, doing queries on Oracle Database 12c. I would like to know where can I see the transaction log, so I can see what's happening, the access and stuff. I can't find the log file anywhere. Where is it located?




does  not exist.




why do you think it should exist?

I remember looking for this too when I first came to Oracle. It really should exist even if only as an optional opt-in parameter.

unknown-951199 
Fastfwd75 wrote:








I remember looking for this too when I first came to Oracle. It really should exist even if only as an optional opt-in parameter.

Have YOU submitted Enhancement Request for this?

How is this different from enabling SQL_TRACE?

Fastfwd75 
sol.beach wrote:






Fastfwd75 wrote:








I remember looking for this too when I first came to Oracle. It really should exist even if only as an optional opt-in parameter.










Have YOU submitted Enhancement Request for this?


How is this different from enabling SQL_TRACE?

Be Zen sol.beach; this is not an attack on Oracle or on you

This is different from SQL_TRACE because simply logging the SQL statements has much less overhead. I have not submitted it an an enhancement request but it's really not a novel idea. Must be a reason why Oracle does not do it but I don't know what it is.

Look up MySQL general query log to see what I mean.

1 - 8

Post Details

Added on Sep 7 2019
#apex-discussions, #sql-pl-sql
2 comments
121 views