,

Browse Oracle 9i SQL Solutions


   
78 Solution(s) found
Oracle 9i SQL
0 ratings
Views 65
Oracle PL/SQL Error Handler
If any error is there in PL/SQL object then i will be handle.

Oracle 9i SQL
0 ratings
Views 322
Secure the data in the database
How to hack the data in the database?

Oracle 9i SQL
0 ratings
Views 423
how to get back user schema if it is dropped?
I have accidentally dropped a schema owner and all of the table data has disappeared! How can I recover an Oracle user ID and its tables? I will get fired if they found out that I dropped a production user ID and lost the table data.

Oracle 9i SQL
0 ratings
Views 326
how to get back user schema if it is dropped?
I have accidentally dropped a schema owner and all of the table data has disappeared! How can I recover an Oracle user ID and its tables? I will get fired if they found out that I dropped a production user ID and lost the table data.

Oracle 9i SQL
10 ratings
Views 445
NVL function need in oracle
Consider a situation where we want to select all null values ,but normal in java program selecting null and displaying may show null pointer exception to we use nvl

Oracle 9i SQL
6 ratings
Views 451
Updating a column of table in oracle with value inside the table itself and vale outside the table
Problem1: Updating the column with value from a table itself Problem2: Updating the column with value from a another table

Oracle 9i SQL
0 ratings
Views 539
OVER AND PARTITION BY
A quick summary of OVER and PARTITION BY 1..Write program to add marks of student in all depatments and display as marks of each student 2.Write program to add marks of student in same depatments and display as marks of each student

Oracle 9i SQL
0 ratings
Views 557
Oracle With Clause Example
Write a sql query with the help of With Clause. As an example, we will do a operation by dividing the mark of student with the total number of students in each DEPARTMENT.

Oracle 9i SQL
0 ratings
Views 362
Behavioral Science Based
Recognizing different people behavior and storing their database when ever same behavior to determine their behavior.

Oracle 9i SQL
8 ratings
Views 437
Database Testing :What is the difference between Having & where function ?
What is the difference between Having & where function ?



Advertisement