recentpopularlog in

neerajsinghvns : sql   28

ORACLE-BASE - Oracle Linux 6 Installation
Oracle 8i, 9i, 10g, 11g, 12c, PL/SQL, SQL, Oracle RAC, Oracle Apps, Linux
OS  Linux  Apps  RAC  SQL  PL/SQL  PL/S  12c  11g  10g  9i  8i  steps  stepbystep  howto  6  oracle  install  installation 
january 2012 by neerajsinghvns
@About | MacLochlainns Weblog
Joe,

I didn’t actually write the book to target that exam but it covers the material that’ll be on the exam.
More or less, that exam mirrors the course material presented by Oracle in their courses. For example, the certification exam should cover more or less this:

- Conditionally control code flow (loops, control structures).
- Design and use PL/SQL packages to group and contain related
constructs.
- Create triggers to solve business challenges.
- Use some of the Oracle supplied PL/SQL packages to generate
screen output and file output.
- Create anonymous PL/SQL blocks of code.
- Declare PL/SQL variables.

Hope this helps,
Michael
son  and  father  blog  SQL  PL/SQL  exams  exam  certification  database  oracle 
january 2012 by neerajsinghvns
SQL*Plus FAQ - Oracle FAQ
http://www.orafaq.com/wiki/SQL*Plus_FAQ
---
What is AFIEDT.BUF?

AFIEDT.BUF is the SQL*Plus default edit save file. When you issue the command "ed" or "edit" without arguments, the last SQL or PL/SQL command will be saved to a file called AFIEDT.BUF and opened in the default editor.

In the prehistoric days when SQL*Plus was called UFI (User Friendly Interface) this file was named "ufiedt.buf", short for UFI editing buffer. When new features were added to UFI, it was initially named Advanced UFI and the filename was changed to "aufiedt.buf" and then to "afiedt.buf". They presumably needed to keep the name short for compatibility with some of the odd operating systems that Oracle supported in those days. The name "Advanced UFI" was never used officially, as the name was changed to SQL*Plus before this version was released.

You can overwrite the default edit save file's name like this:

SET EDITFILE "afiedt.buf"
oracle  sql  PLUS  sqlplus  faq  database  sql*plus  tips  howto  programming 
october 2011 by neerajsinghvns
Simply SQL, by SitePoint
Simply SQL, by SitePoint"Teach Yourself SQL - The Easy Way!"
sql  tutorial  book 
may 2009 by neerajsinghvns
Moving Data from SQL Server 2000 to SQL Server 2005
Moving Data from SQL Server 2000 to SQL Server 2005
Moving  Data  MSSQL  SQL  Server  2000  to  2005 
august 2008 by neerajsinghvns
How to transfer logins and passwords between instances of SQL Server
"You transfer logins and passwords from SQL Server 2000 to SQL Server 2005"
microsoft  sql  server  2000  2005 
august 2008 by neerajsinghvns
Tech on the Net
Microsoft Access, Microsoft Excel, Microsoft Word, SQL, Oracle/PLSQL, UNIX, and Linux.
examples  howto  Microsoft  Access  Excel  Word  SQL  Oracle  PLSQL  UNIX  Linux  triggers  trigger  exception 
august 2008 by neerajsinghvns
.:: NOTEPAD++ ::.
http://notepad-plus.sourceforge.net/uk/site.htm
-
https://www.google.com/search?q=notepad%2B%2B+font+size&oq=notepad%2B%2B+font+si&aqs=chrome.0.0j69i57j0l4.6631j0j1&sourceid=chrome&ie=UTF-8
---
Open menu Settings/Style Configurator. Then with the default theme "Default (stylers.xml)" and default language "Global Styles", change the font name and font size for style "Default Style" (the default, style "Global override" will not cut it).Aug 1, 2009
-
put check mark in "Enable global font"
put check mark in "Enable global font size"
---
notepad++  notepadPlusPlus  tool  notepad  code  programming  tools  freeware  software  editor  windows  opensource  PHP  SQL  webdesign  utilities  utility  language  internet  HTML  free  documentation  script  scripting 
may 2007 by neerajsinghvns

Copy this bookmark:





to read