RDBMS Using Notepad++ to Execute Oracle SQL

 

Using Notepad++ to Execute Oracle SQL

Here are the steps:

1. Launch Notepad++
2. Main menu -> Plugins -> Plugin Manager -> Show Plugin Manager
3. Available Tab, Find and check NppExec plugin   
4. Press Install button to download & install plugin – restarts Notepad++
5. Open a SQL script
6. Press F6 key (NppExec’s default keyboard mapping for “Execute Statement”)
7. Enter the following macro script into the Execute pop-up

set ORA_USER=bert

set ORA_PASS=bert1234

set ORA_SID= ORCL

npp_save

cmd /c copy /y "$(CURRENT_DIRECTORY)\$(FILE_NAME)" "$(SYS.TEMP)\$(FILE_NAME)" >nul 2>&1

cmd /c echo. >> "$(SYS.TEMP)\$(FILE_NAME)"

cmd /c echo exit >> "$(SYS.TEMP)\$(FILE_NAME)"

sqlplus -l $(ORA_USER)/$(ORA_PASS)@$(ORA_SID) @"$(SYS.TEMP)\$(FILE_NAME)"

1. Change the first three variables for your database, username and password
2. Press the OK button

RDBMS Install Oracle Database Express Edition in Windows 10

 

Oracle Database Express Edition

Oracle Database 11g Express Edition

Click Free Download and follow the instructions to select and download the Microsoft Windows version of Oracle Database XE.

Click here to download

After downloading the Oracle Database XE installation executable, setup.exe, double-click it.

In the Oracle Database 11g Express Edition - Install Wizard welcome window, click Next.

In the License Agreement window, select I accept the terms in the license agreement and then click Next.

In the Choose Destination Location window, either accept the default or click Browse to select a different installation directory. (Do not select a directory that has spaces in its name.) Then click Next.

If you are prompted for a port number, then specify one.

The following port numbers are the default values:

• 1521: Oracle database listener

• 2030: Oracle Services for Microsoft Transaction Server

• 8080: HTTP port for the Oracle Database XE graphical user interface

If these port numbers are not currently used, then the installation uses them automatically without prompting you. If they are in use, then you will be prompted to enter an available port number.

In the Specify Database Passwords window, enter and confirm the password to use for the SYS and SYSTEM database accounts. Then click Next.

In the Summary window, review the installation settings, and if you are satisfied, click Install. Otherwise, click Back and modify the settings as necessary.

Enabling the Control Panel Services for .NET Stored Procedures and Oracle Services for Microsoft Transaction Server

1. Select Start, then Control Panel.

2. In the Control Panel, double-click Administrative Tools, and then Services.

3. Right-click each of the following services, and then select Properties from the menu. Then set the start-up type of the service to Automatic.

   • OracleXEClrAgnt (for .NET stored procedures)

   • OracleMTSRecoveryService (Oracle Services for Microsoft Transaction Server)

4. Click OK.

5. Start each service by right-clicking its name and selecting Start from the menu.

ASP.NET Theory Assignment 1

ASP.NET Theory Assignment 1

Click here to download the file

ASP.NET Theory Assignment 1

Write answers of following questions in detail.

All questions are grouped based on the topic.

1. Basics of ASP.NET

================

1) Developer productivity in ASP.NET.

2) Explain major features added in ASP.NET. Also explain how ASP.NET

provides more developer productivity.

3) Write a note on common language runtime.

4) Write note on .NET Framework.

5) Explain page class with its properties, events, and methods.

6) Define Code sharing model in ASP.NET. Explain code directory model in

detail.

7) Explain Page Life Cycle in detail.

8) Demonstrate the use of Application object in ASP.NET.

9) Explain MSIL.

10)What is Response Object? Explain its properties and methods.

11)Discuss significance of Post Back mechanism.

2. Validation Controls

=================

1) What is advantage of validator control? List validator controls and explain

range validator and regular expression validator in detail.

2) Explain Range Validator control.

3) Explain in detail Validation controls.

4) List out various Validation controls and explain any two in detail.

5) Explain Custom Validation control.

3. Navigation Controls

=================

1) Discuss navigation controls.

2) Explain Menu Control.

3) Explain SiteMapPath control.

4. Master Page

============

1) What are advantages of master page over CSS? Explain nested master

page in detail.

2) What is Master Page? Why we need it? Explain briefly about nested

master page.

3) Write note on Master Page.

4) What is Master Page? Explain it in detail along with the Content Page.

5. Theme & CSS

=============

1) Write detailed note on Theme.

2) Explain Theme and CSS.

3) Explain Theme in detail.

6. Login Controls

==============

1) Explain Login Control, LoginName and LoginStatus with its properties.

2) List out all Login Controls. Explain Login Control and Password Recovery

control with its properties.

RDBMS SQL LIVE to test your SQL queries

Introduction to SQL

This tutorial provides an introduction to the Structured Query Language (SQL), learn how to create tables with primary keys, columns, constraints, indexes, and foreign keys.

 https://livesql.oracle.com/apex/livesql/file/tutorial_D39T3OXOCOQ3WK9EWZ5JTJA.html

RDBMS Oracle Database XE Download Link

 

Oracle Database XE Download Link

Oracle Database Express Edition (XE) Release 11.2.0.2.0 (11gR2)

https://www.oracle.com/database/technologies/xe-prior-releases.html

RDBMS Using Notepad++ to Execute Oracle SQL

 We can use Notepad++ to execute oracle sql queries and programs without switching from notepad++ to oracle. just follow the steps given in the link

Using Notepad++ to Execute Oracle SQL

https://community.oracle.com/blogs/bertscalzo/2016/11/27/using-notepad-to-execute-oracle-sql