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 5452SQL> 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 2327What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
1101how 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 2285Is 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.
159Post New Infosys Oracle General Interview Questions
if a number of plc s are there then how many modbus to be used
HOw to add the recovery file at runtime to the test file .
write a sql query retrive all xml data. how to retrive xml data wit single sql query.
How do you avoid the "Invalid use of null" error when reading null values from a database?
sir,please give me some exam paper for referance. Thanks & Regards,
why you done mba in finance
what is generics? can u explain 5 to 6 examples on generics that covers class,method,structure,list,delegates?
what is meaning of bus riser
value momentum
What are the ITU-T (CCITT) Standards ?
what is a CopyCursor ?
All technical,written test questions
what is the advaantage of each user having its own copy of the shell?
What is Sobel gradient filters?
What is the working mechanism of OLTC in Power Transformers????
- 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)
