Find Youngest User In Database?

Feb 6, 2007

How do you find the youngest user in a certain table

select a.illness_desc
from uma.pc_illness a, uma.pc_patient b, uma.pc_diagnosis c
where b.patient_no = c.patient_no and c.illness_code = a.illness_code
and b.age = '21';

i currently have this (it also needs to display their illness which i have done) but i can do only if i cheat and see what the youngest user is, so instead of b.age = 21 i need something that will search the database and find that youngest age

we are using SQL+

View 5 Replies


ADVERTISEMENT

Security :: How To Find Current User In Database

Sep 22, 2011

query to find the current user accessing the database

View 5 Replies View Related

Security :: Find Out The User Access The Database?

Nov 8, 2011

Is there a way to find out the user access the database?

View 1 Replies View Related

How To Find Length Of User Account Password In A Database

Jun 13, 2013

how to find length of the user account password in a database?

View 1 Replies View Related

Security :: How To Find User And IP Address From Oracle Database

Jun 19, 2013

Last week we have realized that a user who connects through SQL Developer(as nothing wrong found in application server logs) has made a serious change in the database which created a real mess. The user has done some mischief in some calculations by making some inserts and updates in some important tables in our production database.

How can I find which user or from which IP the change is made.

View 6 Replies View Related

Server Administration :: How To Find Out List Of DB_LINKS That Uses User Account In Database

Jun 6, 2011

How to find out list of DB_LINKS that uses user account in database ?

View 9 Replies View Related

How To Get Youngest And Oldest Member In The Table

Sep 3, 2008

select
a.first_name,
a.agent_id,
a.birth_date
from
agents a
[code]........

from the above i cannot get the youngest one! this is giving me some mid age.

View 14 Replies View Related

Page 2 - Get Youngest And Oldest Member In Table?

Sep 5, 2008

Do u want to get the youngest & oldest member at each location?

View 1 Replies View Related

PL/SQL :: Create Trigger To Insert Data From One User To Another User In Same Database?

Apr 16, 2013

I Created One Trigger as Follows

CREATE OR REPLACE TRIGGER TRIGGER1
BEFORE INSERT
ON table1
FOR EACH ROW

[code]......

Here , I Want To Insert The Data From My User To Test User . In This Situation When I Execute The Above Trigger It Shows The Error PL/SQL: ORA-00942: table or view does not exist

View 3 Replies View Related

How To Find CPU Usage By Each User Session

Sep 7, 2011

I can get "CPU used by this session' value from v$sesstat. That is the value in centiseconds used by each session. How to convert the value into a percentage of total CPU resource ?

Or there are some other ways to gain the value. i.e. Percentage of Total CPU usage for each Oracle session.

View 5 Replies View Related

Find High CPU User In Oracle 10g

Jan 25, 2013

clould you sand me sqary for find high cpu user in oarcle 10g

View 3 Replies View Related

Security :: To Find Out Which Row Locked By Particular User

May 14, 2011

If the user has locked some row in the database how to find out the row id or the row which is locked by that particular USER.

View 2 Replies View Related

Find Which User / Program Is Using USERS Tablespace?

Feb 27, 2012

I have a database in which there are lots of programs running by default user or programs started by some oracle users.

Now, I know that the USER tablespace is growing at very high speed - But I dont know which user/program is causing this growth of USER tablespace.

how to identify the program/user who is responsible for this growth of USERS tablespace.

View 1 Replies View Related

Security :: To See Any Database For The Operations Of Sys User Or Any Other User

Aug 23, 2011

I have enabled Auditing in my oracle Database but I am not able to see any database for the operations of sys user or any other user in my "SYS.AUD$" and "SYS.FGA_LOG$" tables.

Value for the parameter "AUDIT_TRAIL" is set to "db,extended".

I am working as "SYS" user and I have shutdown and again startup the database but neither there was any information in both the tables nor I can see any files at the destination specified by "AUDIT_FILE_DEST".

View 10 Replies View Related

Find Details Of User Who Modified Structure Of Table?

Aug 3, 2011

I have a small question is it possible to find the details of a user who modified the structure of a table, including what command he ran to change the structure of the table?

View 2 Replies View Related

SQL & PL/SQL :: Query To Find User Who Did Not Login From Past 3 Years?

Nov 2, 2012

I have two table APPLICATION_1 and APPLICATION_2, where user's login date is captured.There will be multiple records for each user.Same user may or may not be present in both tables.

The requirement is to find those users who have not logged-in in the last 3 years.

-- Test Case

DROP TABLE application_1;
DROP TABLE application_2;
CREATE TABLE application_1
(
seq NUMBER ,
user_id VARCHAR2(30),

[code].....

Using the below query I'm able to get the desired output.

SELECT user_id, MAX(login_date) last_login_date FROM (
SELECT user_id, MAX(login_date) login_date FROM application_1 GROUP BY user_id
UNION ALL
SELECT user_id, MAX(login_date) login_date FROM application_2 GROUP BY user_id
) GROUP BY user_id

[code].....

View 10 Replies View Related

Performance Tuning :: Find The Last User Analyzed Particular Table?

Aug 9, 2012

How can i find the last user analyzed particular table?

I can able to find last analyzed date, but can't able find the which user has done it.

View 2 Replies View Related

SQL & PL/SQL :: Find Constraint Name From User Table - Illegal Use Of LONG Datatype

Apr 30, 2010

I want to find the constraint name from User_Constraints table using the following query:

Select * From User_Constraints Where Table_Name='CHARGECODE' and Constraint_Type='C' And Search_Condition = '"PERCENTAGE" IS NOT NULL';

Then it shows "ORA-00997: illegal use of LONG datatype" error.

Is there any way to compare with long type value.

View 11 Replies View Related

SQL & PL/SQL :: Find Out Columns In Database Which Are Not Used

Jul 1, 2013

How to find in the oracle10g database if there is any column which is not being used at all.If the data is there in the column,how to check when was it last populated.

View 3 Replies View Related

SQL & PL/SQL :: Find Out Database Name For Indexes

Jan 15, 2013

I am trying to find out database name for the unusable indexes thru the query; I am using dba_indexes for the index name but not sure which view I need to join with to find the db name.

View 11 Replies View Related

Find Root Cause Why Database Unresponsive

Apr 30, 2013

We have a 2 node RAC runing on 11.2.0.2 and last night the database was totally un-responsive. when i checked the ADDM I noticed the following:

Waiting for event "cursor: pin S wait on X" in wait class "Concurrency" accounted for 98% of the database time spent in processing the SQL statement with SQL_ID "4b2epo0eaqol9".I am wondering what option do i have here? i am looking to do the following:

1) find the root cause why the database was un-responsive

2) ADDM is listing the query, what options do we have further?

View 2 Replies View Related

SQL & PL/SQL :: Find Out Column Value In All Table In Whole Database

May 19, 2010

I need the column name and table name which is having the particular value in the whole database.

E.g. :We have 'Scott' value in emp table emp_name column. and we have lot of tables. here we need emp_name and emp as emp table is having scott value in emP_name column.

View 14 Replies View Related

SQL & PL/SQL :: Find All The Tables Present In Database?

Jun 8, 2010

I need to find all the tables present in DB or Schema.

View 3 Replies View Related

SQL & PL/SQL :: Find Given Month Already Exists In Database

Apr 3, 2011

if i have data like this

case 1
code start month end month
winter march march
summer april january
spring feburary feburary

case 2

winter January January
summer february september
spring october december

and if i am trying to enter again start month and end month . i should validate if the month i am giving is already present in the table for any of the season

i want a do the validate with a query so that i will not enter duplicates.

View 5 Replies View Related

SQL & PL/SQL :: How To Find Out Stored Procedure In Database

Jun 20, 2011

There is one DBMSJOB i created schedule to run every day at 22:00 hrs. The jobname is IT_TO_DUM_LOADING and the job type is Stored procedure.

I queried all_source and found stored procedure does not exist in database.

SQL> select text from all_source
2 where type = 'PROCEDURE'
3 and name ='IT_TO_DUM_LOADING';

no rows selected

But i could see the job details in dba_scheduler_jobs view. I cannot use WHERE clause in dba_scheduler_jobs to restrict and find only the job row as i receive time zone error. How it is possible to view the job in dba_scheduler job view whereas i could not find the stored procedure of its in all_source?

View 7 Replies View Related

SQL & PL/SQL :: How To Know Particular User Existed Or Not In Database

Apr 22, 2013

May i want to know SQL command to find particular table name in a particular user account existed or not in oracle 11g database

View 8 Replies View Related

SQL & PL/SQL :: How To Find Remote Dependencies Of Database Object

Feb 16, 2010

As a part of requirement need to clean up some of database objects from database. Before cleaning up need to check for dependencies with in database and also on remote database.

Is there any data dictionary in oracle which proivides information about remote dependencies.

Any other way to get a list of remote dependencies other then manual checking.

View 3 Replies View Related

Server Administration :: Find Whether Database Link Is Being Used?

Jul 26, 2011

I am having database A and database B and I am inserting into database b by selecting some records from database a using db link.Is there any way to find whether database link is being used?

View 6 Replies View Related

SQL & PL/SQL :: How To Find Size Of View Or Table In Database

Jul 10, 2010

How can we find the size of a view or synonym or table in a database. What is the code.

View 4 Replies View Related

11g Database - Opatch Can't Find Oracle Home

Jul 15, 2011

I am trying to patch an Oracle 11g database. I can see from the logs that is was patched after it was created by a consultant but I cannot get Opatch to work.

C:\app\Oracle\product\11.2.0\dbhome_1>java -version
java version "1.5.0_17"
Java™ 2 Runtime Environment, Standard Edition (build 1.5.0_17-b03)
Java HotSpot™ Client VM (build 1.5.0_17-b03, mixed mode)
C:\app\Oracle\product\11.2.0\dbhome_1>opatch>set ORACLE_HOME=C:\app\Oracle\product\11.2.0\dbhome_1
C:\app\Oracle\product\11.2.0\dbhome_1>opatch lsinventory -all
ORACLE_HOME is NOT set at OPatch invocation
The Oracle Home C:\app\Oracle\product is not OUI based home. Please give proper Oracle Home.
OPatch returns with error code = 1

OPatch failed with error code = 1

Java is set in the environment path but the Oracle home seems to be the issue. I checked the LOC parameter in the Oracle/Inventory folder and it is set correctly to C:\app\Oracle\product\11.2.0\dbhome_1.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved