This blog provides useful information and Tips on Oracle database, Oracle SQL, Oracle PL/SQL, DBMS job scheduler, oracle performance tuning, Oracle SQL Query Optimization, Oracle Interview Questions, Various Oracle Error Codes, Oracle Regular Expressions and String Aggregation for Oracle DBA and Database Developers.
http://nimishgarg.blogspot.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Tuesday
LOAD TIME
0.6 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
19
SSL
EXTERNAL LINKS
4
SITE IP
172.217.5.97
LOAD TIME
0.563 sec
SCORE
6.2
Let's Develop in Oracle | nimishgarg.blogspot.com Reviews
https://nimishgarg.blogspot.com
This blog provides useful information and Tips on Oracle database, Oracle SQL, Oracle PL/SQL, DBMS job scheduler, oracle performance tuning, Oracle SQL Query Optimization, Oracle Interview Questions, Various Oracle Error Codes, Oracle Regular Expressions and String Aggregation for Oracle DBA and Database Developers.
nimishgarg.blogspot.com
Create CSV file using PL/SQL - Oracle Database
http://nimishgarg.blogspot.com/2011/09/create-csv-file-using-plsql.html
Let's Develop in Oracle. Create CSV file using PL/SQL. To create a file, we need to create a directory and have the read write permission as. Create or replace directory MYCSV as '/home/oracle/mycsv';. Home/oracle/mycsv has to be physical location on disk. Grant read, write on directory MYCSV to scott;. Following is the pl/sql sample code to create CSV file. F UTL FILE.FILE TYPE;. C1 R C1%ROWTYPE;. F := UTL FILE.FOPEN('MYCSV','EMP DEPT.CSV','w',32767);. FOR C1 R IN C1. UTL FILE.PUT(F,C1 R.EMPNO);. Genera...
May 2015 - Oracle Database
http://nimishgarg.blogspot.com/2015_05_01_archive.html
Let's Develop in Oracle. ORA-04031: unable to allocate n bytes of shared memory. Subscribe to: Posts (Atom). Buy Me A Coffee. Optimizing SQL with MIN and MAX - Real Life Approach. ORA-06530: Reference to uninitialized composite. VIEW PUSHED PREDICATE - A Powerful Optimizer Transformation feature. Why my distinct query is not using index? Parameterized View - Passing Parameters in Views. Reducing database calls by posting Multiple Records from Application to Database. Oracle: Total Size of The Database.
ORA-00911: invalid character - Oracle Database
http://nimishgarg.blogspot.com/2013/03/ora-00911-invalid-character.html
Let's Develop in Oracle. Identifiers may not start with any ASCII character other than letters and numbers. $# are also allowed after the first character. Identifiers enclosed by doublequotes may contain any character other than a doublequote. Alternative quotes (q'#.#') cannot use spaces, tabs, or carriage returns as delimiters. For all other contexts, consult the SQL Language Reference Manual. Http:/ docs.oracle.com/cd/B28359 01/server.111/b28278/e900.htm#ORA-00910. When semicolon (;) is added to end t...
April 2015 - Oracle Database
http://nimishgarg.blogspot.com/2015_04_01_archive.html
Let's Develop in Oracle. OEM: The database is down. Please specify the host credentials to access database restart and diagnostics tools. ORA-03135: connection lost contact. Subscribe to: Posts (Atom). Buy Me A Coffee. Optimizing SQL with MIN and MAX - Real Life Approach. ORA-06530: Reference to uninitialized composite. VIEW PUSHED PREDICATE - A Powerful Optimizer Transformation feature. Why my distinct query is not using index? Parameterized View - Passing Parameters in Views.
Oracle: Total Size of The Database - Oracle Database
http://nimishgarg.blogspot.com/2010/05/oracle-total-size-of-database.html
Let's Develop in Oracle. Oracle: Total Size of The Database. An oracle database consists of data files, redo log files, control files, temporary files. The size of the database actually means the total size of all these files. Select sum(bytes)/1024/1024/1024 data size from dba data files ). Select nvl(sum(bytes),0)/1024/1024/1024 temp size from dba temp files ). Select sum(bytes)/1024/1024/1024 redo size from sys.v $log ). Oracle DBA Daily Checklist. Database Routine Checklist Queries. Select name, bytes.
TOTAL PAGES IN THIS WEBSITE
19
Nimish Dalal Photography
Nimish Dalal Photography 2012 2018. An emerging fine art, landscape photographer from India.
Nimish Dave
Thoughts of the day. Placement – III Cell. British Counsil – Orientation. June 16, 2012. The British Council has organized a Pre-Departure Orientation for all students, in Ahmedabad and around, who have received an offer of admission from an institution in the UK or are in the process of applying to the UK. Filed under Placement - III Cell. MAHINDRA and MAHINDRA – EVENT. April 17, 2012. Mahindra and Mahindra is going to organize an event on 19.04.2012 @ L D Engineering College. 9:30 AM – 10:30 AM. Step 3...
Nimish Dubey's Blog
Nimish Engineering
ISO 9001:2008 Certified Co. Manufacturer of : comprehensive range of control valves and. Industrail Valves for all process, power generation and associate industries. 2 Way Globe Control Valve. 3 Way Globe Control Valve. Nimish engg. was promoted by technocrats having sound experience of over 15 years in control valve technology. The company is engaged in design, development and manufacturing of a comprehensive range of control valves for all process, power generation and associate industries.
Let's Develop in Oracle
Let's Develop in Oracle. Top 18 features of Oracle 18c. Is the next iteration of Oracle Database 12c Release 2 (12.2.0.2). Oracle has simply changed the product names to follow a yearly release pattern. 1 For Exadata and Real Application Clusters (RAC), Oracle Database 18c uses RDMA over the Infiniband. Connection to access the undo blocks in the remote instance to reduce significant amount of undo that needs to be transferred across the interconnect. While the databases on that node remains available.
Nimish Goel Blog
Nimish Goel Blog Online Career Guidance and Mentoring. Online Career Guidance and Mentoring. For chartered accountancy students and qualified chartered accountants. What To Ask Interviewer When All Questions Have Been Answered. August 12, 2015. Bull; 0 Comments. What would you do if you had prepared a few questions before the interview and then throughout the interview the interviewer answered all of your questions through general conversation? Read more →. August 4, 2015. Bull; 0 Comments. August 4, 2015.
Index of /
SOCIAL ENGAGEMENT