How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
2 5529SQL> CREATE TABLE to_table 2 (col1 NUMBER); Table created. SQL> CREATE OR REPLACE TRIGGER statement_trigger 2 AFTER INSERT ON to_table 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('After Insert Statement Level'); 5 END; 6 / Trigger created. SQL> CREATE OR REPLACE TRIGGER row_trigger 2 AFTER INSERT ON to_table 3 FOR EACH ROW 4 BEGIN 5 DBMS_OUTPUT.PUT_LINE('After Insert Row Level'); 6 END; 7 / Trigger created. SQL> INSERT INTO TO_TABLE VALUES(1); After Insert Row Level After Insert Statement Level 1 row created. SQL> BEGIN 2 INSERT INTO TO_TABLE VALUES(2); 3 INSERT INTO TO_TABLE VALUES(3); 4 INSERT INTO TO_TABLE VALUES(4); 5 INSERT INTO TO_TABLE VALUES(5); 6 INSERT INTO TO_TABLE VALUES(6); 7 INSERT INTO TO_TABLE VALUES(7); 8 INSERT INTO TO_TABLE VALUES(8); 9 INSERT INTO TO_TABLE VALUES(9); 10 INSERT INTO TO_TABLE VALUES(0); 11 END; 12 / WAT LL BE THE O/P??? XPLAIN IT>>>>
1 2382What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
1129how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?
1 2331Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
189Post New Infosys Oracle General Interview Questions
• What are the types of cash flows?
if main CT is of ratio 50/5, and meter CT is -/5 what will be overall multiplying factor of meter.PT is 11000/110 .
What are the main constrains of SCSI in storage networking?
Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya
How to start a keratinocyte culture?
How to do transport at OS level?
Can anyone tell me how can i get benefited if I am an MBA(HR) with LL.B background?Do I have more opportunities than only MBA'S? If so which industry is best for me to utilize my degrees? Where would i get more opportunities?
How do you compute moisture correction using the parameters gathered from Nuclear Density Gauge Apparatus and the moisture contents results from the lab.?
explain ur testing project? how can u nexplain . what should we explain ? i have not worked on any project?
which background process invoke at the time of upgradation tell me???
plz.mail me model papers of drug inspector of chhattisgarh..or MP.if Posible. Mail Id-recha_1428@rediffmail.com...mrs_1428@rediffmail.com,
Under wat condition statcom operates as an inductor for the transmission line?
What is the formula to calculate the rating of power cable for three phase current.
All technical questions
Would the Advertising copy turn anyone off? Does it appropriately reflect our company?
- Software (1)
- C (95)
- STL (3)
- OOPS (27)
- C++ General (22)
- MFC (3)
- VC++ AllOther (2)
- Delphi (4)
- Python (2)
- PHP (10)
- Programming Languages AllOther (12)
- ASP (2)
- JavaScript (8)
- VB Script (2)
- JSP (1)
- Shell Script (2)
- AJAX (1)
- SNMP (1)
- SS7 (1)
- Networking Administration (9)
- Networking Security (2)
- Networking AllOther (3)
- Visual Basic (11)
- C Sharp (6)
- ASP.NET (33)
- VB.NET (7)
- ADO.NET (6)
- IIS (3)
- Dot Net Framework (6)
- Dot Net General (5)
- Dot Net AllOther (3)
- SharePoint (1)
- Microsoft Related AllOther (1) Oracle General (14)
- OCI (1)
- Database Management (3)
- Forms Reports (1)
- Oracle AllOther (3)
- SQL Server (19)
- MySQL (3)
- DB Architecture (1)
- DB Administration (1)
- DB Development (1)
- SQL PLSQL (19)
- Databases AllOther (4)
- SDK (1)
- Windows General (1)
- Windows AllOther (5)
- Linux Commands (2)
- Linux IPC (1)
- Linux Socket Programming (1)
- Linux System Calls (1)
- Unix Commands (27)
- Unix IPC (2)
- Unix General (1)
- Unix AllOther (3)
- Solaris Commands (2)
- Solaris General (1)
- Solaris AllOther (2)
- RTOS AllOther (1)
- Operating Systems General Concepts (7)
- Data Structures (5)
- Operating Systems AllOther (1)
- WinRunner (5)
- Load Runner (6)
- QTP (44)
- Test Director (3)
- Rational TestSuite (1)
- Silk Test (1)
- Selenium (1)
- Automation Testing AllOther (3)
- Manual Testing (93)
- QA Concepts (11)
- Mobile Testing (2)
- Test Cases (10)
- Test Documents Reporting (2)
- Testing AllOther (11)
- Servers AllOther (1)
- COBOL (9)
- JCL (10)
- CICS (1)
- DB2 (9)
- Assembler (1)
- VSAM (5)
- IBM MainFrame AllOther (1)
- DB400 (1)
- COOLPLEX (1)
- Core Java (54)
- Advanced Java (6)
- Swing (1)
- EJB (2)
- Servlets (5)
- Struts (7)
- JDBC (5)
- JMS (1)
- J2EE (3)
- Weblogic (3)
- Websphere (1)
- Java J2EE AllOther (2)
- Java Related AllOther (2)
- HTML DHTML (1)
- Teradata (7)
- Business Objects (14)
- Cognos (10)
- Informatica (14)
- Crystal Enterprise Suite (1)
- Ab Initio (2)
- Data Stage (8)
- SAS (2)
- Micro Strategy (3)
- ETL (7)
- Data Warehouse General (1)
- HR Questions (16)
- Design Patterns (6)
- UML (3)
- OOAD (2)
- Project Planning (9)
- Technical Writer (1)
- Software Design AllOther (1)
- GDB (1)
- Debugging AllOther (3)
- Telecom Routers Switches (1)
- VoIP IP Telephony (1)
- BlueTooth (1)
- Telecom General (2)
- SAP Basis (19)
- SAP ABAP (122)
- SAPScript (1)
- SAP SD (29)
- SAP MM (11)
- SAP QM (1)
- SAP PP (1)
- SAP PS (1)
- SAP FI CO (48)
- SAP HR (6)
- SAP CRM (52)
- SAP Business Warehouse (6)
- SAP Security (8)
- SAP B1 (1)
- SAP Business Objects BO BOBJ (2)
- PeopleSoft Financials (4)
- PeopleSoft Tools (1)
- Oracle Apps Technical (9)
- Oracle Apps Financial (7)
- Oracle Apps SCM (2)
- Oracle Install Base (1)
- ERP CRM AllOther (1)
- 86 Family (2)
- VLSI (3)
- Client Server Architecture (1)
- Client Server General (2)
- AI General (2)
- AI AllOther (1)
- TIBCO (1)
- JCAPS (1)
- Image Processing Algorithms (2)
- Micro Biology (1)
- Bio Informatics (2)
- Botany (1)
- General Physics (2)
- Geo Physics (1)
- Organic Chemistry (1)
- Inorganic Chemistry (2)
- General Chemistry (1)
- Mathematics (1)
- General Science (2)
- Sciences AllOther (1)
- Civil Engineering (13)
- Mechanical Engineering (14)
- Electrical Engineering (40)
- Electronics Communications (61)
- Instrumentation (3)
- Automobile Engineering (1)
- Engineering AllOther (24)
- Business Administration (7)
- Marketing Sales (10)
- Banking Finance (24)
- Human Resources (20)
- Infrastructure Management (1)
- Non Technical (3)
- Business Management AllOther (4)
- Audit (5)
- CompanyAffairs CS (3)
- Taxation (14)
- Accounting General (35)
- Accounting AllOther (37)
- Call Centre AllOther (108)
- Designing (1)
- UPSC Political Science (1)
- UPSC History (1)
- UPSC General Studies (3)
- SSC Political Science (3)
- SSC General Studies (1)
- SSC AllOther (1)
- RRB (2)
- CDS (3)
- NDA (3)
- BSRB Clerical (3)
- Group I (4)
- Group II History (2)
- Group II AllOther (1)
- Group II Political Science (1)
- APPSC AllOther (8)
- General Knowledge_Current Affairs (42)
- Government AllOther (6)
- Law AllOther (3)
- Chefs (1)
- Tourism Hotel AllOther (1)
- Teaching (1)
- Funny Interview Questions (8)
- Everything Else AllOther (13)
- English (18)
- General Aptitude (118)
- Puzzles (49)
- Placement Papers (58)
- CCNA (16)
- Microsoft Certifications (3)
- Sun Certifications (3)
- Oracle Certifications (3)
- ISTQB Certification (1)
- Certifications AllOther (1)
- H1B Visa (5)
- USA Student Visa F1 Visa (3)
- L1 Visa (9)
- USA Business Visa B1 Visa (4)
- USA Dependent Visa H4 Visa (3)
- UK Visa (3)
- C Code (12)
- C++ Code (4)
- MFC Code (1)
- J2SE Code (2)
- ASP.NET Code (1)
- C Sharp Code (3)
- Visual Basic Code (1)
- JavaScript Code (4)
- VB Script Code (1)
- Scripts_Markup Code AllOther (1)
- GATE (5)
- IIT JEE (1)
- CAT (2)
- ICET (5)
- C C++ Errors (1)
- DotNet Errors (1)
- SQLServer Errors (1)
- Scripts Errors (1)
