Tutorial by Examples: p

For I as Integer = 1 To 10 Step 1 code to execute Next Step is optional and Step 1 is the default. Step tells it how to count, so -1 would have it subtract 1 each time and Step 5 would have it add 5 each time thru the loop. In case the loop need to be stopped, then the Exit For statement c...

Datapump jobs can be monitored using 1. data dictionary views: select * from dba_datapump_jobs; SELECT * FROM DBA_DATAPUMP_SESSIONS; select username,opname,target_desc,sofar,totalwork,message from V$SESSION_LONGOPS where username = 'bkpadmin'; 2. Datapump status: Note down the j...

create or replace directory DATAPUMP_REMOTE_DIR as '/oracle/scripts/expimp';

Commands: expdp <bkpadmin>/<bkp123> parfile=<exp.par> *Please replace the data in <> with appropriate values as per your environment. You can add/modify parameters as per your requirements. In the above example all the remaining parameters are added in parameter files as...

Prerequisite: Prior to user import it is a good practice to drop the schema or table imported. Commands: impdp <bkpadmin>/<bkp123> parfile=<imp.par> *Please replace the data in <> with appropriate values as per your environment. You can add/modify parameters as per...

Source Server [Export Data]Target Server [Import Data]1. Create a datapump folder that will contain the export dump files4. Create a datapump folder that will contain the import dump files2. Login to database schema that will perform the export.5. Login to database schema that will perform the impor...

expdp <bkpadmin>/<bkp123> directory=DATAPUMP_REMOTE_DIR dumpfile=<customer.dmp> impdp <bkpadmin>/<bkp123> directory=DATAPUMP_REMOTE_DIR dumpfile=<customer.dmp> remap_schema=<source schema>:<target schema> remap_tablespace=<source tablespace&g...

There are some situations where you won't be sure what type a variable is when it is returned from a function. You can always check a variable's type by using var.(type) if you are unsure what type it is: x := someFunction() // Some value of an unknown type is stored in x now switch x := x.(type...

This workaround helped us so much at my job (Tech Support), we made a simple batch file we could run from anywhere (We didnt have the permissions to install the actual exe). This workaround will run OpenSSL and open up the bin folder for you (cause this is where any files you create or modify will b...

public function house() { $config['base_url'] = site_url().'/user/house/'; $config['total_rows'] = $this->houses->select_row_house_design(); $config['per_page'] = 12; $config['cur_tag_open'] = '<li><a><b>'; $config['cur_tag_close'] = '&...

/* these IN and OUT filerefs can point to anything */ filename in "anyfilehere.xlsx"; filename out "anyfilehere.xlsx"; /* copy the file byte-for-byte */ data _null_; length filein 8 fileid 8; filein = fopen('in','I',1,'B'); fileid = fopen('out','O',1,'B'); ...

First, I will place my date into a Macro Variable. NOTE: I find that date9. works great with IBM® Netezza® SQL and Transact-SQL. Use whichever format that works for the type of SQL you're executing. data _null_; call symput('testDate',COMPRESS(put(today(),date9.))); ;RUN; %PUT ...

private string AddGraph(WordprocessingDocument wpd, string filepath) { ImagePart ip = wpd.MainDocumentPart.AddImagePart(ImagePartType.Jpeg); using (FileStream fs = new FileStream(filepath, FileMode.Open)) { if (fs.Length == 0) return string.Empty; ip.FeedData(fs); ...

Install JSON Model Genrator plugin of Intellij by searching in Intellij setting. Start the plugin from 'Tools' Input the field of UI as following shows ('Path'、'Source'、'Package' is required): Click 'Generate' button and your are done.

There will be times where you only want to import a specific sheet from an excel file with multiple sheets. To do that, we'll use "SHEET=". PROC IMPORT OUT= YourNewTable DATAFILE= "myfolder/excelfilename.xlsx" DBMS=xlsx REPLACE; SHEET="Sheet1&quo...

pip install scons If you are not to run scons from command line, check that Python scripts directory is added to PATH for your installation. If you want to play with API, import SCons from Python won't work, because SCons 2.5.x and below allows to install multiple versions side-by-side. This was...

Detailed instructions on getting teechart set up or installed.

Using PROC SQL is a good way to get quick results from a table and throw them into variables. I usually find that when I want to get a count of records I just loaded to a table, I can get that count into a variable with a quick PROC SQL call. PROC SQL; SELECT COUNT(*) INTO:aVariable FROM ...

DATA _null_; CALL SYMPUT('testVariable','testValueText'); ;RUN; In the example above, %PUT &testVariable; will resolve to testvalueText. You may find the need to format your variable within the SYMPUT() call. DATA _null_; CALL SYMPUT('testDate',COMPRESS(PUT(today(...

Here follows a example of what can be done with nested StackViews, giving the user the impression of a continuous scrolling experience using complex user interface elements or alignments.