CheGuevara Posted April 18, 2013 Report Posted April 18, 2013 [quote name='Kaarthikeya' timestamp='1366293760' post='1303625546'] how to parse a query before execution? I mean shortcut key endi aa renditki? [/quote] parsing anedi oracle chestadi anukunta....i am not aware of anything from our side that we can do explicit parsing....
CheGuevara Posted April 18, 2013 Report Posted April 18, 2013 [quote name='Kaarthikeya' timestamp='1366294369' post='1303625580'] ee statement ichinappudu prati sari values enter chesaaka malli statement execute cheyyakunda values enter cheyyadam ela toad lo? [CODE] insert into DEPT values(&no, &name, &loc) [/CODE] [/quote] no idea...TOAD long back use chesa...
deals2buy Posted April 18, 2013 Report Posted April 18, 2013 [quote name='CheGuevara' timestamp='1366295105' post='1303625633'] parsing anedi oracle chestadi anukunta....i am not aware of anything from our side that we can do explicit parsing.... [/quote]avuna? manam ichina statements lo syntax errors unnaylo ledo ela check cheyyali mari before execution? [quote name='CheGuevara' timestamp='1366295153' post='1303625636'] no idea...TOAD long back use chesa... [/quote]mari ippudu em use chestunnav? SQL Plus lo ela chestaru poni?
CheGuevara Posted April 18, 2013 Report Posted April 18, 2013 [quote name='Kaarthikeya' timestamp='1366295358' post='1303625651'] avuna? manam ichina statements lo syntax errors unnaylo ledo ela check cheyyali mari before execution? mari ippudu em use chestunnav? SQL Plus lo ela chestaru poni? [/quote] query rayi...execute chey....ede naaku telisindi...may be there might be some other way...lets see inka evarina cheptaro... nenu ippudu sql devloper use chestunna
deals2buy Posted April 18, 2013 Report Posted April 18, 2013 [quote name='CheGuevara' timestamp='1366297205' post='1303625807'] [color=#ff0000]query rayi...execute chey....ede naaku telisindi..[/color].may be there might be some other way...lets see inka evarina cheptaro... nenu ippudu sql devloper use chestunna [/quote]ade chestunna ippudu also, multi insert lo compulsory ga select statement vaadaaala? also what does dual in Oracle means?
CheGuevara Posted April 18, 2013 Report Posted April 18, 2013 [quote name='Kaarthikeya' timestamp='1366300382' post='1303626290'] ade chestunna ippudu also, multi insert lo compulsory ga select statement vaadaaala? also what does dual in Oracle means? [/quote] multi insert ki example evvu... dual anedi oka dummy table in oracle ...adi some system operations and some other things which cannot be performed on other tables , danikosam use chestaru...fro example: select sysdate from dual; select 2*5 from dual
deals2buy Posted April 18, 2013 Report Posted April 18, 2013 [quote name='CheGuevara' timestamp='1366302488' post='1303626606'] multi insert ki example evvu... dual anedi oka dummy table in oracle ...adi some system operations and some other things which cannot be performed on other tables , danikosam use chestaru...fro example: select sysdate from dual; select 2*5 from dual [/quote]Examples of Multi Inserts [CODE] MULTI INSERT WITH ALL FIELDS SQL> Insert all Into student values(1,’a’,100) Into student values(2,’b’,200) Into student values(3,’c’,300) Select *from dept where deptno=10; -- This inserts 3 rows MULTI INSERT WITH SPECIFIED FIELDS SQL> insert all Into student (no,name) values(4,’d’) Into student(name,marks) values(’e’,400) Into student values(3,’c’,300) Select *from dept where deptno=10; -- This inserts 3 rows MULTI INSERT WITH DUPLICATE ROWS SQL> insert all Into student values(1,’a’,100) Into student values(2,’b’,200) Into student values(3,’c’,300) Select *from dept where deptno > 10; [/CODE] and coming to dual..thanks....functions use chesetappudu mostly dummy use chestaranamata...simple ga pettakunda malli dummy use chese la pettadu enduko Oracle vaadu...it seems like a drawback for me
Nippu tunaka Posted April 18, 2013 Report Posted April 18, 2013 oracle apps dba vaallunte cheppandi vayya....trining isthara evarina
subbayya Posted April 19, 2013 Report Posted April 19, 2013 [quote name='Kaarthikeya' timestamp='1366294369' post='1303625580'] ee statement ichinappudu prati sari values enter chesaaka malli statement execute cheyyakunda values enter cheyyadam ela toad lo? [CODE] insert into DEPT values(&no, &name, &loc) [/CODE] [/quote] Never depend on GUI tools...U can't learn concepts....!! Those who rely on GUI... Will die because of GUI.
subbayya Posted April 19, 2013 Report Posted April 19, 2013 [color=#333333][font=Georgia,]Can any DBA master give some insight on below scenario?[/font][/color] [color=#333333][font=Georgia,]You have 4 instances running on the same UNIX box. How can you determine Which shared memory and semaphores are associated with which instance?[/font][/color]
BadBoy23 Posted April 19, 2013 Report Posted April 19, 2013 Guys any internal oracle dba positions let me know plzzz looking for a job pm please will send resume !!!!
Anta Assamey Posted April 19, 2013 Report Posted April 19, 2013 [img]http://lh3.ggpht.com/-8RwT8_LLHM4/UOoO_Lps31I/AAAAAAAAIyk/-Y1PHoxQ2yY/s150/Brahmi.gif[/img]
deals2buy Posted April 19, 2013 Report Posted April 19, 2013 [quote name='grandfather' timestamp='1366333743' post='1303629991'] Never depend on GUI tools...U can't learn concepts....!! Those who rely on GUI... Will die because of GUI. [/quote]ya ante new bhayya...mari endulo practice cheyyalo cheppava koddiga... [quote name='grandfather' timestamp='1366339212' post='1303630365'] [color=#333333][font=Georgia,]Can any DBA master give some insight on below scenario?[/font][/color] [color=#333333][font=Georgia,]You have 4 instances running on the same UNIX box. How can you determine Which shared memory and semaphores are associated with which instance?[/font][/color] [/quote]I still wonder all the time why Oracle people always work together with Unix? [quote name='Brahmanandam_AFDB' timestamp='1366358017' post='1303631677'] [img]http://lh3.ggpht.com/-8RwT8_LLHM4/UOoO_Lps31I/AAAAAAAAIyk/-Y1PHoxQ2yY/s150/Brahmi.gif[/img] [/quote]induloki kuda vachava?
nexus Posted April 19, 2013 Report Posted April 19, 2013 misc-db-11g:____> export ORACLE_SID=secdb misc-db-11g:secdb> which sysresv /u01/app/oracle/product/11.2.0/dbhome_1/bin/sysresv misc-db-11g:secdb> sysresv IPC Resources for ORACLE_SID "secdb" : Shared Memory: ID KEY 5308425 0x0ff52fec Semaphores: ID KEY 425986 0x7695ab8c Oracle Instance alive for sid "secdb" misc-db-11g:secdb> ipcs -a ------ Shared Memory Segments -------- key shmid owner perms bytes nattch status 0x00000000 4653057 root 644 80 2 0x00000000 4685827 root 644 16384 2 0x00000000 4718596 root 644 280 2 0x445a7b78 4784133 grid 660 4096 0 0x00000000 4816902 oracle 644 790528 2 dest 0x00000000 4849671 oracle 644 790528 2 dest 0x00000000 4882440 oracle 644 790528 2 dest 0x0ff52fec 5308425 oracle 640 4096 0 ------ Semaphore Arrays -------- key semid owner perms nsems 0xc2fe2008 131073 grid 660 104 0x7695ab8c 425986 oracle 640 154 ------ Message Queues -------- key msqid owner perms used-bytes messages "sysresv" shows shared memory segments and semaphore info for the current ORALCE_SID
KOTC Posted April 19, 2013 Author Report Posted April 19, 2013 [quote name='nexus' timestamp='1366379423' post='1303632437'] misc-db-11g:____> export ORACLE_SID=secdb misc-db-11g:secdb> which sysresv /u01/app/oracle/product/11.2.0/dbhome_1/bin/sysresv misc-db-11g:secdb> sysresv IPC Resources for ORACLE_SID "secdb" : Shared Memory: ID KEY 5308425 0x0ff52fec Semaphores: ID KEY 425986 0x7695ab8c Oracle Instance alive for sid "secdb" misc-db-11g:secdb> ipcs -a ------ Shared Memory Segments -------- key shmid owner perms bytes nattch status 0x00000000 4653057 root 644 80 2 0x00000000 4685827 root 644 16384 2 0x00000000 4718596 root 644 280 2 0x445a7b78 4784133 grid 660 4096 0 0x00000000 4816902 oracle 644 790528 2 dest 0x00000000 4849671 oracle 644 790528 2 dest 0x00000000 4882440 oracle 644 790528 2 dest 0x0ff52fec 5308425 oracle 640 4096 0 ------ Semaphore Arrays -------- key semid owner perms nsems 0xc2fe2008 131073 grid 660 104 0x7695ab8c 425986 oracle 640 154 ------ Message Queues -------- key msqid owner perms used-bytes messages "sysresv" shows shared memory segments and semaphore info for the current ORALCE_SID [/quote] GP
Recommended Posts