1.Group By Clause1.Group By Clause2. Months_between 3.Select Clause 4. Create User In Oracle5. View In Oracle6. Conversion Function In Oracle7. In Clause 8. Using Clause9.Truncate ,Drop,Delete Commands10. Convert-number-into-wo...
Thursday, August 28, 2014
Wednesday, August 27, 2014
Implicit Cursor Rowcount
Example :-write PL/SQL Block, the salaries of all the employees in the ‘employees’ fromdepartment_no 50 are updated. If none of the employee’s salary are updated we get amessage 'None of the salaries where updated'.Else we get a message like for example, 'Salaries are updated'Implicit cursors are automatically created when you issueselect...
Saturday, August 23, 2014
PLSQL Interview Questions
(adsbygoogle = window.adsbygoogle || []).push({}); HOME1.How Many triggers can be applied to a table?There are maximum 12 triggers can be applied to a table.2. Difference between Syntax error & runtime error in PLSQL?A Syntax error is easily identified by a PLSQL compiler.For example Incorrect spelling.but runtime error can be handled with the...
Friday, August 22, 2014
Example Of Constraints in Sql
Primary Key:- YOU CAN NOW CREATE A PRIMARY KEY IN oracle with the CREATE TABLE STATEMENT.SYNTAXTHE SYNTAX TO CREATE A PRIAMARY KEY USING THE CREATE TABLE STATEMENT IN ORACLE/PLSQL IS: create table empl(employee_id number primary key, last_name varchar2(50), city varchar2(50)) /SyntaxAlter table table_nameAdd column column_definationAdd...
Thursday, August 21, 2014
Oracle-Sql-Basic_Queries
1.Get the first_day of the MonthSQL> SELECT TRUNC (SYSDATE, 'MONTH') "First day of current month" 2 FROM DUAL;First day---------01-AUG-142.Get the Last_day of the Current MonthSELECT TRUNC (LAST_DAY (SYSDATE)) "Last day of current month" FROM DUAL;3.Write a query that check if a table exists...
Tuesday, August 19, 2014
Conversion function
Implicit conversion:-A varchar2 or char value can be implicitly converted to Number or date type value by oracle.Similarly, a number or data type can be automatically Converted to character data by oracle server.For example the below select queries .both the queries will Give the same output because oracle internally treats 10000And '10000' are same.Query-1select...
Friday, August 15, 2014
Convert Number Into Words
1. How can you convert a number into words using Oracle Sql Query?Please see the query below:-SELECT TO_CHAR (TO_DATE (523, 'j'), 'jsp') from dualOutput:TO_CHAR(TO_DATE(523,'J'),-------------------------five hundred twenty-three2. Write a pl sql block that count the department wise total salary where more than 5 employees are exists. SELECT ...
Create User in Oracle
CREATE USER user in Oracle Controlling User AccessIn a multiple-user environment, you want to maintain security of the database access and use. With Oracle server database security, you can do the following:Control database access.Give access to specific objects in the database.Confirm given and received privileges with the Oracle data dictionary.Create...
Tuesday, August 12, 2014
What is View in oracle
How to Create SQL ViewIntroduce to SQL ViewSQL View is a virtual table which is used to encapsulate a complex queries. After creating SQL view, you can treat a view as a table and manipulate data on it with only some restrictions. When the data in table changes, the data in view which is dependent on table changes also. View does not occupied the...
Working With Bfiles
Managing BfilesManipulating Large ObjectsA LOB is a data type that is used to store large, unstructured data such as text, graphic images, video clippings, and soon. Structured data, such as a customer record, may be a few hundred bytes, but even small amounts of multimedia data canbe thousands of times larger. Also, multimedia data may reside in operating...
Thursday, August 7, 2014
Locate a Test Center
1) PROMETRIC TESTING (P) LTD MARWAH HOUSE, SAKI VIHAR ROADSAKI NAKA, ANDHERI EASTMUMBAI, Maharashtra 400072Phone: 022-28573160Site Code: II004 2) NIIT LTD. BANDRA-MUMBAI 2ND FLOOR GURUVIDYA C.H.S98/A HILL ROADOPP.BANDRA POLICE STATIONBANDRA(W)MUMBAI, Maharashtra 400 050Phone: 022-26451126/4493Site Code: II7 3) HORIZON COMPUTER A-WING307, OM RACHNA...
Tuesday, August 5, 2014
Monday, August 4, 2014
IF-THEN-STATEMENT IN ORACLE
The following is the example using IF_Then statement in an oracle Note:- Once a condition is found is true,then if-Then-statement will execute the corresponding code and not evaluate the conditions any further.SQL> DECLARE 2 V_NAME EMPLOYEES.LAST_NAME%TYPE; 3 V_SAL EMPLOYEES.SALARY%TYPE; ...
Saturday, August 2, 2014
triggers in Oracle
Trigger ActionA trigger act is the procedure (pL/SQL block) that contains the SQL statement and pL/SQL code to be executed when a triggering statement is issued and the trigger restriction evaluates to TRUE.Like to stored procedures, a trigger action can contain SQL language constructs (variables ,constants ,cursors, exceptions, and so on),and call...
Friday, August 1, 2014
PLSQL-Interview-Questions
1.How Many triggers can be applied to a table?There are maximum 12 triggers can be applied to a table.2. Difference between Syntax error & runtime error in PLSQL?A Syntax error is easily identified by a PLSQL compiler.For example Incorrect spelling.but runtime error can be handled with the help of Exception Section block in PLSQL.3.How to disabled...
