killamsetty.blogspot.com
My Findings ...: August 2016
http://killamsetty.blogspot.com/2016_08_01_archive.html
Kiran Kumar Gupta Killamsetty (Linkedin Profile). H4 EAD - Filling Guide. Please refer USCIS Website for complete information. Https:/ www.uscis.gov/working-united-states/temporary-workers/employment-authorization-certain-h-4-dependent-spouses. Who are eligible for H4 EAD? Certain H-4 dependent spouses of H-1B nonimmigrants can file. Form I-765, Application for Employment Authorization. If the H-1B nonimmigrant:. Is the principal beneficiary of an approved. Form I-140, Immigrant Petition for Alien Worker.
killamsetty.blogspot.com
My Findings ...: NOSQL : CQLSH Commands
http://killamsetty.blogspot.com/2016/03/nos-cqlsh-commands.html
Kiran Kumar Gupta Killamsetty (Linkedin Profile). NOSQL : CQLSH Commands. Cqlsh - Start the CQL interactive terminal. Syntax : cqlsh [options] [host [port]. Opt/cassandra/dse-4.8.2/bin/cqlsh optrhdbcasra01adev -u cswgadmin -p admin123. CAPTURE - Captures command output and appends it to a file. Example : CAPTURE ' /mydir/myfile.txt'. Imports and exports CSV (comma-separated values) data to and from Cassandra. COPY table name ( column, .) FROM ( 'file name' STDIN ) WITH option = 'value' AND . At the [copy...
killamsetty.blogspot.com
My Findings ...: January 2015
http://killamsetty.blogspot.com/2015_01_01_archive.html
Kiran Kumar Gupta Killamsetty (Linkedin Profile). GOVERNMENT INTRODUCED ONLINE SERVICES 🔘. Obtain: 1. Birth Certificate. Http:/ www.india.gov.in/howdo/howdoi.php? Http:/ www.india.gov.in/howdo/howdoi.php? Http:/ www.india.gov.in/howdo/otherservice details.php? Http:/ www.india.gov.in/howdo/howdoi.php? Http:/ www.india.gov.in/howdo/howdoi.php? Http:/ www.india.gov.in/howdo/howdoi.php? Http:/ www.india.gov.in/howdo/howdoi.php? Apply for: 1. PAN Card. 5 Inclusion of name in the Electoral Rolls. Http:/ www&...
killamsetty.blogspot.com
My Findings ...: November 2015
http://killamsetty.blogspot.com/2015_11_01_archive.html
Kiran Kumar Gupta Killamsetty (Linkedin Profile). 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. WHERE ROWID NOT IN ( SELECT MIN (ROWID). GROUP BY rc no);. Option 2. Using row number() option. WHERE ROWID IN (SELECT row id. FROM (SELECT ROWID row id,. OVER (PARTITION BY x, y, z ORDER BY x). Kiran Kumar Gupta Killamsetty. Links to this post. 8226;Backed up and. The new data masking...
killamsetty.blogspot.com
My Findings ...: July 2016
http://killamsetty.blogspot.com/2016_07_01_archive.html
Kiran Kumar Gupta Killamsetty (Linkedin Profile). How to Change/View Applet Windows Title in Oracle EBS. System Administrator responsibility and navigate to Profile System, search for the profile name ". To see the value what was set,. SELECT v.profile option value FROM apps.fnd profile option values v, apps.fnd profile options n WHERE v.profile option id = n.profile option id AND n.profile option name LIKE 'SITENAME%'. To see database creation date,. Kiran Kumar Gupta Killamsetty. Links to this post.
killamsetty.blogspot.com
My Findings ...: October 2015
http://killamsetty.blogspot.com/2015_10_01_archive.html
Kiran Kumar Gupta Killamsetty (Linkedin Profile). How to set Workflow Mailer Override Address. How to set Workflow Mailer Override Address from Backend? Doc ID 1533596.1). Please use the following script $FND TOP/sql/afsvcpup.sql. This will enable to change any and all or your Mailer components. A Run the script. B It will show you the components - pick the comp id for the Workflow Mailer - default is 10006. C then it will show you the parameters and their values for the mailer. It will show you. The ema...
killamsetty.blogspot.com
My Findings ...: How to Change/View Applet Windows Title in Oracle EBS
http://killamsetty.blogspot.com/2016/07/how-to-changeview-applet-windows-title.html
Kiran Kumar Gupta Killamsetty (Linkedin Profile). How to Change/View Applet Windows Title in Oracle EBS. System Administrator responsibility and navigate to Profile System, search for the profile name ". To see the value what was set,. SELECT v.profile option value FROM apps.fnd profile option values v, apps.fnd profile options n WHERE v.profile option id = n.profile option id AND n.profile option name LIKE 'SITENAME%'. To see database creation date,. Kiran Kumar Gupta Killamsetty. Select Your Time Zone.
killamsetty.blogspot.com
My Findings ...: Oracle SQL Developer ShortCuts
http://killamsetty.blogspot.com/2016/07/oracle-sql-developer-shortcuts.html
Kiran Kumar Gupta Killamsetty (Linkedin Profile). Oracle SQL Developer ShortCuts. Kiran Kumar Gupta Killamsetty. Subscribe to: Post Comments (Atom). Kiran Kumar Gupta Killamsetty. View my complete profile. There was an error in this gadget. Select Your Time Zone. Simple theme. Powered by Blogger.
killamsetty.blogspot.com
My Findings ...: Oracle SQL Developer : Formatting Query Results to CSV/xml/html/json
http://killamsetty.blogspot.com/2016/07/oracle-sql-developer-formatting-query.html
Kiran Kumar Gupta Killamsetty (Linkedin Profile). Oracle SQL Developer : Formatting Query Results to CSV/xml/html/json. Add hint to sql in the below format to get custom and run in execute mode (F5). SELECT /*csv*/ * FROM scott.emp;. SELECT /*xml*/ * FROM scott.emp;. SELECT /*html*/ * FROM scott.emp;. SELECT /*delimited*/ * FROM scott.emp;. SELECT /*insert*/ * FROM scott.emp;. SELECT /*loader*/ * FROM scott.emp;. SELECT /*fixed*/ * FROM scott.emp;. SELECT /*text*/ * FROM scott.emp;. Select Your Time Zone.