24 December 2015

Macbook Pro Shortcuts

Mac keyboard shortcuts
To use a keyboard shortcut, hold down one or more modifier keys while pressing the last key of the shortcut. For example, to use the shortcut Command-C (copy), hold down Command, press C, then release both keys. Mac menus and keyboards often use symbols for certain keys, including the modifier keys:
If you're using a keyboard made for Windows PCs, use the Alt key instead of Option, and the Windows logo key instead of Command. Some Mac keyboards and shortcuts use special keys in the top row, which include icons for volume, display brightness, and other functions. Press the icon key to perform that function, or combine it with the Fn key to use it as an F1, F2, F3, or other standard function key. 
To learn more shortcuts, check the menus of the app you're using. Every app can have its own shortcuts, and shortcuts that work in one app may not work in another. 

Cut, copy, paste, and other common shortcuts
          Shortcut          
Description
Command-X
Cut: Remove the selected item and copy it to the Clipboard.
Command-C
Copy the selected item to the Clipboard. This also works for files in the Finder.
Command-V
Paste the contents of the Clipboard into the current document or app. This also works for files in the Finder.
Command-Z
Undo the previous command. You can then press Command-Shift-Z to Redo, reversing the undo command. In some apps, you can undo and redo multiple commands.
Command-A
Select All items. 
Command-F
Find: Open a Find window, or find items in a document.
Command-G
Find Again: Find the next occurrence of the item previously found. To find the previous occurrence, press Command-Shift-G.
Command-H
Hide the windows of the front app. To view the front app but hide all other apps, press Command-Option-H.
Command-M
Minimize the front window to the Dock. To minimize all windows of the front app, press Command-Option-M.
Command-N
New: Open an new document or window.
Command-O
Open the selected item, or open a dialog to select a file to open.
Command-P
Print the current document.
Command-S
Save the current document.
Command-W
Close the front window. To close all windows of the app, press Command-Option-W.
Command-Q
Quit the app.
Command-Option-Esc
Force Quit: Choose an app to force quit. Or press Command-Shift-Option-Esc and hold for 3 seconds to force just the front app to quit.
Command–Space bar
Spotlight: Show or hide the Spotlight search field. To perform a Spotlight search from a Finder window, press Command–Option–Space bar. If you use multiple input sources to type in different languages, these shortcuts change input sources instead of showing Spotlight.
Space bar
Quick Look: Use Quick Look to preview the selected item.
Command-Tab
Switch apps: Switch to the next most recently used app among your open apps. 
Command-Shift-Tilde (~)
Switch windows: Switch to the next most recently used window of the front app. 
Command-Shift-3
Screenshot: Take a screenshot of the entire screen. Learn more screenshot shortcuts.
Command-Comma (,)
Preferences: Open preferences for the front app.



Sleep, log out, and shut down shortcuts
               Shortcut              
Description
Power button
Tap to turn on your Mac or wake your Mac from sleep.  
Hold for 1.5 seconds while your Mac is awake to display a dialog asking if you want to restart, sleep, or shut down.
Hold for 5 seconds to force your Mac to turn off.
Command–Control–Power button
Force your Mac to restart.
Command–Option–Power button
Put your Mac to sleep.
Shift–Control–Power button
Put your displays to sleep.
Command–Control–Power button
Quit all apps, then restart your Mac. If any open documents have unsaved changes, you'll be asked whether you want to save them.
Command–Option–Control–Power button
Quit all apps, then shut down your Mac. If any open documents have unsaved changes, you'll be asked whether you want to save them.
Command-Shift-Q
Log out of your OS X user account. You'll be asked to confirm.
Command-Shift-Option-Q
Log out of your OS X user account immediately, without being asked to confirm.
Document shortcuts
               Shortcut              
Description
Command-B
Boldface the selected text, or turn boldfacing on or off. 
Command-I
Italicize the selected text, or turn italics on or off.
Command-U
Underline the selected text, or turn underlining on or off.
Command-T
Show or hide the Fonts window.
Command-D
Select the Desktop folder from within an Open dialog or Save dialog.
Command-Control-D
Show or hide the definition of the selected word.
Command-Shift-Colon (:)
Display the Spelling and Grammar window.
Command-Semicolon (;)
Find misspelled words in the document.
Option-Delete
Delete the word to the left of the insertion point.
Control-H
Delete the character to the left of the insertion point. Or use Delete.
Control-D
Delete the character to the right of the insertion point. Or use Fn-Delete.
Fn-Delete
Forward delete on keyboards that don't have a Forward Delete  key. Or use Control-D.
Control-K
Delete the text between the insertion point and the end of the line or paragraph.
Command-Delete
Select Delete or Don't Save in a dialog that contains a Delete or Don't Save button.
Fn–Up Arrow
Page Up: Scroll up one page. 
Fn–Down Arrow
Page Down: Scroll down one page.
Fn–Left Arrow
Home: Scroll to the beginning of a document.
Fn–Right Arrow
End: Scroll to the end of a document.
Command–Up Arrow
Move the insertion point to the beginning of the document.
Command–Down Arrow
Move the insertion point to the end of the document.
Command–Left Arrow
Move the insertion point to the beginning of the current line.
Command–Right Arrow
Move the insertion point to the end of the current line.
Option–Left Arrow
Move the insertion point to the beginning of the previous word.
Option–Right Arrow
Move the insertion point to the end of the next word.
Command–Shift–Up Arrow
Select the text between the insertion point and the beginning of the document.
Command–Shift–Down Arrow
Select the text between the insertion point and the end of the document.
Command–Shift–Left Arrow
Select the text between the insertion point and the beginning of the current line.
Command–Shift–Right Arrow
Select the text between the insertion point and the end of the current line.
Shift–Up Arrow
Extend text selection to the nearest character at the same horizontal location on the line above.
Shift–Down Arrow
Extend text selection to the nearest character at the same horizontal location on the line below.
Shift–Left Arrow
Extend text selection one character to the left.
Shift–Right Arrow
Extend text selection one character to the right.
Shift–Option–Up Arrow
Extend text selection to the beginning of the current paragraph, then to the beginning of the following paragraph if pressed again.
Shift–Option–Down Arrow
Extend text selection to the end of the current paragraph, then to the end of the following paragraph if pressed again.
Shift–Option–Left Arrow
Extend text selection to the beginning of the current word, then to the beginning of the following word if pressed again.
Shift–Option–Right Arrow
Extend text selection to the end of the current word, then to the end of the following word if pressed again.
Control-A
Move to the beginning of the line or paragraph.
Control-E
Move to the end of a line or paragraph.
Control-F
Move one character forward.
Control-B
Move one character backward.
Control-L
Center the cursor or selection in the visible area.
Control-P
Move up one line.
Control-N
Move down one line.
Control-O
Insert a new line after the insertion point.
Control-T
Swap the character behind the insertion point with the character in front of the insertion point.
Command–Left Curly Bracket ({)
Left align.
Command–Right Curly Bracket (})
Right align.
Command–Shift–Vertical bar (|)
Center align.
Command-Option-F
Go to the search field. 
Command-Option-T
Show or hide a toolbar in the app.
Command-Option-C
Copy Style: Copy the formatting settings of the selected item to the Clipboard.
Command-Option-V
Paste Style: Apply the copied style to the selected item.
Command-Shift-Option-V
Paste and Match Style: Apply the style of the surrounding content to the item pasted within that content.
Command-Option-I
Show or hide the inspector window.
Command-Shift-P
Page setup: Display a window for selecting document settings.
Command-Shift-S
Display the Save As dialog, or duplicate the current document.
Command–Shift–
Minus sign (-)    
Decrease the size of the selected item.
Command–Shift–
Plus sign (+)
Increase the size of the selected item. Command–Equal sign (=) performs the same function.
Command–Shift–
Question mark (?)
Open the Help menu.


Finder shortcuts

          Shortcut          
Description
Command-D
Duplicate the selected files.
Command-E
Eject the selected disk or volume.
Command-F
Start a Spotlight search in the Finder window.
Command-I
Show the Get Info window for a selected file.
Command-Shift-C
Open the Computer window.
Command-Shift-D
Open the desktop folder.
Command-Shift-F
Open the All My Files window.
Command-Shift-G
Open a Go to Folder window.
Command-Shift-H
Open the Home folder of the current OS X user account.
Command-Shift-I
Open iCloud Drive.
Command-Shift-K
Open the Network window.
Command-Option-L
Open the Downloads folder.
Command-Shift-O
Open the Documents folder.
Command-Shift-R
Open the AirDrop window.
Command-Shift-T
Add selected Finder item to the Dock (OS X Mountain Lion or earlier)
Command-Shift-Control-T
Add selected Finder item to the Dock (OS X Mavericks or later)
Command-Shift-U
Open the Utilities folder.
Command-Option-D
Show or hide the Dock. This often works even when you're not in the Finder.
Command-Control-T
Add the selected item to the sidebar (OS X Mavericks or later).
Command-Option-P
Hide or show the path bar in Finder windows.
Command-Option-S

Hide or show the Sidebar in Finder windows.
Command–Slash (/)
Hide or show the status bar in Finder windows.
Command-J
Show View Options.
Command-K
Open the Connect to Server window.
Command-L
Make an alias of the selected item.
Command-N
Open a new Finder window.
Command-Shift-N
Create a new folder.
Command-Option-N
Create a new Smart Folder.
Command-R
Show the original file for the selected alias.
Command-T
Show or hide the tab bar when a single tab is open in the current Finder window.
Command-Shift-T
Show or hide a Finder tab.
Command-Option-T
Show or hide the toolbar when a single tab is open in the current Finder window.
Command-Option-V
Move: Move the files in the Clipboard from their original location to the current location.
Command-Option-Y
View a Quick Look slideshow of the selected files.
Command-Y
Use Quick Look to preview the selected files.
Command-1
View the items in the Finder window as icons.
Command-2
View the items in a Finder window as a list.
Command-3
View the items in a Finder window in columns. 
Command-4
View the items in a Finder window with Cover Flow.
Command–Left Bracket ([)
Go to the previous folder.
Command–Right Bracket (])
Go to the next folder.
Command–Up Arrow
Open the folder that contains the current folder.
Command–Control–Up Arrow
Open the folder that contains the current folder in a new window.
Command–Down Arrow
Open the selected item.
Command–Mission Control
Show the desktop. This works even when you're not in the Finder.
Command–Brightness Up
Turn Target Display Mode on or off.
Command–Brightness Down
Turn display mirroring on or off when your Mac is connected to more than one display.
Right Arrow 
Open the selected folder. This works only when in list view.
Left Arrow
Close the selected folder. This works only when in list view.
Option–double-click
Open a folder in a separate window and close the current window.
Command–double-click
Open a folder in a separate tab or window.
Command-Delete
Move the selected item to the Trash.
Command-Shift-Delete
Empty the Trash.
Command-Shift-Option-Delete
Empty the Trash without confirmation dialog.
Command-Y
Use Quick Look to preview the files.
Option–Brightness Up
Open Displays preferences. This works with either Brightness key.
Option–Mission Control
Open Mission Control preferences.
Option–Volume Up
Open Sound preferences. This works with any of the volume keys.
Command key while dragging
Move the dragged item to another volume or location. The pointer changes while you drag the item.
Option key while dragging
Copy the dragged item. The pointer changes while you drag the item.
Command-Option while dragging
Make an alias of the dragged item. The pointer changes while you drag the item.
Option-click a disclosure triangle
Open all folders within the selected folder. This works only when in list view.
Command-click a window title

Source : www.apple.com
See the folders that contain the current folder.

16 December 2015

Decoding PERM - US Labor Case Number


PERM A* number:


Of course everyone is interested when the DOL will look through their case. But nobody gives you such information, you can't be even sure, when your case was submitted (unless your attorney tells you). But every case submitted to the DOL through iCert system gets its own unique number. It's usually granted when a draft of the application is created in the system by your attorney. It could be done in advance, but generally the draft is created about 2-3 days prior to the case submission.

Each number consists of the letter "A" and two groups of digits. For example #A-12001-XXXXXX. "A" means that it's a perm application case. Five digital part consists of a two-digit number for the year of the application coming first (12 stands for 2012), followed by a three-digit number meaning the exact day of the year. For example 001 stands for the January 1st, 058 - February 27th and so on, finishing with 366 for December 31st for a leap year. This is the date when the draft was created in the system (but not the date when the application was sent). "XXXXXX" is a unique digital combination for each of this days (this information is not proved by any facts, it's not known if this part of the number means anything specific).

It is possible to tell which group of cases is considered by the DOL at a given moment of time based on the analysis of the cases already reviewed. So if a group of cases with number «A-13100-XXXXXX» was examined during the last week and yours is «A-13101-XXXXXX» you may hope to get the DOL decision soon. But there are no guarantees, cause your case can be set aside for a while or, on the contrary, be reviewed ahead of your “group” with no obvious reason.

02 December 2015

Oracle SQL : How to get greatest value from multiple columns in a single row

Oracle has inbuilt function GREATEST

Example :

SQL> insert into test values(1,10,20,30);
1 row created.
SQL> insert into test values(2,30,10,20);
1 row created.
SQL> insert into test values(3,50,90,60);
1 row created.
SQL> commit;

Commit complete.

SQL> select * from test;

ID A B C
---------- ---------- ---------- ----------
1 10 20 30
2 30 10 20
3 50 90 60

SQL> select greatest(A,B,C) Max_Val from test;

MAX_VAL
----------
30
30
90

25 November 2015

Removing Duplicate Records In a table

Different Removes the duplicate Records from a table,

Option 1. By excluding the minimum row id from the group of duplicate records.

DELETE FROM test1
      WHERE ROWID NOT IN (  SELECT MIN (ROWID)
                              FROM test1
                          GROUP BY rc_no);


Option 2. Using row_number() option.

DELETE FROM test1
      WHERE ROWID IN (SELECT row_id
                        FROM (SELECT ROWID row_id,
                                     x,
                                     y,
                                     z,
                                     ROW_NUMBER ()
                                     OVER (PARTITION BY x, y, z ORDER BY x)
                                        rn
                                FROM test1)
                       WHERE rn > 1)

17 November 2015

Top 12 New Features of Oracle 12c as a developer,




01. Pluggable Databases Through Database Consolidation:
Oracle is doing every thing to jump into the cloud bandwagon. With 12C, Oracle is trying to address the problem of Multitenancy through this feature. There is a radical change and a major change in the core database architecture through the introduction of Container Databases also called CBD and Pluggable Databases (PDB). The memory and process is owned by the Container Database. The container holds the metadata where the PDBs hold the user data. You can create upto 253 PDBs including the seed PDB.

In a large setup, it is common to see 20 or 30 different instances running in production environment. With these many instances, it is a maintenance nightmare as all these instances have to be separately

•Upgraded
•Patched
•Monitored
•Tuned
•RAC Enabled
•Adjusted
•Backed up and
•Data Guarded.

With Pluggable Databases feature, you just have to do all this for ONE single instance. Without this feature, prior to 12C, you would have to create separate schemas and there is always a thread of security how much ever the isolation we build into it. There are problems with namespace conflicts, there is always going to be one public synonym that you can create. With PDBs you can have a separate HR or Scott schema for each PDB, separate Emp, Dept Tables and separate public synonyms. Additionally, 2 PDBs can talk to each other through the regular DB Link feature. There is no high startup cost of creating a database any more. Instead of one instance per day, the shift is into one instance per many databases. For the developer community, you can be oblivious of all this and still continue to use the PDBs as if it were a traditional database, but for the DBAs the world would look like it has changed a lot.

Another cool feature is, you can allocate a CPU percentage for each PDB.

Another initiative being, it has announced a strategic tieup with salesforce.com during the first week of July 2013.

02. Redaction Policy:
This is one of the top features in Oracle 12C. Data Redaction in simple terms means, masking of data. You can setup a Data Redaction policy, for example SSN field in a Employee table can be masked. This is called redaction. From Sql Develop you can do this by going to the table: Employee->Right click on Security Policy->click on New->click on Redaction Policy->Enter SSN.
When you do a select * from employee, it will show that the SSN is masked.
The new data masking will use a package called DBMS_REDACT. It is the extension to the FGAC and VPD present in earlier versions.
By doing this, whoever needs to view the data will be able to see it where as the other users will not be able to view it.

03. Top N Query and Fetch and offset Replacement to Rownum:
With the release of Oracle Database 12c, Oracle has introduced this new SQL syntax to simplify fetching the first few rows. The new sql syntax "Fetch First X Rows only" can be used.

04. Adaptive Query Optimization and Online Stats Gathering:
With this feature, it helps the optimizer to make runtime adjustments to execution plan which leads to better stats. For statements like CTAS (Create Table As Select) and IAS (Insert As Select), the stats is gathered online so that it is available immediately.

05. Restore a Table easily through RMAN:
Earlier if you had to restore a particular table, you had to do all sorts of things like restoring a tablespace and or do Export and Import. The new restore command in RMAN simplifies this task.

06. Size Limit on Varchar2, NVarchar2, Raw Data Types increased:
The previous limit on these data types was 4K. In 12C, it has been increased to 32,767 bytes. Upto 4K, the data is stored inline. I am sure everyone will be happy with this small and cute enhancement.

07. Inline PL/SQL Functions and Procedures:
The in line feature is extended in Oracle 12C. In addition to Views, we can now have PL/SQL Procedures and Functions as in line constructs. The query can be written as if it is calling a real stored procedure, but however the functions do not actually exist in the database. You will not be able to find them in ALL_OBJECTS. I think this will be a very good feature for the developers to explore as there is no code that needs to be compiled.

08. Generated as Identity/Sequence Replacement:
You can now create a col with 'generated as identity' clause. Thats it. Doing this is equivalent to creating a separate sequence and doing a sequence.nextval for each row. This is another handy and a neat feature which will help developer community. This is also called No Sequence Auto Increment Primary Key.

09. Multiple Indexes on a Single Column:
Prior to 12C, a column cant be in more than one index. In 12C, you can include a column in B-tree index as well as a Bit Map index. But, please note that only one index is usable at a given time.

10. Online Migration of Table Partition or Sub Partition:
You can very easily migrate a partition or sub partition from one tablespace to another. Similar to how the online migration was achieved for a non-partitioned table in prior releases, a table partition or sub partition can be moved to another tablespace online or offline. When an ONLINE clause is specified, all DML operations can be performed without any interruption on the partition|sub-partition which is involved in the procedure. In contrast, no DML operations are allowed if the partition|sub-partition is moved offline.

11. Temporary UNDO:
Prior to 12C, undo records generated by TEMP Tablespace is stored in the undo tablespace. With Temp undo feature in 12C, temp undo records can be stored in temporary table instead of UNDO TS. The benefit is - reduced undo tablespace and reduced redo log space used.

SQL> ALTER SYSTEM SET PGA_AGGREGATE_LIMIT=2G;
SQL> ALTER SYSTEM SET PGA_AGGREGATE_LIMIT=0; --disables the hard limit

12. In Database Archiving:
This feature enables archiving rows within a table by marking them as inactive. These inactive rows are in the database and can be optimized using compression but are not visible to the application. These records are skipped during FTS (Full Table Scan).

Other Features:
Advanced Replication and Streams are Dead. It is being replaced with Oracle Golden Gate.

Invisible Columns. You can now have a invisible column in a table. When a column is defined as invisible, the column won’t appear in generic queries

PGA Aggregate Limit setting:

In 12c, you can set a hard limit on PGA by enabling the automatic PGA management, which requires PGA_AGGREGATE_LIMIT parameter settings. Therefore, you can now set the hard limit on PGA by setting the new parameter to avoid excessive PGA usage.

DDL Logging:

The DDL statements will automatically get recorded in xml/log file if ENABLE_DDL_LOGGING is set to True. ALTER SYSTEM|SESSION SET ENABLE_DDL_LOGGING=TRUE

Source :  www.ondemanddb.com

09 November 2015

Override default workflow template


Create a custom version of the Standard System Mailer Workflow



Open the System: Mailer



Save it as XXSYSML

Open its wft in textpad and search and repace WFMAIL by XXSYSML

Now open this XXSYSML.wft file and change the Name of Workflow from "System: Mailer" to "XX System: Mailer"

Now you can modify the templates within this workflow as desired.





Now, go back to your PO Approval Workflow and attach a new attribute of name for FYI, #WFM_OPEN_MAIL_FYI







Make the value of this attribute point to custom version of "System: Mailer" template

Source Anilpasi

Oracle SQL : Easy way to batch into equal number of datasets for batch processing.

NTILE

Syntax
Description of ntile.gif follows


NTILE is an analytic function. It divides an ordered data set into a number of buckets indicated by expr and assigns the appropriate bucket number to each row. The buckets are numbered 1 through expr. The expr value must resolve to a positive constant for each partition. Oracle Database expects an integer, and if expr is a noninteger constant, then Oracle truncates the value to an integer. The return value is NUMBER.
The number of rows in the buckets can differ by at most 1. The remainder values (the remainder of number of rows divided by buckets) are distributed one for each bucket, starting with bucket 1.
If expr is greater than the number of rows, then a number of buckets equal to the number of rows will be filled, and the remaining buckets will be empty.
You cannot use NTILE or any other analytic function for expr. That is, you cannot nest analytic functions, but you can use other built-in function expressions for expr.
See Also:
Examples
The following example divides into 4 buckets the values in the salary column of the oe.employees table from Department 100. The salary column has 6 values in this department, so the two extra values (the remainder of 6 / 4) are allocated to buckets 1 and 2, which therefore have one more value than buckets 3 or 4.


SELECT last_name, salary, NTILE(4) OVER (ORDER BY salary DESC) 
   AS quartile FROM employees
   WHERE department_id = 100;

LAST_NAME                     SALARY   QUARTILE
------------------------- ---------- ----------
Greenberg                      12000          1
Faviet                          9000          1
Chen                            8200          2
Urman                           7800          2
Sciarra                         7700          3
Popp                            6900          4 
 
 
 
 
Source : http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions101.htm