--Notice that the SELECT INTO statement uses an equijoin.
The join condition is listed in the JOIN clause, indicating columns that are part of the primary key and foreign key constraints.
EXAMPLE 5: To determine employee bonus depending on on salary criteria.In this program,
the IF condition is evaluated first and if true, the bonus...
Wednesday, February 8, 2017
Saturday, February 4, 2017
forgot sys password in oracle 11g.
Hi,
Log on to your Windows server as a member of the Administrators group or a member of the ORA_DBA group.
Try the below steps
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\NIIT>set oracle_sid=orcl
C:\Users\NIIT>sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on...