Meta tags:

Headings (most frequently used words):

oracle, 11g, reference, sharepoint, monday, 2010, workflow, dba, creating, for, view, life, without, line, of, syntax, september, 26, 2011, august, 16, state, machine, hello, world, sql, fundamentals, pepstroops, library, designer, recent, comments, development, production, masters, my, other, blogs, labels, blog, archive, currency, converter, bc, video, references, insert, statement, table, by, using, subquery, constraints, create, tables, synonyms, indexes, sequences, clauses, rules, performing, dml, operations, on,

Text of the page (most frequently used words):
oracle (48), sql (27), #create (27), 11g (20), 10g (20), table (17), peah (15), the (15), queries (15), and (14), sequence (14), view (13), mar (12), #comments (11), succeeded (11), results (11), posted (10), peps (10), from (10), fundamentals (9), creating (9), labels (9), with (9), select (9), using (8), employee_id (8), 2010 (7), sharepoint (7), reference (7), other (7), moss (7), department_id (7), dept_deptid_seq (7), drop (7), index (7), synonym (7), jan (7), data (6), tables (6), schemas (6), 2007 (6), group (6), employees (6), last_name (6), varchar2 (6), managing (5), objects (5), alter (5), for (5), have (5), has (5), can (5), cannot (5), must (5), number (5), key (5), blog (4), september (4), ddl (4), statements (4), all (4), database (4), when (4), project (4), life (4), http (4), dba (4), job (4), involved (4), that (4), you (4), name (4), check (4), contains (4), null (4), dml (4), replace (4), where (4), salary (4), only (4), insert (4), values (4), primary (4), use (4), august (3), manipulating (3), new (3), com (3), more (3), development (3), team (3), are (3), workflow (3), world (3), rownum (3), distinct (3), function (3), not (3), operations (3), rules (3), constraint (3), first_name (3), hire_date (3), job_id (3), commission_pct (3), feb (3), aug (3), rows (3), into (3), department_name (3), nextval (3), currval (3), emp_last_name_idx (3), column (3), d_sum (3), dept (3), 120000 (3), 114000 (3), nov (3), apr (3), interview (3), questions (3), free (2), currency (2), converter (2), january (2), april (2), may (2), june (2), july (2), video (2), references (2), 2011 (2), web (2), 22g (2), row (2), functions (2), stored (2), case (2), statement (2), today (2), learn (2), how (2), your (2), advance (2), databases (2), gets (2), design (2), decisions (2), keep (2), also (2), satisfaction (2), being (2), level (2), codeplex (2), posts (2), columns (2), empvu20 (2), option (2), 201 (2), empvu10 (2), employee_number (2), employee_name (2), job_title (2), read (2), selected (2), increment (2), maxvalue (2), nocache (2), nocycle (2), departments (2), location_id (2), removing (2), privilege (2), before (2), value (2), indexes (2), created (2), large (2), default (2), deptno (2), dname (2), loc (2), create_date (2), date (2), describe (2), constraints (2), dept80 (2), annsal (2), oct (2), cambrault (2), 132000 (2), 126000 (2), 108000 (2), 96000 (2), 90000 (2), dec (2), 84000 (2), smith (2), 74400 (2), monday (2), day (2), without (2), line (2), syntax (2), skip (2), pioneer, counter, yahoo, february, march, october, december, 2008, november, 2009, archive, ramble, loader, single, customize, output, installing, sample, temporary, uppercase, lowercase, trigger, string, aggregation, procedure, plus, show, command, installation, operator, dblink, dates, scheduler, source, migration, connected, sessions, concate, strings, backup, restore, templates, enterprise, content, paste, code, snippet, blogspot, financial, tips, external, service, thinking, cap, old, crib, kitchen, blogs, base, after, coffe, jeffrey, hunter, www, ora, error, otn, grant, privileges, fin, sig, career, aspirants, answers, commands, andre, broers, danusha, sri, lanka, masters, responsible, maintaining, within, organisation, very, difficult, demanding, she, often, been, made, simply, things, running, therefore, course, rewarding, both, financially, terms, but, lonely, than, production, usually, works, closely, developers, giving, advice, performance, writing, good, satisfying, human, because, part, share, accomplishments, recent, spdactivities, designer, gac, windows, assembly, _vti_bin, lists, asmx, subsite, sp_portal, pepstroops, library, lesson, hope, find, this, helpful, ciow, fiza, software, almost, years, now, freelance, once, while, technology, labeled, thinker, did, vb6, asp, php, several, mysql, postgresql, server, currently, kinda, tact, above, deep, interest, triggers, packages, procedures, any, required, dbms, found, fun, discovered, hello, surf, keyword, foundation, dinnernow, state, machine, subscribe, atom, home, older, expressions, decode, modify, parent, thru, add, remove, always, perfrorm, simple, views, performing, make, sure, performed, stay, domain, empvu20_ck, email, phone_number, manager_id, michael, hartstein, mhartste, 888, 122, mk_man, 3000, 100, 202, pat, fay, pfay, 603, 123, mk_rep, 6000, operation, done, through, 200, whalen, ad_asst, clauses, start, 120, 9999, support, 2500, dual, 999999, modifying, restart, dropped, recreated, future, nos, affected, issued, first, currentvalue, nextvalue, sequences, one, frequently, used, together, clause, join, condition, wide, range, guidelines, manually, automatically, why, dept_sum_vu, shorten, lengthy, object, easy, synonyms, naming, referring, user, please, users, prefix, sysdate, type, usera, storage, area, reserved, words, duplicate, length, characters, long, begin, character, types, employee_column_level, emp_emp_level_id_pk, employee_table_level, emp_emp_table_id_pk, unique, foreign, 145, russell, 168000, 146, partners, 162000, 147, errazuriz, 144000, 148, 149, zlotkey, 150, tucker, 151, bernstein, 152, hall, 153, olsen, 154, 155, tuvault, 156, king, 157, sully, 158, mcewen, 159, 160, doran, 161, sewall, 162, vishney, 163, greene, 164, marvins, 86400, 165, lee, 81600, 166, ande, 76800, 167, banda, 168, ozer, 138000, 169, bloom, 170, fox, 115200, 171, 88800, 172, bates, 87600, 173, kumar, 73200, 174, abel, 175, hutton, 105600, 176, taylor, 103200, 177, livingston, 100800, 179, johnson, subquery, prompt, locationid, copying, another, sales_reps, id_name, like, rep, videos, execute, might, know, what, dropping, cik, sidebar, main,

Text of the page (random words):
life without a line of syntax skip to main skip to sidebar life without a line of syntax execute your life day to day you might not know what u re dropping cik peah monday september 26 2011 sharepoint 2010 video references videos sharepoint 2010 interview questions sharepoint 2010 interview questions 2 interview questions all posted by peah peps at 4 25 pm no comments monday august 16 2010 oracle 11g insert statement sql queries use to prompt value insert into departments department_id department_name location_id values department_id department_name locationid sql queries copying rows from another table insert into sales_reps id_name salary commission_pct select employee_id last_name salary commission_pct from employees where job_id like rep posted by peah peps at 6 08 pm no comments labels oracle 22g manipulating data sql fundamentals oracle 11g creating a table by using subquery sql queries create table dept80 as select employee_id last_name salary 12 annsal hire_date from employees where department_id 80 select from dept80 results create table succeeded employee_id last_name annsal hire_date 145 russell 168000 01 oct 96 146 partners 162000 05 jan 97 147 errazuriz 144000 10 mar 97 148 cambrault 132000 15 oct 99 149 zlotkey 126000 29 jan 00 150 tucker 120000 30 jan 97 151 bernstein 114000 24 mar 97 152 hall 108000 20 aug 97 153 olsen 96000 30 mar 98 154 cambrault 90000 09 dec 98 155 tuvault 84000 23 nov 99 156 king 120000 30 jan 96 157 sully 114000 04 mar 96 158 mcewen 108000 01 aug 96 159 smith 96000 10 mar 97 160 doran 90000 15 dec 97 161 sewall 84000 03 nov 98 162 vishney 126000 11 nov 97 163 greene 114000 19 mar 99 164 marvins 86400 24 jan 00 165 lee 81600 23 feb 00 166 ande 76800 24 mar 00 167 banda 74400 21 apr 00 168 ozer 138000 11 mar 97 169 bloom 120000 23 mar 98 170 fox 115200 24 jan 98 171 smith 88800 23 feb 99 172 bates 87600 24 mar 99 173 kumar 73200 21 apr 00 174 abel 132000 11 may 96 175 hutton 105600 19 mar 97 176 taylor 103200 24 mar 98 177 livingston 100800 23 apr 98 179 johnson 74400 04 jan 00 34 rows selected posted by peah peps at 5 55 pm no comments labels oracle 11g using ddl statements to create and managing tables oracle 11g creating constraints types of constraints not null primary key foreign key check unique sql queries column level create table employee_column_level employee_id number 6 constraint emp_emp_level_id_pk primary key first_name varchar2 20 create table employee_table_level employee_id number 6 first_name varchar2 20 constraint emp_emp_table_id_pk primary key employee_id posted by peah peps at 5 45 pm no comments labels oracle 11g using ddl statements to create and managing tables sql fundamentals oracle 11g create tables naming rules must begin with a character length 1 30 characters long can only contains a z a z _ 0 9 cannot be duplicate cannot be oracle reserved words must have create table privilege a storage area if referring to other user s table please use users as prefix before table name select from usera employees sql queries creating new table use default create table dept deptno number 2 dname varchar2 14 loc varchar2 13 create_date date default sysdate describe dept results create table succeeded describe dept name null type deptno number 2 dname varchar2 14 loc varchar2 13 create_date date posted by peah peps at 5 29 pm no comments labels oracle 11g using ddl statements to create and managing tables sql fundamentals oracle 11g synonyms why use synonym create easy reference shorten lengthy object name sql queries create a synonym create synonym d_sum for dept_sum_vu results create synonym succeeded sql queries drop a synonym drop synonym d_sum results drop synonym d_sum succeeded posted by peah peps at 5 00 pm no comments oracle 11g indexes how indexes being created automatically when we created primary key manually guidelines to create index a column has wide range values a column has large number of null values one or more columns are frequently used together clause join condition large table sql queries create new index create index emp_last_name_idx on employees last_name results create index succeeded sql queries removing an index drop index emp_last_name_idx results drop index emp_last_name_idx succeeded posted by peah peps at 4 56 pm no comments labels oracle 11g creating other schemas objects sql fundamentals oracle 11g sequences sql queries creating a sequence create sequence dept_deptid_seq increment by 10 start with 120 maxvalue 9999 nocache nocycle results create sequence succeeded sql queries using a sequence nextval nextvalue currval currentvalue nextval must be issued first before currval has value insert into departments department_id department_name location_id values dept_deptid_seq nextval support 2500 select dept_deptid_seq currval from dual sql queries alter a sequence alter sequence dept_deptid_seq increment by 20 maxvalue 999999 nocache nocycle rules on modifying the sequence must have the privilege to alter only future sequence nos are affected to restart the sequence no the sequence must be dropped and recreated results alter sequence dept_deptid_seq succeeded sql queries removing a sequence drop sequence dept_deptid_seq results drop sequence dept_deptid_seq succeeded posted by peah peps at 3 57 pm no comments labels oracle 11g creating other schemas objects sql fundamentals oracle 11g clauses for view sql queries with check option make sure that the dml operations performed stay in the domain of the view create or replace view empvu20 as select from employees where department_id 20 with check option constraint empvu20_ck select from empvu20 results create or replace view succeeded employee_id first_name last_name email phone_number hire_date job_id salary commission_pct manager_id department_id 201 michael hartstein mhartste 888 122 17 feb 96 mk_man 3000 100 20 202 pat fay pfay 603 123 17 aug 97 mk_rep 6000 201 20 sql queries with read only no dml operation can be done through the view create or replace view empvu10 employee_number employee_name job_title as select employee_id last_name job_id from employees where department_id 10 with read only select from empvu10 results create or replace view succeeded employee_number employee_name job_title 200 whalen ad_asst 1 rows selected posted by peah peps at 3 37 pm no comments labels oracle 11g creating other schemas objects sql fundamentals oracle 11g rules for performing dml operations on a view can always perfrorm dml operations om simple views cannot remove a row if view contains group function group by distinct rownum cannot add data thru view if view contains group function group by distinct rownum parent table that has columns not null cannot modify data in view if view contains group function group by distinct rownum expressions case when decode posted by peah peps at 3 28 pm no comments labels oracle 11g creating other schemas objects sql fundamentals older posts home subscribe to posts atom state machine workflow 1 surf using keyword workflow foundation in codeplex 2 check dinnernow hello world hi my name if fiza a k a peah i have involved in the software development world for almost 10 years now i do freelance once in a while to keep up with the technology and i can be labeled as a free thinker in the it world i did vb6 asp php involved in several databases mysql postgresql sql server currently i am kinda in tact with oracle of all the above i have deep interest in manipulating triggers packages functions stored procedures in any required dbms and i also found that moss is fun to be discovered hope you ll find this blog helpful ciow sql fundamentals reference lesson 3 pepstroops library gac c windows assembly http sp_portal subsite _vti_bin lists asmx sharepoint designer workflow reference http spdactivities codeplex com recent comments a development dba usually works closely with a team of developers and gets more involved in design decisions giving advice on performance and writing good sql that can be satisfying at a human level because you are part of a team and you share the satisfaction of the team s accomplishments a production dba is responsible for maintaining databases within an organisation so it is a very difficult and demanding job he or she often gets involved when all the design decisions have been made and has simply to keep things up and running therefore of course it is also a rewarding job both financially and in terms of job satisfaction but it s a more lonely job than being a development dba sharepoint masters mr danusha sri lanka oracle reference andre broers commands database answers dba career aspirants fin sig blog grant privileges http otn oracle com http www ora error com jeffrey m hunter life after coffe oracle base my other blogs peah s kitchen peah s old crib peah s thinking cap labels advance moss 2007 reference advance moss 2007 web service external table financial tips how to paste your code snippet in blogspot managing enterprise content moss 2007 reference moss 2007 today i learn moss moss templates ms project 2007 new project ms project 2007 today i learn ms project oracle 10g alter table oracle 10g backup restore oracle 10g case when statement oracle 10g concate strings oracle 10g connected sessions oracle 10g create database oracle 10g data migration oracle 10g database data source oracle 10g database scheduler oracle 10g dates oracle 10g dblink oracle 10g in operator oracle 10g installation oracle 10g show all tables command oracle 10g sql plus oracle 10g stored procedure oracle 10g string aggregation oracle 10g trigger oracle 10g uppercase lowercase oracle 10g temporary table oracle 11g creating other schemas objects oracle 11g installing sample schemas oracle 11g using ddl statements to create and managing tables oracle 11g using single row functions to customize output oracle 22g manipulating data oracle loader ramble sharepoint 2010 sql fundamentals web reference blog archive 2011 1 september 1 sharepoint 2010 video references 2010 29 august 21 july 4 june 3 january 1 2009 15 november 1 september 2 august 6 july 3 june 2 april 1 2008 32 december 1 october 2 september 5 may 2 april 2 march 1 february 3 january 16 currency converter yahoo currency converter bc free blog counter pioneer