Basics of SQL with example - I

/*
SELECT column_name(s)
FROM table_name

and

SELECT * FROM table_name
*/

Select *
From STUDENT

/*
CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
column_name3 data_type,
....
)
*/

Create TABLE STUDENT
(
STUDENT_ID NUMBER,
STUDENT_NAME VARCHAR2(10),
JOIN_YEAR DATE
)

/*
It is possible to write the INSERT INTO statement in two forms.

The first form doesn't specify the column names where the data will be inserted, only their values:

INSERT INTO table_name
VALUES (value1, value2, value3,...)

The second form specifies both the column names and the values to be inserted:

INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)
*/

INSERT INTO STUDENT
VALUES(10, 'AMITAB', '12-JAN-1968')

/*
UPDATE table_name
SET column1=value, column2=value2,...
WHERE some_column=some_value
*/
UPDATE STUDENT
SET STUDENT_ID=1
Where STUDENT_ID=10

/*
The DELETE Statement
The DELETE statement is used to delete rows in a table.
SQL DELETE Syntax

DELETE FROM table_name
WHERE some_column=some_value

Note: Notice the WHERE clause in the DELETE syntax. The WHERE clause specifies which record or records that should be deleted. If you omit the WHERE clause, all records will be deleted!
*/

DELETE FROM STUDENT
WHere student_id = 1

trunc and trim function

what is the difference between trunc and trim function

Steps for custom forms/report

can some one tell me what to do after creating a custom report...

like where to put it and do the necessary steps to make it avialble in oracle

 

getting item price from back end

Can some one help me in getting the prices of items from back end...

what are the tables involved

 

How to change the...

How to change the SQL developer language to english

I am working in Germany and the laptop OS is in German. The SQL developer is picking the language as German
how can I change this to english

How to remove carriage...

How to remove carriage return and line feed from bank payment format.

I have tried the below 4 but nothing is working. The bank payment file is always printing a CR LF at the end

v_chr_l_sec:= regexp_replace(v_chr_z_rec,'([^[:graph:]||^[:blank:]])',''); /*Remove CR LF*/
              v_chr_l_sec:= regexp_replace(v_chr_z_rec,chr(13)||chr(10),'');
              v_chr_l_sec:= regexp_replace(v_chr_z_rec,chr(13),'');
              v_chr_l_sec:= regexp_replace(v_chr_z_rec,chr(10),'');

Query

How to get all rows from a table which are having special characters in its data

Vinita

Excellent plugin, anamizg idea, greatMy only problem is that i am showing different ads for different categories. For example:if this post is category a'show ad a'if this post is category b'show ad b'And i can't think how to maintain that while integrating this plugin. I either need a way to do:if this post is category c'ad_buttons(c)or justad_buttons()And have it automatically detect the category based on settings. But the first option would be awesome enough. I guess basically i just need multiple instances of the ad_button, as was mentioned previously in the comments but for another purpose.Keep up the great work, really awesome.Cheers!!

Profile option

What is the profile option to the see the field name from the front end form? I am not remembering it. If we set this profile then we dont need to enter the apps password

OLTP & OLAP

what is OLTP & OLAP

Project Invitation

Post your requirements and develop in effective manner

Regarding Certification

hi i am oracle in a oracle apps from last 1 year i want to do certification so which would be better for me i am technical guy should i start with oca/ocp or direct apps plz suggest me thanks gaurav