CREATE OR REPLACE PROCEDURE createUser
(corpId IN VARCHAR2, passwd IN VARCHAR2) IS
-- [declaration_sec tion]\
DDL_STMT VARCHAR2(400);
BEGIN
-- executable_sect ion
DDL_STMT:= 'CREATE USER "'|| corpId || '" IDENTIFIED BY "' || passwd || '" DEFAULT TABLESPACE RDSADMIN TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK';
DBMS_OUTPUT.PUT _LINE('DDL STATEMENT...
pritikumari
Banned
Last Activity: Mar 30 '23, 07:22 AM
Joined: Jan 27 '23
Location:
-
Open your report and go to the File menu select Report options then check the option Use index or server for speed.
Go to the ODBC Data Source definition for the Progress DB, select the Configure button, then select the Advanced tab.
Change the value for Fetch Array Size.Leave a comment:
-
RMAN Enhancements in 11g.
Duplicating a Database.
Creating a Standby Database with the DUPLICATE Command.
Parallel Backup and Restore for Very Large Files.
IMPORT CATALOG RMAN Command.
RMAN Data Recovery Commands.
RMAN Security Enhancements.
Improved Integration of RMAN and Data Guard.
JOIN Oracle Training In Noida.Leave a comment:
-
Connecting Oracle to PostgreSQL.
Download the 64-bit PostgreSQL ODBC driver for Linux.
Install and license the PostgreSQL ODBC driver on the machine where Oracle is installed. ...
Create an ODBC data source in /etc/odbc.ini that connects to the PostgreSQL database you want to access from Oracle.
JOIN Autocad Training In Noida.Leave a comment:
-
For create a schema
In Object Explorer, expand the Databases folder.
Expand the database in which to create the new database schema.
Right-click the Security folder, point to New, and select Schema.
In the Schema - New dialog box, on the General page, enter a name for the new schema in the Schema name box.Leave a comment:
-
For create a schema for existing database.
In Object Explorer, expand the Databases folder.
Expand the database in which to create the new database schema.
Right-click the Security folder, point to New, and select Schema.
In the Schema - New dialog box, on the General page, enter a name for the new schema in the Schema name box.Leave a comment:
-
Most common problem how to find most and least used tables in SQL Server. This will help us in cleaning database and organize tables which we use and delete the unnecessary tables.
I created a SQL job runs every 3 hours to take backup of above view and incrementally load the temp table with new data. In this approach even the view data is lost, we still have the backup data in temp tables. After a month or so we have enough data to...Leave a comment:
-
You can achieve this by adding new item named 'ROWNUM'. in the Data Block you are working on. And it's 'BASE TABLE ITEM' property needs to be set as TRUE'. IN the property ,IN the post-query Trigger use
BEGIN
IF :SYSTEM.Cursor_ Record = '1'
THEN
MESSAGE ('At first record.');
END IF;
END;
Join Oracle Training In Noida.Leave a comment:
-
A trigger is fired based on a triggering statement, which specifies: The SQL statement or the system event,
database event, or DDL event that fires the trigger body.
The options include DELETE , INSERT , and UPDATE .
One, two, or all three of these options can be included in the triggering statement specification.
You can take Oracle Course In Noida.Leave a comment:
-
I have written a very simple query which result a value 500, i need to convert this value like following:-
old value = 500
new value = FIVE HUNDERED/=
You can opt Oracle Training In Noida.Leave a comment:
-
Lean product development is a process for building products faster with less waste. It improves upon traditional product development processes by eliminating the communication silos that typically separate departments.Leave a comment:
-
Open your JPEG file in the Picsart Editor and apply any necessary edits such as filters, stickers, background removal, etc. When you're done, simply save the image and Picsart will convert it to a PNG for you.Leave a comment:
-
In the dialog that opens, choose the rename strategy.
If the project name is the same as the name of its root folder, select Rename directory.
PyCharm will perform the Rename refactoring so that all the references to the directory throughout the code remain valid.
If the project name is different from the name of its root folder, select Rename project.
Alternatively, select File | Rename...Leave a comment:
-
sprintf and snprintf are the functions used in C language to write the programs were both works in a different manner.
String print represented by sprintf stores the output on character buffer noted in sprintf and not in the console as other functions.
A formatted string is stored in the variable for sprintf. The output of printf is redirected to any buffer so that repetition of the string is avoided in snprintf.
The buffer...Leave a comment:
-
You can use these methods for shutdown system after 3 minutes.
Change the Registry setting for Power down After Shutdown.
Turn off the automatic restart option when a system failure occurs.
Turn off the hibernation feature.
Check the behavior of the power button setting.
Disable fast startup.Leave a comment:
-
class Solution {
public:
string shortestPalindr ome(string s) {
}
};Leave a comment:
-
METHODS OF C++ DEMO PROJECT
Create a folder for our C++ program.
Navigate to that folder.
Create our C++ program from a text editor (I used Visual Studio Code).
Compile our source code into object files.
Link our object files to produce*an*exec utableLeave a comment:
-
He beginning, the easiest way to start with refactoring is to do it on a method level.
A quick thing to check first is if the method is too long.
An extended method is a classic sign of the process being too much, and it would probably benefit by splitting it into several other smaller*methods .
METHODS OF REFACTORING
Get rid of switch statements.
Make your conditionals descriptive.
...Leave a comment:
-
In Java there is default value for every type, when you don’t initialize the instance variables of a class Java compiler initializes them on your be-half with these values. Null is the default value of the object type, you can also manually assign null to objects*in*a*me thod.Object obj = null;
But, you cannot use an object with null value or (a null value instead of an object)*if*you* do*so
EXAMPLE
public class...Leave a comment:
-
API testing is an essential part of the software development process because it helps to ensure that APIs are working as expected and that they can handle the load that will be placed on them when the software is released. Additionally, it can help to identify potential security vulnerabilities in the API before the software*is*rel eased.
There are many API testing tools available. Here are a couple of tips to watch out for.
...Leave a comment:
No activity results to display
Leave a comment: