Happy New Year 2014

Happy New Year 2014

For a happy New Year, just stick to some simple and basic rules. Have faith in yourself and your abilities. Count your blessings before you cry on your misfortunes. Learn to take each day one at a time. Create opportunities for yourself for quitting is never an option. Above all accomplish all you take under your wings – never abandon without completion.

Link Between PA and AR

Link between PA and AR is....

PA_PROJECTS_ALL.SEGMENT1=RA_CUSTOMER_TRX_ALL.INTER FACE_HEADER_ATTRIBUTE1

Rate This Post Widget

Hi viewers,

Today I added one New Widget of Rate This Post.
So please rate posts, by that I know your feedback and it is also helpful to develop this site.

Thanking You......

How to Display String Vertically in Oracle?

Query to display string vertically by Oracle:

SELECT SUBSTR ('&&STRING', ROWNUM, 1) Vertical
FROM DBA_OBJECTS
WHERE ROWNUM <= LENGTH (TRIM ('&STRING'));
The qwery asks String when execute in Toad or Sql Developer. Then Give String Like Rajashekar, Then it will display it as shown below.

R
a
j
a
s
h
e
k
a
r

SQL Lesson 7

Lesson 7:

III)  DQL/DRL

DQL means Data Querying Language. DRL means Data Retrieving Language. This is used to get the data from Data base. DQL is also called as DRL. We can use DQL Command to display data from Data base. The only one command in DQL is SELECT.

I)    SELECT

This command is used to fetch the data from data base.

Syntax: Select * from table_name;

Select col1, col2, col3 from table_name;

Ex: Select * from EMP;

Select Empno, Ename, Sal from EMP;

 

We are still Updating this site......

Lesson 1
Lesson 2
Lesson 3
Lesson 4
Lesson 5
Lesson 6