1.Group By Clause
1.Group By Clause
2. Months_between
3.Select Clause
4. Create User In Oracle
5. View In Oracle
6. Conversion Function In Oracle
7. In Clause
8. Using Clause
9.Truncate ,Drop,Delete Commands
10. Convert-number-into-words...
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’ from
department_no 50 are updated. If none of the employee’s salary are updated we get a
message 'None of the salaries where updated'.
Else we get a message like for example, 'Salaries are updated'
Implicit cursors are automatically created when...
Saturday, August 23, 2014
PLSQL Interview Questions
(adsbygoogle = window.adsbygoogle || []).push({});
HOME
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...
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.
SYNTAX
THE 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))
/
Syntax
Alter table table_name
Add column...
Thursday, August 21, 2014
Oracle-Sql-Basic_Queries
1.Get the first_day of the Month
SQL> SELECT TRUNC (SYSDATE, 'MONTH') "First day of
current month"
2 FROM DUAL;
First day
---------
01-AUG-14
2.Get the Last_day of the Current Month
SELECT TRUNC (LAST_DAY (SYSDATE)) "Last day of current
month"
FROM DUAL;
3.Write a query...
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 10000
And '10000'...
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 dual
Output:
TO_CHAR(TO_DATE(523,'J'),
-------------------------
five hundred twenty-three
2. 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 Access
In 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...
Tuesday, August 12, 2014
What is View in oracle
How to Create SQL View
Introduce to SQL View
SQL
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...
Working With Bfiles
Managing Bfiles
Manipulating Large Objects
A LOB is a data type that is used to store large, unstructured data such as text, graphic images, video clippings, and so
on. Structured data, such as a customer record, may be a few hundred bytes, but even small amounts of multimedia data can
be thousands of times larger. Also, multimedia data may reside...
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 Action
A 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...
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...
