www.ToadWorld.com – In this episode of the Quest on the Board whiteboard series, Quest Manager of Systems Consulting Amit Parikh describes how development teams can meet the objectives of productivity and collaboration through a best practices workflow that builds quality, performance and maintainbility into their code.
Tag: Database
Starting Oracle ASM Instance & Database
This is basic step on how to start Oracle 11g ASM instance and then starting the Oracle 11g Database. You can see there was some errors so I updated the init file and fixed it because I had copied the init file from another box. Hope this helps. I will soon be uploading instructions step… Continue reading Starting Oracle ASM Instance & Database
Advanced Oracle PL/Sql: Programming With Packages
Product DescriptionSteven Feuerstein’s first book, Oracle PL/SQL Programming, has become the classic reference to PL/SQL, Oracle’s procedural extension to its SQL language. His new book looks thoroughly at one especially advanced and powerful part of the PL/SQL language — the package. The use of packages can dramatically improve your programming productivity and code quality, while… Continue reading Advanced Oracle PL/Sql: Programming With Packages
Oracle 10g Database Administrator II: Backup/Recovery and Network Administration
Product Description Oracle 10g Database Administrator II: Backup/Recovery uses the most current database release from Oracle to provide thorough coverage of an Oracle database through the day-to-day duties of a database administrator. This text drills down key tools and techniques for Oracle database backup, recovery and network administration and provides good preparation for the update… Continue reading Oracle 10g Database Administrator II: Backup/Recovery and Network Administration
Mastering Oracle PL/SQL: Practical Solutions
ISBN13: 9781590592175 Condition: USED – VERY GOOD Notes: Product Description This isn’t a tutorial on how to code PL/SQL. It’s designed to show you how to code PL/SQL well. It shows you how to write code that will run quickly and won’t break in high-load, multiuser environments. It covers the vast array of the functionality… Continue reading Mastering Oracle PL/SQL: Practical Solutions
The Information Given By Oracle Database 10G From Exam bible
In order to maintain the product quality of 1z0-042,all of our materials are the latest certification information by keeping pace with the Oracle Official Website. Our company has won the customers’ confidence by guaranteeing the quality of our products. IT professionals into the Oracle industry, Oracle certification is a “stepping-stone”. By the internationally renowned IT… Continue reading The Information Given By Oracle Database 10G From Exam bible
SQL SERVER Tutorial – T-SQL: ORDER BY – COUNTING – GROUP BY – HAVING
T-SQL Tutorial
SQL SERVER / T-SQL Tutorial: Left Outer Join – Right Outer Join – Full Join – Combining Join
T-SQL Tutorial
Table Corruption in MySQL Database
A Request Tracker (RT) enables you to keep a record of all the operations performed in MySQL database. RT creates a session by using a MySQL database, a PERL (Practical Extraction and Report Language) based main engine and front-end web and mail interfaces. However, if RT is unable to store your transactions made into the… Continue reading Table Corruption in MySQL Database
Managing Change with Oracle Database 11g
Oracle Real Application Testing
How To Kill Session In Oracle 11g Database With New Feature?
In various critical situations Oracle DBA has to decide to kill existing session or kill the background process of Oracle 11g database. At this moment remote Oracle DBA should need to terminate session/process called as murder of session of any instance. Â From Oracle 11g database there is new feature introduced to kill session from… Continue reading How To Kill Session In Oracle 11g Database With New Feature?
What’s the difference between and Join and a Subquery (T-SQL)?
How do I get started in writing/programming in T-SQL?
I am completely confused on what T-SQL really is and how it is different from SQL and its variants. How do you guys program something using T-SQL language? I mean where do you actually ‘encode’ those T-SQL codes? In cobol I use notepad as the programming environment. Do I need to download something like that… Continue reading How do I get started in writing/programming in T-SQL?
How do I set up a job on SQL 2000 to back up a database on other computers in my domain to my computer?
IÂ am trying to create a job on SQL 2000 that will allow me to backup databases from 3 other computers in my domain. all running SQL 2000. i need help writing the T-SQL Statement to insert in the job step. Powered by Y! Answers
Oracle PL/SQL Best Practices
ISBN13: 9780596514105 Condition: NEW Notes: Brand New from Publisher. No Remainder Mark. Product Description In this compact book, Steven Feuerstein, widely recognized as one of the world’s leading experts on the Oracle PL/SQL language, distills his many years of programming, teaching, and writing about PL/SQL into a set of best practices-recommendations for developing successful applications.… Continue reading Oracle PL/SQL Best Practices
T-SQL: How do I find the greatest values in a column?
How can write a SELECT statement that finds the n greatest values in a column? From what i’ve read, the TOP statement only returns the first n rows, it doesn’t take any regard to the values. For example, if a have a column with ages, i want to be able to find the 5 oldest… Continue reading T-SQL: How do I find the greatest values in a column?
Oracle Database 11g PL/SQL Programming
Product Description Design Feature-Rich PL/SQL ApplicationsDeliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements,… Continue reading Oracle Database 11g PL/SQL Programming
Oracle Database 11gR2: Building an ASM Clustered File System (ACFS)
Oracle Database 11gR2: Building an ASM Clustered File System (ACFS) Synopsis. Read more on Database Journal
Oracle Database 11g Release 2
Oracle Senior VP, Andy Mendelsohn introduces Oracle Database 11g Release 2.
Oracle 11g database creation
How to create an Oracle 11g database using the database configuration assistant