Profile cover photo
Profile photo
Susanto Paul
About
Posts

Post has attachment
ORA-12992: cannot drop parent key column
Requirement: Solution for ORA-12992: cannot drop parent key column. We will get the above error when we try to drop any column which is a foreign key is some other table. For solution of th above requirement follow the steps as shown below: Step 1: Create t...
Add a comment...

Post has attachment
Add a comment...

Post has attachment
ORA-04091: table XXX is mutating, trigger/function may not see it
Requirement: Solution for mutating table error. The error description is given below. Error: Error description is given below. ORA-04091: table SYSTEM.STUDENTS is mutating, trigger/function may not see it ORA-06512: at "SYSTEM.TRG_STUDENT", line 6 ORA-04088...
Add a comment...

Post has attachment
Retrieve the nth highest or nth lowest column value from a table
Requirement: How to retrieve the n th highest or nth lowest emp_salary from the  EMP table? Let us take the question in a better way. Let us suppose we have an EMP table with the data as shown below. Now we want to retrieve the n th highest emp_salary AND  ...
Add a comment...

Post has attachment
Susanto Paul commented on a post on Blogger.
Even for the creation of other objects like table we need to have this privilege

GRANT CREATE TABLE TO gsmuser;
Add a comment...

Post has attachment
Add a comment...

Post has attachment
Change the password for the Oracle Database Schema
To change the password for the Oracle Database Schema, connect to the Admin Schema ( SYS or SYSDBA )  and use the below  command. alter user SYSTEM identified by SYSTEM; If you like the post, please comment, share the post and do like me on Facebook Thanks ...
Add a comment...

Post has attachment

Post has attachment
Display list of available schema in Oracle Database
To display list of available schema in Oracle Database use the below command. select USERNAME from SYS.ALL_USERS; If you like the post, please comment, share the post and do like me on Facebook Thanks & Regards, Susanto Paul.
Add a comment...

Post has attachment
Wait while more posts are being loaded