SQL & PL/SQL :: Reset Row Number

Mar 1, 2013

I have Follwoing Table and data.

CREATE TABLE ABC(DPT_NUM NUMBER,LOT_NUM NUMBER);
Insert into ABC(DPT_NUM, LOT_NUM, SRL_NUM) Values (1, 501, 1);
Insert into ABC(DPT_NUM, LOT_NUM, SRL_NUM) Values (1, 502, 2);
Insert into ABC(DPT_NUM, LOT_NUM, SRL_NUM) Values (1, 509, 3);
Insert into ABC(DPT_NUM, LOT_NUM, SRL_NUM) Values (1, 511, 4);
Insert into ABC(DPT_NUM, LOT_NUM, SRL_NUM) Values (1, 503, 5);

[Code]...

I write Following query.

SELECT DPT_NUM,LOT_NUM,ROW_NUMBER() OVER(PARTITION BY DPT_NUM ORDER BY DPT_NUM) SRL_NUM FROM ABC;

Result is

DPT_NUMLOT_NUMSRL_NUM
15011
15022
15093
15114
15035
15166
15227
15698

[Code]...

But i want to reset rownum after each 4. Mean after serial number 4 , serail number must start from 1. I want to reset serial number after each 4 records (lot_num) against dpt_num;

View 7 Replies


ADVERTISEMENT

PL/SQL :: How To Reset Line Number Value For Each Header

Jul 1, 2013

I need to reset the line number for each header values.

create table header_table(header_value varchar2(100));
create table line_table(header_value varchar2(100), line_number number);
insert into header_table values('ALAOF');

[Code]....

But My line table output looks like below

LINE TABLE:

header value line_number

ALAOF 1
ALAOF 2
ALAOF 3

[Code].....

View 6 Replies View Related

SQL & PL/SQL :: Getting Connection Reset And Timeout

May 30, 2010

[#|2010-03-17T19:00:26.689+0530|SEVERE|glassfishv3.0|tcplistener.ModuleHandler|_ThreadID=30;_ThreadName=Thread-1;|The log message is null.
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(SocketInputStream.java:168)
at java.net.SocketInputStream.read(SocketInputStream.java:182)
at java.io.FilterInputStream.read(FilterInputStream.java:66)
at tcplistener.ByteWrapper.unwrapFromStream(ByteWrapper.java:136)
at tcplistener.ModuleHandler.run(ModuleHandler.java:106)
at java.lang.Thread.run(Thread.java:619)
|#]

[code].....

View 1 Replies View Related

SQL & PL/SQL :: Find If Sequence Was Reset

Sep 26, 2010

In oracle is it possible to find if a sequence was reset? I know my sequence was reset, looking at the nextval of my sequence, but is there an oracle log or anything which proves that sequence was reset ?

View 2 Replies View Related

SQL & PL/SQL :: Increment And Reset Field Value?

Apr 18, 2011

Srl no - Srl no w.r. to the date of transaction.i.e will be incremented for every day and should again reset for the next day-Length -4 Purpose code -Purpose code of the transaction.

View 8 Replies View Related

SQL & PL/SQL :: Sequence Reset Enquiries

Jan 13, 2011

I had a question with regards to the reset of sequence in DB.

From what I had know, there are 2 ways of reseting it...

1. Alter Sequence method

2. Drop and Create Sequence method.

It seems to me (from what I find online )that Alter method is much preferred. Why is this so? Is there any impact using Drop and Create Sequence method?

View 2 Replies View Related

Reset Sys Password With Passwordfile Set To Shared?

Aug 29, 2012

Just trying to figure out a way to reset a lost sys password.The Customer has a database that were configured by the application provider.They were however kicked out and did not leave any kind of documentation behind

they also configured the passwordfile to disable OS (oracle) user to login to the DB.Is it possible to change the password file with orapwd to set a new password for the sys user?I some how recall that it can only be done if the passwordfile is set to exclusive and not as in this case set to shared.

View 3 Replies View Related

Server Administration :: How To Reset Parameter Value

Dec 9, 2011

I often use "alter session set xxx=xxx;" command to change parameter value temporarily. After that, how to reset parameter value to default and I don't want logout sqlplus.

View 3 Replies View Related

Java Application - Connection Reset During Insert

Jun 6, 2012

I have a java application (jdk 6) that use a db oracle 11g with ojdbc6.jar version 11.2.0.1.0 on linux.

Sometimes (one or two cases on 11k sql insert on table in one day) I obtain, the error:

java.sql.SQLRecoverableException I/O Error: Connection reset
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:866)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1259)
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1469)
oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.ja
va:389)
...

View 1 Replies View Related

Expired Account Need To Open Without Password Reset?

Aug 14, 2013

Account XYZ has expired and we don't know the password of account xyz and don't want reset the password also. How can open account XYZ without change the password?

View 1 Replies View Related

Reset Password - Oracle 9i Developer Database?

Aug 27, 2007

I have an Oracle 9i developer database on my Windows workstation. I havent used it in a couple weeks and forgot my Sysdba login password. how I can reset it or get into the database?

View 6 Replies View Related

Forms :: FRM-92100 Your Connection To Server Was Reset

Jun 23, 2013

I have developed an application Customer Call Handling where the main form of the Application has about 42(Data & Control) Blocks, many canvases and windows.This main form Calls many other forms which all work fine. But whenever this Main form is Cleared,Queried it calls the Code gems_ proc_ clear which has CLEAR_FORM(NO_VALIDATE).Immediately after the Clear_form(no_validate) is fired it throws this error FRM-92100.

On Save too, the form needs to be cleared once data is saved. The save works fine. but when the call to gems_proc_clear is made after save it throws the error again.

Since its the main form of the application, The Call Center users are having difficulty Clearing or Querying the form.

The forms have been developed in Forms 6i Version and work absolutely fine in 6i Test-Server Environment. But the moment we run the Forms in the Live Server(Oracle 11G) Environment when the form is Cleared,Queried this error throws.

View 1 Replies View Related

Replication :: Reset The Status Of Refresh Group?

Jul 25, 2008

How to reset the status of Refresh Group?

In our database, it is showing the status of Refresh group to 'Broken'.

View 6 Replies View Related

PL/SQL :: How To Reset Primary Key to 1 Using Store Procedure

Mar 19, 2013

I have created table and i am using sequence to increment primary key value.

Now i need to delete the table content and reset primary key to 1 using store procedure.

View 18 Replies View Related

User Unable To Login Even After Password Reset

Nov 27, 2012

10.2.0.3 on Linux

I reset a user password and the user is unable to login as you can see below

[oracle@testdb 10.2.0]$ sqlplus sys/manager as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Nov 27 16:20:21 2012

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> alter user sysman identified by oracle;

User altered.

SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production With the Partitioning, OLAP and Data Mining options

[oracle@testdb 10.2.0]$ sqlplus sysman/oracle

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Nov 27 16:20:32 2012

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

ERROR: ORA-01017: invalid username/password; logon denied

User unable to login even after password reset

View 4 Replies View Related

Security :: User Unable To Login After Password Reset

Dec 14, 2011

We have a production database on 11.2.0.2 version. The application user was prompted to change the password after his password expired.

USERID NTIMESTAMP# ACTION# RETURNCODE
------------------------------ --------------------------------------------------------------------------- ---------- ----------
M500796 13-DEC-11 06.11.06.065209 PM 100 28001

After changing the password he is not able to logon. The aud$ table does not show any occurrence of 1017, therefore it is not a question of Invalid password.

LVV> show parameter SEC_CASE_SENSITIVE_LOGON

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean FALSE

View 2 Replies View Related

JDeveloper, Java & XML :: Reset Expired Password On Database?

Jan 2, 2013

I'm trying to write short program to reset password on databases. I'm trying to use OCINewPassword property with following

public void ResetPassword(String sOldPass, String sNewPass) {
this.sCurrent = sOldPass;
this.sNewPassword = sNewPass;
Properties props;
Connection conn = null;

[code]....

View 4 Replies View Related

Application Express :: Oracle 11g XE - Retrieve Or Reset Password

Dec 12, 2012

I cannot remember my password to access an existing database in Application Express. I tried entering my password 3 times, but the system does not provide a status other than 'Invalid Login Credentials'.

I am going to assume that 3 times is limit before you have to reset the password or from what I see reinstall. When selecting reset, the system asks for an email address that was never established in the system. How can I reset my password without uninstalling and reinstalling Oracle 11g XE?

View 10 Replies View Related

Incarnation Backup - Compulsory To Take After Open Reset Logs?

Sep 25, 2013

WHAT IS INCARNATION BACKUP......IS IT COMPULSORY TO TAKE AFTER OPEN RESETLOGS.....WHAT WILL HAPPEN IF WE TAKE INCARNATION BACKUP..........

View 1 Replies View Related

Application Express :: 2 Schemas - Admin Password Reset

Feb 7, 2013

We have 2 apex schemas

APEX_030000
APEX_040200

Before executing the apxchpwd.sql, found the "alter session command" sets schema to APEX_030000. So we changed that to APEX_040200. Then we executed the sql script. It executed fine.

But now when we try to login to apex, and pressing enter after providing the username/pwd, it raises the following exception

Error Error in PLSQL code raised during plug-in processing.
ORA-06508: PL/SQL: could not find program unit being called

View 1 Replies View Related

Application Express :: Cascading LOV - Selections Not Sticking / Reset?

Jul 12, 2012

I have a series of cascading LOVs, A, B, C, D, E.

These select values for a tabular form. My problems:

1. Select on A does not always clear C, but does clear B, D and E.

2. Select on B does not "stick" after the first selection. That is, I can select a value once, then all subsequent selections reset themselves to that first selection, or, to NULL (there are a few flavors of this)

I do not have any Dynamic Actions on the page, other than what is in the cascading LOVs.

Debug is not listing anything to notice - as i suspected would be the case. The issue has to be with JS somewhere, but I do not know how to track it or fix it, short of deleting these items and rebuilding them.

I have copied these items from one page to another.

I would think that once I update all of the cascading LOV settings, the underlying JS would get updated as well.

View 1 Replies View Related

Backup & Recovery :: Oracle Database Recover Using Reset Archivelogs

Jan 24, 2011

We have faced database(10.2.0) issue cause incomplete recovery and have performed open resetlogs. This DB is of 12Tb. In 10g opening database with reset logs do not invalidate previous backups. we have another replica(no reset state)of this database which we sync using archives.how we can apply those archives(reset database)to previous database?

View 7 Replies View Related

Server Administration :: Deprecated Parameter Not In Spfile And Cannot Reset In Memory?

Apr 12, 2013

i try to startup a database, and get that obsolete/deprecated parameter specified(ORA-32004: obsolete and/or deprecated parameter(s) specified)so i try to reset the parameter, but it seems it is already reset(not in spfile), so maybe this is in memory. SO now i try to reset with scope = memory or both, it gives this error(ORA-32029: resetting with SCOPE=MEMORY or SCOPE=BOTH is currently not supported).

what to do, because now i cannot reset with scope = memory and in spfile it is not there but still it comes in deprecated parameter.

View 7 Replies View Related

Data Guard :: Logs Get Shipped But Not Applied - Due To Primary Database Reset

Jul 22, 2013

I have a Sap Primry Database and also a standby db that was working perfectly.. We migrated the primary db from windows 2003 to windows 2008 and brought the primary db up.. I had to create a controlfile and do a system copy and had to reset the logs on the Primary.. All came up and when i checked the standby it was receiving the logs but after a month. i see that it was not applying the logs as I think because of the sequence number .. it stopped.

I did the ffg as per the attachement...My logs have been shipped across but not applied, But What worrries me is the log sequence number on my Primary

SQL> select max(sequence#),thread# from gv$archived_log group by thread#;

MAX(SEQUENCE#) THREAD#
-------------- ----------
27727 1

View 15 Replies View Related

Application Express :: Prevent Reset For Default Search Column In Interactive Report

Jul 19, 2013

I have created a IR report and I set the default search column  using the suggestion found in the thread URL....but how can I keep this default even after the research was done?Now it is resetted ! 

View 1 Replies View Related

Streams :: Apply Archivelog / Generated Before Reset-log Of Source Database In Destination Database

Feb 9, 2013

Database Version - 10.2.0.4.0
OS - Red Hat Linux

We have configured oracle one way stream between two databases. Source database is capturing the changes (No downstream configured). Configuration was working fine but destination database was lagging behind very much i.e about 15 days behind the source database. We are ok with this but the problem is now that , as per client request we have restored previous backup and open the database with resetlog option in source database. After resetlog , archivelog sequence has been changed and stream is not working.

Can I apply the previous archivelog (before resetlog archivelogs ) in destination database anyway.Source database is a production database.

View 1 Replies View Related

PL/SQL :: Reset Date In Specific Format (Date / Time)

Dec 23, 2012

I want to reset my date to this format: 12/31/2012 11:59:59 PM - see code below:

DECLARE
v_latest_close DATE;
BEGIN
v_latest_close := TO_DATE ('12/31/2012 23:59:59 ','MM/DD/YYYY HH24:MI:SS');
DBMS_OUTPUT.PUT_LINE('The new date format is : '|| v_latest_close);
END;

the code above displays only : 12/31/2012 instead of 12/31/2012 11:59:59 PM

View 4 Replies View Related

Reports & Discoverer :: How To Find Page Number And Total Number Of Pages

Jan 26, 2010

i am using oracle developer 6i report builder i required this type of query

example

if (:page number LIKE '1')
then
srw.set_text_color('darkred');
end if;

return (TRUE);
end;

but page number is not my table database item how can i use builtan page &<pagenumber> use for conditional format.

View 34 Replies View Related

SQL & PL/SQL :: Replacing 4 Digit Number In A Given String With The Same Number Incremented By 10000?

Jun 17, 2010

i want to replace 4 digit number in a given string with the same number incremented by 10000.

That mean in the given sting 1201 should be replace by 11201 (Icremented BY 10000).

Input String:

<query><matchAll>true</matchAll><row><columnId>1201</columnId><dataType>31</dataType><op>Like</op><val>North America - Houston</val></row><row><columnId>1212</columnId><dataType>31</dataType><op>!=</op><val>Agreement Date Mismatch</val></row><row><columnId>1212</columnId><dataType>31</dataType><op>!=</op><val>Facility Type Mismatch</val></row><row><columnId>1224</columnId><dataType>31</dataType><op>Like</op><val>y</val></row></query>

Required output :

<query><matchAll>true</matchAll><row><columnId>11201</columnId><dataType>31</dataType><op>Like</op><val>North America - Houston</val></row><row><columnId>11212</columnId><dataType>31</dataType><op>!=</op><val>Agreement Date Mismatch</val></row><row><columnId>11212</columnId><dataType>31</dataType><op>!=</op><val>Facility Type Mismatch</val></row><row><columnId>11224</columnId><dataType>31</dataType><op>Like</op><val>y</val></row></query>

View 7 Replies View Related

SQL & PL/SQL :: Extract Number And Previous Character From Where 5 Digit Number Starting

Oct 21, 2011

I have a text field and if the text field has 5 consecutive numbers then I have to extract the number and the previous character from where the 5digit number starting

For example i/p asdfasfsdS251432dasdasd o/p should be S251432

View 10 Replies View Related







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