Skip to main content

Update record set in same column with max id in it(2 Cursors update) 


DECLARE 
CURSOR C1 IS
SELECT MAX(COLUMN_NAME1) AS HEADERID FROM TABLE_NAME WHERE CONDITIONS ;


CURSOR C2 IS
SELECT ID FROM TABLE_NAME WHERE CONDITIONS AND COLUMN_NAME1 IS NULL;

L_MAX_HEADERID number;
BEGIN 


OPEN C1;
FETCH C1 INTO L_MAX_HEADERID;
CLOSE C1;

FOR R1 IN C2

LOOP

L_MAX_HEADERID :=L_MAX_HEADERID+1;

UPDATE TABLE_NAME SET
       COLUMN_NAME1=L_MAX_HEADERID
       WHERE ID=R1.ID;
       
       
       
END LOOP;
END;

Comments

Post a Comment

Popular posts from this blog

Scraping HTML Content using Python

To Scrape Data using python we are using BeautifulSoup python Package !pip install beautifulsoup4 As a first step we have to import the packages and html page that we need to scrape. In here I have used some static HTML content which was customized to scrape the data. #imports import requests from bs4 import BeautifulSoup #html HTML Sample Doing Data Science with Python Doing Data Science with Python Author: Eranda Kodagoda This will help to perform various data science activitied using python Modules Title Duration in minutes Getting Started 20 Setting Up Environment 40 Extracting Data 30 Exploring and Processing Data 45 Building Productive Model 45 To View the HTML using beautifulsoup we can use below code-lines and execute on python executor from IPython.core.display import display, HTML display(HTML(html_string)) To Print the HTML using beautifulsoup we can use below code-lines and execute on python executor ps=Be...
Post a Comment
Read more

Basics of Data Science with Python

About Data Science with Python From this module I will post some interesting posts about Data science and how to gather information and process them using Python and for that I will be using below softwares  Python 3.6 Anaconda Jupyter Notebook PyCharm by JetBrains In the posts I will include fundamentals of Python  programming techniques such as lambdas, reading and manipulating csv files, and the numpy library. And In the posts I will be doing a simple Data Challange which is available on Kaggle and I will provide the URL's to the github repo which I will be posting the whole module once it finished. In Future I will be post some articles related to Applied Data Science with Python: Applied Plotting, Charting & Data Representation in Python, Applied Machine Learning in Python, Applied Text Mining in Python, Applied Social Network Analysis in Python
1 comment
Read more

Selenium WebDriver Cheat Sheet

Below are some important code samples for those who are willing to learn Selenium automation. Driver Initialization WebDriver driver ; driver = new ChromeDriver() ; driver = new FirefoxDriver() ; driver = new SafariDriver() ; driver = new InternetExplorerDriver() ; driver = new EdgeDriver() ; // Driver Profiling //Firefox //Load Firefox System. setProperty ( "webdriver.firefox.bin" , "path/to/driver" ) ; FirefoxProfile profile = new FirefoxProfile() ; //load with add-on File file = new File( "path/to/add-on" ) ; profile.addExtension(file) ; //profile settings (setting up desired capabilities) DesiredCapabilities capabilities= new DesiredCapabilities() ; capabilities.setCapability(FirefoxDriver. PROFILE , profile) ; WebDriver driver = new RemoteWebDriver(capabilities) ; //Chrome Options System. setProperty ( "webdriver.chrome.driver" , "/path/to/chrome/driver" ) ; ChromeOptions options = new ChromeOption...
Post a Comment
Read more