Anchored datatype in PL/SQL %TYPE %ROWTYPE Attribute - PL/SQL Training in Tamil தமிழில்
Вставка
- Опубліковано 23 кві 2021
- #JUSTIN#ORACLE#SQL#TAMIL#oracle#sqlinterviewquestions#sqlinterviewquestionsandanswers
*****************************************************************************************************
🌕Want to join WhatsApp Group? (Only technical discussion, no spam messages, no promotion msg)
📌Oracle-PLSQL
github.com/nicitacademy/PLSQL
*****************************************************************************************************
Oracle SQL - Complete tutorial Playlist
• Oracle SQL - தமிழில்
*****************************************************************************************************
Oracle PL/SQL - Complete tutorial Playlist
• Oracle PLSQL Training ...
*****************************************************************************************************
Oracle SQL Day wise Video:
Oracle SQL in Tamil - Day 1 - • Day 1 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 2 - • Day 2 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 3 - • Day 3 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 4 - • Day 4 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 5 - • Day 5 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 6 - • Day 6 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 7 - • Day 7 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 8 - • Day 8 - SQL in TAMIL |...
*****************************************************************************************
PLSQL Session 1:Indroduction
• Oracle pl sql tutorial...
PLSQL Session 2:DML Statement
• Session 2 - DML Statem...
PLSQL Session 3:IF and Case Statement
• PLSQL Session 3 - IF a...
PLSQL Session 4:Looping Statements
• Looping statements in ...
PLSQL Session 5: Anchored datatype in PL/SQL %TYPE %ROWTYPE
• Anchored datatype in P...
PLSQL Session 6: Stored Procedure
• Session 6 - Stored Pro...
***********************************************************************************************
Session Notes:
--------------------------
Anchored datatype in PL/SQL: NiC IT Academy
============================
%TYPE Attribute
syntax:
variable_name tablename.column_name%TYPE;
%ROWTYPE
Syntax:
variable_name table_name%rowtype;
----------------------------------------------------------------
Use of this attribute:
* Impact of structure or data type changes in the base table
* Dynamic way of allocating the data type in PLSQL code
Sample table customer:
======================
CREATE TABLE HR.CUSTOMER
(
CUSTOMER_ID NUMBER(6,0),
FIRST_NAME VARCHAR2(30),
MOBILE_NO NUMBER(10,0),
ADDRESS1 VARCHAR2(30),
ZIPCODE NUMBER(6,0),
COUNTRY VARCHAR2(30)
);
Insert into CUSTOMER (CUSTOMER_ID,FIRST_NAME,MOBILE_NO,ADDRESS1,ZIPCODE,COUNTRY)
values (100000,'Sravanthi',1234678906,'rtretr retre',400027,'India');
Insert into CUSTOMER (CUSTOMER_ID,FIRST_NAME,MOBILE_NO,ADDRESS1,ZIPCODE,COUNTRY)
values (100001,'Sneha',9090909090,'No.2 VGP nagar',453254,'India');
Insert into CUSTOMER (CUSTOMER_ID,FIRST_NAME,MOBILE_NO,ADDRESS1,ZIPCODE,COUNTRY)
values (100002,'Chandra',9191919191,'Framingham',192132,'USA');
Insert into CUSTOMER (CUSTOMER_ID,FIRST_NAME,MOBILE_NO,ADDRESS1,ZIPCODE,COUNTRY)
values (100003,'Suresh',5678453233,'G1, Balaji Nagar',774225,'Australia');
Insert into CUSTOMER (CUSTOMER_ID,FIRST_NAME,MOBILE_NO,ADDRESS1,ZIPCODE,COUNTRY)
values (100004,'Sridhar',7650099124,'Pond Street',777223,'CANADA');
commit;
select * from customer;
desc customer;
declare
v_mobile_no number(10);
v_customer_id number :=&customer_id;
begin
select mobile_no into v_mobile_no from customer where customer_id=v_customer_id;
dbms_output.put_line('The mobile number of the customer '||v_customer_id||' is '||v_mobile_no);
end;
Modified code with %type attribute:
------------------------------------
declare
v_mobile_no customer.mobile_no%type;
v_customer_id number :=&customer_id;
begin
select mobile_no into v_mobile_no from customer where customer_id=v_customer_id;
dbms_output.put_line('The mobile number of the customer '||v_customer_id||' is '||v_mobile_no);
end;
-----------------------------------------------------------
declare
vcustomer customer%rowtype;
begin
select * into vcustomer from customer where customer_id=100004;
dbms_output.put_line(vcustomer.mobile_no);
dbms_output.put_line(vcustomer.country);
end;
Oracle pl sql tutorial - %TYPE and %ROWTYPE
Record type in Oracle PL/SQL
Oracle Interview Question - oracle %rowtype and %type
Oracle pl sql tutorial - %TYPE and %ROWTYPE
What is %type and %rowtype variable in oracle PL/SQL
Records in Oracle PLSQL
Oracle %ROWTYPE attribute
Oracle PLSQL in tamil
*Complete 48 hours of Self-Paced Courses and Interview Questions Links:*
courses.nicitacademy.com/
Are you interested in joining my Live training? or Self-Paced course?
You can visit our website for more details.
www.nicitacademy.com/
Contact me for more details @ 🌕 wa.link/m4lat0
*WhatsApp group:*
chat.whatsapp.com/KMN5pKoLGSu8PuFLxSouB0
Thanks,
NiC IT Academy
=======================================================================
🔵Oracle SQL Tutorial - English
ua-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
📌*IICS demo session:*
ua-cam.com/video/C1zGVRFM3-A/v-deo.html
📌*Informatica Full Course:*
ua-cam.com/video/V2FtZ_INmjg/v-deo.html
📌*SQL Full Course:*
ua-cam.com/video/iuvzjf7nU1I/v-deo.html
📌*Informatica, IICS, and SQL playlist*
🌕 IICS Tutorial ENGLISH - Playlist
ua-cam.com/play/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj.html
🌕 Informatica training in ENGLISH - Playlist
ua-cam.com/play/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd.html
🌕 Informatica Interview Preparation - ENGLISH
ua-cam.com/play/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d.html
🌕Oracle SQL - தமிழில்
ua-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html
🔵 Informatica training in தமிழில் - Playlist
ua-cam.com/play/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3.html
🔵 Informatica Interview Preparation - TAMIL
ua-cam.com/play/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD.html
🔵Unix for Informatica Developer
ua-cam.com/play/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw.html
🌕Informatica Project videos
ua-cam.com/play/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6.html
Please subscribe, Like, and comment. I will post more videos.
Thanks
Good example with clear explanation, thanks for sharing your knowledge......keep it up
Thanks and welcome
Please upload a videos for triggers, function, cursor, exception
Wow.. superw explanation👍
Thank you 🙂
declare
cursor a is select employee_id from employees;
type bb is table of employees.employee_id%type;
b bb;
begin
open a;
loop
fetch a bulk collect into b limit 20;
exit when a%rowcount=0;
forall c in b.first..b.last save exceptions
insert into emp(eid) values(b(c));
commit;
end loop;
close a;
exception
when others then
dbms_output.put_line(sql%bulk_exceptions.count);
end;
/
the above query is still executting but emp table name from eid primary key column not insert in datas pls tell me solutions
Hii sir nice explanation. Please do full course on PLSQL. Thanks.
Will upload soon
Nyz explaination sir...pls do videos on unix
Sure
I am kindly requesting this video available only in 720p could you reupload 1080p this session 5 only.becuase when will see in big screen 28 inch system monitor Seeming like low resolution.it is my humble request sir😊
please explain about very important system defined tables and other features like procedure encryption etc
Sure, Noted.
Bro can you upload video for temp tables
sure, I will do.
Hi sir,
Nice explanation sir and I am unable to find session-4 video. Could you please help me on that?
Hi Santhosh, I am working on the video and I will upload soon. Keep watching my channel. I will upload more videos.
How to check explain plan in SQL developer tool please tell me query
Hi Manivannan,
explain plan for 'select statement' and then run this below query
select * from table(dbms_xplan.display());
Cursor and bulk concepts video upload panitingala sir...?
Yes, sure
Anna supera edukarenga please collection and cursor la solunga apadiye realtime vaichu solunga apo inu clear agu ungalukaga naraya subscriber waiting na refer pandren please podunga
Hi Hari, Sure. Thanks for your valuable feedback. Keep watching. I will update soon.
Anna unga contact kidaikuma
It is available in 'about' section in our channel.
session 5 varalaye sir
I will post ASAP one by one, Keep watching